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