i am trying to generate a report based on 3 parameters
age, location, ethnciity
every thing works fine in data and layout tab,
when i run the preview tab, it give me the option to input paramaters and then when i hit veiw report, it shows processing report.... (indefinite) time.
i tried executing the query in data tab, it takes less than a sec.
any ideas?
am i doing somethign wrong in parameters?
Raja,
I'm going on the assumption you are using SQL as your datasource, If so, you can start a SQL profiler on the database you're using.
In the profiler, you can watch the query statement from SQL reporting service being executed, It will reveal exactly what is being passed in your parameter. You can copy this statement and execute to a new query to help you debug your issue.
I hope that this helps.
Ham
|||its some weard problem.
its hitting the dbase and i double checked it in the profiler.
i dont knows what happening. i deleted the data cache files in the folder and tried rerun again..
nothing works.
data tab works 1000 times fine.
|||What happens when you take the statement from the profiler and run it in a new query window. Does that execution of the statement still takes a long time?
Ham
|||Hi,
I once had sort of the same problem. I didn't set the datatype of the parameters correctly which caused problems when viewing the report.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||Yes,
I checked it with the QAnalyzer, Profiler, ReportingServices Data Tab.
everything takes less than a sec to execute the 15000 records.
This is one thing i noticed now after some weird research.
when i hit the preview tab and input parameters its not showing anything (i mean it shows report processinng..... )
but now when i deploy it to the server and try to view it. ITS WORKING
Where the h... is the problem. ?
|||any one have an email id of any of the webcast instructors who have instructed for RS before...|||any help?
No comments:
Post a Comment