Post reply

Display top 100 records.

  • February 10, 2011 at 11:13 am

    #245101

    Hi friends,

    I am having a table which contains iislogs.Suppose in that table there are million of records then i have to average the time column

    if there are a million request for any website then i need report the average on the fastest 500,000 request i.e. on 50%.

    And among this 50% i ahve to display top 100 records.

    if anybody developed such type of report then can please share the idea.

    Thanks in Adavance

    Abhas.

  • February 11, 2011 at 1:13 pm

    #1285880

    This sounds like the kind of request that is better suited to handle in TSQL not in SSRS. Get your data in TSQL and then format it with SSRS.

    So to help us help you read the first link in my signature. It will help you to get some sample data put together so that we can better visualize your problem.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply