Report Preview is Not Showing Data-Urgent
Hi All, I am unable to see the data in the report preview. My report has 44 columns and 300k rows and 15 parameters. I created a table with all the 44columns and indexes as well for better performance. And, I created parameters with cascading. In addition, I setup default value as Select All. However, I am unable to see the data in the preview. Any Help would be appreciated. Thanks
April 21st, 2011 9:35am

Hi, See, the query which is getting created and check if it retruns any row. You can use SQL profiler to see this. Also, Does it return any error after some time? If it's time out error, adjust TimeOut value.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2011 9:47am

Hi Chintak, I recreated that report and it is working fine. However, I am facing a weird problem. I have Company as First Parameter and values were MSUS and MSCAN and NULL. When I selected MSUS it is displaying all respective values but When I select MSCAN it is not displaying the values. Could you please let me know what the issue is I appreciate your time. Thanks Tarak.
April 21st, 2011 12:45pm

This is the query I am using it for that parameter SELECT DISTINCT CASE WHEN Company IS NULL THEN 'Null' ELSE Company END AS Org FROM REPORT ORDER BY Org
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2011 12:50pm

Hi, Good that you have resolved the initial problem. Now, It's odd that, you are getting rows returned for MSUS and not for MSCAN. There can be one or two reasons fro this 1) In your main dataset, you are eveluating this with equal to and parameter value have leading or trailing blank space. If this is the case use LTRIM() or RTRIM() in sql query. 2) In your main dataset there is no value for MSCAN. Kindly revert if this is not the case.- Chintak (My Blog)
April 24th, 2011 11:55pm

Thanks Chintak for the response. I tried the first option as you specified but no results. And I have values for MSCAN.
Free Windows Admin Tool Kit Click here and download it now
April 25th, 2011 1:14pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics