SQL Server Performance

parameter loading all the clients

Discussion in 'SQL Server 2005 Reporting Services' started by cbabino71, Jun 19, 2008.

  1. cbabino71 New Member

    I am wondering how are people are handling these problems.
    1) One of the parameters is client. We have 50,000 clients so the reports is slow to load because report services is loading the combobox with all the clients.
    2) Users want to be able enter the client code or search for the beginning letters of the client.
    Does anyone have any suggestions.
    Thanks
  2. techbabu303 New Member

    are we looking at 50,000 contacts in different companies ?
    -Sat
  3. cbabino71 New Member

    We are an accounting firm and have 50,000+ clients.
  4. Madhivanan Moderator

    Are you calling the reports from any front end application? If so, load only those which are asked for
  5. cbabino71 New Member

    No using the report server web interface.
    Are you recommending building a custom front end app?
    thanks
  6. moh_hassan20 New Member

    Try to Avoid using combobox with that huge number of rows. replace it with textbox.

Share This Page