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?

handles and threads

Whats the difference between handles and threads ?
Also in the performance tab in Task manager , can someone explain the
meanings of each of those different values captured under totals, commit
charge, kernel memory and physical memory
Thanks
A handle is a reference to something... Sometimes it may be a reference to
a file, or an object..... Perhaps you wish to open a file and the file open
gives you a handle to the file... ( a reference to it) which you store in a
variable, and use the variable to reference the file for reading/writing.
etc.
A thread is an individually schedulable piece of work... A program( or
process) always has at least one thread. A program ( like SQL) may fire off
many threads, which work co-operatively or independently. This is called
multi-threading... When a program has multiple users ( like SQL),
multi-threading allows mulitple users to get work done at the same time...
A similar example might be a single lane road going up a mountain, with an
18 wheeler at the front of the line... No one can make more progress than
the 18 wheeler... If there were multiple lanes on the road ( equivalent to
multiple threads in an application), the others would not be blocked or
slowed down by the 18 wheeler...
Although someone else might do a better job on the task manager part... I'll
give it a stab..
Physical memory is the actual physical memory on the computer... Windows
however can act as if there were more memory available than what is
physically on the box (virtual memory). How much virtual memory is used ( I
beleive) is commit charge... Kernel memory is how much memory the OS is
using.
If you run Task Manager, select help, and on the search tab type "commit
charge". You will be taken to a window that has a short description of the
meanings as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ekX1i35cEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Whats the difference between handles and threads ?
> Also in the performance tab in Task manager , can someone explain the
> meanings of each of those different values captured under totals, commit
> charge, kernel memory and physical memory
> Thanks
>

handles and threads

Whats the difference between handles and threads ?
Also in the performance tab in Task manager , can someone explain the
meanings of each of those different values captured under totals, commit
charge, kernel memory and physical memory
ThanksA handle is a reference to something... Sometimes it may be a reference to
a file, or an object..... Perhaps you wish to open a file and the file open
gives you a handle to the file... ( a reference to it) which you store in a
variable, and use the variable to reference the file for reading/writing.
etc.
A thread is an individually schedulable piece of work... A program( or
process) always has at least one thread. A program ( like SQL) may fire off
many threads, which work co-operatively or independently. This is called
multi-threading... When a program has multiple users ( like SQL),
multi-threading allows mulitple users to get work done at the same time...
A similar example might be a single lane road going up a mountain, with an
18 wheeler at the front of the line... No one can make more progress than
the 18 wheeler... If there were multiple lanes on the road ( equivalent to
multiple threads in an application), the others would not be blocked or
slowed down by the 18 wheeler...
Although someone else might do a better job on the task manager part... I'll
give it a stab..
Physical memory is the actual physical memory on the computer... Windows
however can act as if there were more memory available than what is
physically on the box (virtual memory). How much virtual memory is used ( I
beleive) is commit charge... Kernel memory is how much memory the OS is
using.
If you run Task Manager, select help, and on the search tab type "commit
charge". You will be taken to a window that has a short description of the
meanings as well.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ekX1i35cEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Whats the difference between handles and threads ?
> Also in the performance tab in Task manager , can someone explain the
> meanings of each of those different values captured under totals, commit
> charge, kernel memory and physical memory
> Thanks
>

handles and threads

Whats the difference between handles and threads ?
Also in the performance tab in Task manager , can someone explain the
meanings of each of those different values captured under totals, commit
charge, kernel memory and physical memory
ThanksA handle is a reference to something... Sometimes it may be a reference to
a file, or an object..... Perhaps you wish to open a file and the file open
gives you a handle to the file... ( a reference to it) which you store in a
variable, and use the variable to reference the file for reading/writing.
etc.
A thread is an individually schedulable piece of work... A program( or
process) always has at least one thread. A program ( like SQL) may fire off
many threads, which work co-operatively or independently. This is called
multi-threading... When a program has multiple users ( like SQL),
multi-threading allows mulitple users to get work done at the same time...
A similar example might be a single lane road going up a mountain, with an
18 wheeler at the front of the line... No one can make more progress than
the 18 wheeler... If there were multiple lanes on the road ( equivalent to
multiple threads in an application), the others would not be blocked or
slowed down by the 18 wheeler...
Although someone else might do a better job on the task manager part... I'll
give it a stab..
Physical memory is the actual physical memory on the computer... Windows
however can act as if there were more memory available than what is
physically on the box (virtual memory). How much virtual memory is used ( I
beleive) is commit charge... Kernel memory is how much memory the OS is
using.
If you run Task Manager, select help, and on the search tab type "commit
charge". You will be taken to a window that has a short description of the
meanings as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ekX1i35cEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Whats the difference between handles and threads ?
> Also in the performance tab in Task manager , can someone explain the
> meanings of each of those different values captured under totals, commit
> charge, kernel memory and physical memory
> Thanks
>