Crystal Report with Visual Sutio.NEt 2003

[Guest]

HI,

I'am using Crystal Report with visual Studio .NEt 2003

When i make a report using a store procedure, I can not see all the fields
of the store proc and i'm suppose to see those fields. I'm suppose to see a
"+" sign at the left of the store procedure name in the Field Explorer section

When we click on the sign "+" we see all the field of the store proc.
We can from there select and drag those fileds on the report.

My problem is that there is no Sign "+" at the left of the store procedure
name in the Field Explorer section

I had this problem with Visual studio 2002 and i resolve it by installing
the crystal report service pack for Visual studio 2002.

I did the same thing with Visual studio 2003 but the problem still there
after installing crystal report service pack 2 for visual studio .net 2003

Do you have any idea of what i can do!

 

[George Hardy]

try doing a "verify database"....if that doesn't help, try the "log on or
off server" or "set datasource location" and make sure the dataset is
available to you.

hope this helps.

george hardy

 

[Guest]

Thank for helping me

I Find the problem

The problem was the store procedure
For performance reason I optimise my store proc by using Virtual Table
I at the end of my script I make a Select on 3 virtual table

The performance is a lot faster but Crystal report dont seem to know what
are the final field to show in crystal report.

So with a simple select everything is fine
The work around is to insert the result of my store proc in a real table in
the database only for this report

And use another store proc for the report that make a simple select on this
table

Thank for your help