Having Problem with Report Parameters

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?

Having a report generate with a rtf for data entry

Is there a way to have a report generate so that there is an 'empty' rich
text box for someone to add notes, comments, text to the report after it
generates?
For example, if i have a report generate out to a shared directory, i want
to allow someone to go 'update' that report by adding explanatory bullets to
the report.
any suggestions or direction is welcomed.
Thx.Sounds like you will have to write a custom report exentension control.
This control will render to HTML and you can render the specific HTML you
need to for data entry and postbacks.
Check out http://msdn2.microsoft.com/en-us/library/ms154606(SQL.90).aspx for
information on rendering extensions. I have not had to write any yet but it
looks like you can specify an HTML specific rendering extension.
Craig
"TroyS" <TroyS@.discussions.microsoft.com> wrote in message
news:C0718935-8D1F-4058-876C-764387F4360D@.microsoft.com...
> Is there a way to have a report generate so that there is an 'empty' rich
> text box for someone to add notes, comments, text to the report after it
> generates?
> For example, if i have a report generate out to a shared directory, i want
> to allow someone to go 'update' that report by adding explanatory bullets
> to
> the report.
> any suggestions or direction is welcomed.
> Thx.