Post reply

Issue - Dynamic Columns(may be one column or 10 columns or 100 columns) depends on the DateParameter we specify.

  • February 25, 2011 at 9:40 am

    #231736

    i have a requestid's with start date and Close Date. I should generate a report in SSRS the cout of requests closed in 0 day, 1 day, 2 day, 3 day....(no limit).

    My column headers are like this: 0,1,2,3,4,5,6,7,8,9,10,10+ Days. If there is no requests closed in 1 day I should show '0' (zero).

    There are some calculations based on the columns generates.

    Condition: Close Date is the value, i will pass through the report @CloseDate parameter.

    I tried with dynamic query, dynamic query will not execute until i give the Close Date parameter.

    If there is no parameter no columns will generate, if there are no columns then report throws an error.

    Dataset will not create until there is a value to the report parameter.

    I struggling a lot for the solution. Appriciate your help and suggestions

  • February 25, 2011 at 10:51 am

    #1291663

    Did you try to assign a default value to the @CloseDate parameter?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 25, 2011 at 11:37 am

    #1291696

    I tried but not solving the problem.

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

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