+ sign trigers another query depending on user selection

[Nejibg]

Hi,
Is it possible to create a report where after the user runs it, they can click on a plus sign on the report which will trigger
another query and display further results?
This is to avoid user having to wait a long time for the whole report of finish running.
Thanks,
N.

 

[xlbo]

If you have sub reports within a main report, generally they will all execute at the same time

Only way to do this would be to execute a parameter query on a subreport where the parameter is passed in as a result of user action - this would be the only way to stop the subreport executing directly....not sure if you can do that using the expand control though...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Thanasisa]

Hi,

In SSRS2005, would it be of any help to use the Properties,Navigation,Jump to report function?

Thanasis