Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keep report from processing upon opening

Status
Not open for further replies.

andoryuu

MIS
Feb 16, 2005
11
US
Hi guys,

I searched for this to no avail, so if it exists sorry!!!

I have a report that will take 2-3 minutes to run if it pulls back ALL the data associated with it. I obviously have a series of parameters that can cut this thing down to a couple of seconds based on the user's needs.

When the user opens up the report I want the parameters to all be selected by default (they have defined lists from datasets), but not have the report start to process.

The only way I've found to do this is to have at least one parameter not be auto populated with the set from the dataset.

My question is: is there a setting in a report that will allow me to keep my parameters' default values selected upon opening the report AND keep the report from processing upon opening?

Thanks!!!
Andrew
 
Not really no - if a report has default params and they are supplied, it will run

What I have done to get around this is to create an extra option on one of the parameters that will return no data. I then use this as the default so whilst the report runs, it does so very quickly and returns no records...

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top