Post reply

Is it possible to build a table (object) columns based on the count in my sproc

  • June 13, 2008 at 1:05 pm

    #381134

    Hi,

    I am trying to write a report for 2 plat forms but i want to use dynamic headings based on the feilds my sproc returns..

    My sproc will return a count for no.. of columns it has which has data in it and the remaining will be null.. So is it possible build a table columns dynamcially based on the count that the sproc returns.

    any help will be appreciated.

    Thanks,

    Karen

  • June 17, 2008 at 7:22 pm

    #830138

    You can try "hidden" property of the column (under Visibility). Design your report layout so it has all of the columns. Then, based on you stored procedure output set hidden property of the column to "true" or "false":

    property value "=iif(spCountField=1, true, false)"

  • June 18, 2008 at 7:25 am

    #830400

    Thanks for your answer.. But wouldnt there be a gap for the columns that are blank and will the size of the report shrink??

  • June 18, 2008 at 6:27 pm

    #830851

    You wouldn't see blank columns at all, there will not be gap. Report will have some space on the right.

    Another option is to use expression for the columns headings and data rows:

    - header:

    iif(sp_param=1,"Column Name1","Column Name2")

    - data row:

    iif(sp_param=1,Fields!Col1.Value,Fields!Col2.Value)

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

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