June 13, 2014 at 11:08 am
I have a Tablix table of fixed columns that is pulling from a stored procedure. I have added a text field (varchar) as the last column of the stored proc. If this text column is not null, I want to insert a row after the Tablix has written out the row the text column resides in.
Here is an example:
The row that starts with "PFT" is the row that I want to add after the row dated 5/2/2003, as it pertains to that row. Is this even possible?
June 15, 2014 at 9:45 pm
fstop (6/13/2014)
I have a Tablix table of fixed columns that is pulling from a stored procedure. I have added a text field (varchar) as the last column of the stored proc. If this text column is not null, I want to insert a row after the Tablix has written out the row the text column resides in.Here is an example:
The row that starts with "PFT" is the row that I want to add after the row dated 5/2/2003, as it pertains to that row. Is this even possible?
For this, you will need 2 detail rows. For the second row (the row that will contain the "PFT" string), you need to do the following:
- merge all of the cells so that they whole row is a single cell
- make the visibility of the row conditional depending on whether you have a value to show, or not.
June 16, 2014 at 9:05 am
Thanks for your suggestion. As a newbie, can you offer some detail in how to to pull and incorporate 2 detail rows in a Tablix? It seems to me that in order to merge all the columns into one field in the query, I would have to work out all the spacing in the query (which wouldn't allow for fields wrapping data in a cell, such as in the Notes column). Then I would create a one column Tablix? Would I then not be able to have column headers and cell borders? I assume I would set the Visibility based on an expression of whether the row started with PFT or not? Am I following you correctly? If not, can you elaborate? Thanks
June 23, 2014 at 5:54 am
fstop (6/16/2014)
Thanks for your suggestion. As a newbie, can you offer some detail in how to to pull and incorporate 2 detail rows in a Tablix? It seems to me that in order to merge all the columns into one field in the query, I would have to work out all the spacing in the query (which wouldn't allow for fields wrapping data in a cell, such as in the Notes column). Then I would create a one column Tablix? Would I then not be able to have column headers and cell borders? I assume I would set the Visibility based on an expression of whether the row started with PFT or not? Am I following you correctly? If not, can you elaborate? Thanks
In you tablix, the detail row will actually be 2 rows. You can do this by
- select any cell in the detail row. Just to the left of the first cell on that row, you should see an extra "field" that looks a bit like an equals sign
- right click on the that "equals" sign and then select "Insert Row" and then "Insert Group - Below"
- you should now see an additional row appear
- select every cell on the new row
- right click on the select cells and select "Merge Cells"
- you should now have a row which has a single cell in it.
- on the single cell row, set the expression for the row to be the value you want (e.g. the field contain the "PFT..." value
- select the single cell row, and in the "equals" at the left hand end of the row, select "Row Visibility..."
- in the dialog that pops up, add an expression that evaluates to True or False to "Show or hide based on an expression" field
June 24, 2014 at 10:13 am
Thank you very much for taking the time to provide step-by-step instructions. They worked beautifully!
June 25, 2014 at 6:26 am
Great - glad to help
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy