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
"George Hardy" wrote:
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
"GC" <GC@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com... 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!