Data is not printing?

[nmmure]

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

 

[Turkbear]

Hi,
It could be that the procedure takes longer to run than
is provided by viewing it the first time..Once you refresh, it has had time to complete..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[nmmure]

First time I run the report following are the
Performance Timing
------------------

Open Document: 0 ms
Run the Database Query: 5740 ms
Read Database Records: 0 ms
Format First Page: 5833 ms
Number of pages formatted: 2
Average time to format a page: 2916 ms


Second time I run the report Performance time was different. Here I am coping the second time timings

Performance Timing
------------------

Open Document: 0 ms
Run the Database Query: 1008 ms
Read Database Records: 0 ms
Format First Page: 1077 ms
Number of pages formatted: 2
Average time to format a page: 538 ms


Pls help me to solve this. Any help will be appreciated.


Thanks
Mure

 

[nmmure]

Sorry not second time, I mean after refreshing the report timings shown on the Performance Timing tab.

thanks
Mure

 

[nmmure]

Hi,

Is there any settings ( Property ) in reports to hold the report printing untill we get the data?
( This is similar like timer concept in .net or VB )

I tested stored procedure, that runs very quick. In report also performance time shows it runs fast, It is not too long.

I am trying to solve & it is interesting
Pls give me tips or ideas to solve this.

any help will be appreciated.

thanks
Mure

 

[nmmure]

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