Post reply

Details section of table in SSRS should be fixed based on Dataset.

  • September 18, 2010 at 2:00 am

    #227019

    hi

    I have one query in SSRS. i have a report which should be in pdf format. in that i have a table which should have 5 details ( i mean lines).

    Here I have question, suppose if my dataset for the table is returing only 2 rows means, I need the report should be like first two rows should be with data and the remaining rows should be empty.

    As of now this is not happening, because of this my report alignment is changing.

    Ex:

    DataSet

    Eno ename

    1 A

    2 B

    Output should be in Table ( SSRS)

    EmployeeNo EmployeeName

    1 A

    2 B

    - -

    - -

    - -

    Suppose if my dataset is returning :

    0 roww means, remaining 4 rows should be with "-"

    1 row means, remaining 4 rows should be with "-"

    2 row means, remaining 3 rows should be with "-"

    3 row means, remaining 2 rows should be with "-"

    4 row means, remaining 1 rows should be with "-"

    If anyone knows the solution, please advise me.

    Thanks in Advance.

    Regards

    Prakash

  • September 23, 2010 at 10:02 am

    #1226434

    Hi,

    Is your balnk data "-" depends on any other column in the table? If so we can write some Iff conditions to display blank in that table.

  • September 24, 2010 at 12:25 pm

    #1227167

    Would your query always return 5 rows or less? If so, there are some tricks you can implement in the SQL itself that guarantees that 5 rows are always returned. Would it be possible for you to post a snippet of your query? What DBMS are you pulling from?

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

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