Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Report is not displaying the data? Post Reply Post New Topic
Author Message
nmmure
Newbie
Newbie


Joined: 06 Apr 2007
Location: United States
Online Status: Offline
Posts: 2
Quote nmmure Replybullet Topic: Report is not displaying the data?
    Posted: 06 Apr 2007 at 4:17pm
Hi,

I am running report using stored procedure; Report is not showing data at first time. It is showing blank, again I click on the refresh button & select the option "Use current parameter values" & click "OK" button, it showing the data.

 Same time I tested the stored procedure in query analyzer using the parameter it is showing the data, it seems stored procedure is fine & I am not understand the problem,

First time it is not showing the data, Once we refresh the report data is coming..

I am using SQL Server 2000 & Crystal Report 10.

Pls help me.

Thanks & regards
Mure
IP IP Logged
nmmure
Newbie
Newbie


Joined: 06 Apr 2007
Location: United States
Online Status: Offline
Posts: 2
Quote nmmure Replybullet Posted: 06 Apr 2007 at 4:32pm
Hi,

I found the problem, why the report is happening like this, In the query analyser Stored Procedure returning 2 records,

Task_Number
-----------
T23
T34

Report was made by Record selection formula ( If Task_Number <> T34 ), If I reomoved this formula report will display the data,
If with the report selection formula, In report preview we can see the data by selecting the "Browse data" option by right clicking on the object, Browse window is displaying the data.

May be this cause the error, I am trying to fix this,
Pls guide me.

Thanks
Mure
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.