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
    cbabino71, Jun 19, 2008
    #2

  2. techbabu303 New Member

    are we looking at 50,000 contacts in different companies ?
    -Sat
    techbabu303, Jun 20, 2008
    #3

  3. cbabino71 New Member

    We are an accounting firm and have 50,000+ clients.
    cbabino71, Jun 20, 2008
    #4

  4. Madhivanan Moderator

    Are you calling the reports from any front end application? If so, load only those which are asked for
    Madhivanan, Jun 20, 2008
    #5

  5. cbabino71 New Member

    No using the report server web interface.
    Are you recommending building a custom front end app?
    thanks
    cbabino71, Jun 20, 2008
    #6

  6. moh_hassan20 New Member

    Try to Avoid using combobox with that huge number of rows. replace it with textbox.
    moh_hassan20, Jun 22, 2008
    #7

Share This Page