Post reply

Pivot Table but Dynamic Columns Not resolved with Dynamic Query.

  • February 28, 2011 at 7:41 am

    #234484

    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 28, 2011 at 8:29 pm

    #1292694

    I don't know much about SSRS but under what circumstances wouldn't you pass a CloseDate parameter to this report?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 1, 2011 at 2:07 pm

    #1293206

    Because i using dynamic query mechanism to get the columns dynamically.

    Dynamic Query will not run until it has the value in the parameter.

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

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