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

avatar image

324 50 59 63

(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

avatar image

Pavel Pawlowski
22.7k 10 15 26

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Jun 01, 2012 at 12:27 PM

Seen: 699 times

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

Copyright 2018 Redgate Software. Privacy Policy