x

parameter issue

We have developed one report, which is consist of almost 15 parameters, out of them, few parameters are loading huge data like All Supplier names and All Jobs (the parameter is loading almost 20 to 30 thousand values), to load such huge data it is taking too long time, the query is also fine tuned.

Any other alternative way to load that parameter quickly....
more ▼

asked Jun 01, 2012 at 12:27 PM in Default

Mohan gravatar image

Mohan
324 38 56 60

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

It depends whether you need such huge parametr in the report or not. Smooth orientation in the combo box with so much values will be nearly impossible.

I suggest you redeisgn the parameters eventually add another parameter which will futher filter the huge one.

As you wrote for example All supliers, can be filtered by first letter or location or whatever is suitable. So first you select eg. first letter and after selectio nonly the supliers startng by particula letter will be populated in the drop down box.

Other thing is whether you need a report with 15 parameters. It's quite a lot of parameter and mostly such universal reports can be substituted by multiple more lightweight reports which load and execute faster.
more ▼

answered Jun 01, 2012 at 12:38 PM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x84

asked: Jun 01, 2012 at 12:27 PM

Seen: 577 times

Last Updated: Jun 01, 2012 at 12:39 PM