Crystal Report with Visual Sutio.NEt 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
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
 
Back
Top