August 31, 2012 at 9:54 am
Hello,
I have created the stored procedure. Now I am accessing the same in the crystal reports. But when I preview the report, there is no data.
What can be the problem?
August 31, 2012 at 10:06 am
deepeshdhake (8/31/2012)
Hello,I have created the stored procedure. Now I am accessing the same in the crystal reports. But when I preview the report, there is no data.
What can be the problem?
Network down?
Computer taking a break because it is tired?
Proc doesn't work?
Proc has no data for the parameters provided?
Connection string to wrong database?
Loaded wrong report?
The point I am making is that you haven't really asked a question at this point. Provide some details about the issue and we can help.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 31, 2012 at 10:49 am
No there is no network down. Stored proc is working good. But I cannot see the result in crystal reports.
August 31, 2012 at 10:53 am
deepeshdhake (8/31/2012)
No there is no network down. Stored proc is working good. But I cannot see the result in crystal reports.
This isn't a crystal reports forum but I can try. What have you done so far to eliminate issues? Have a run a trace when the report loads to see what sql is actually running? I would start there. At least then you will know if the issue is on the sql side or the crystal side.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply