Last post May 25, 2011 10:34 PM by Novox
May 25, 2011 03:48 AM|Novox|LINK
I would like to create CR that display column in dynamically. My SQL query return the data in the grouping result like in the below screenshot.
How can I suspress or hind column dynamically with out space reserved when both type of column are the same and all rows are 0. For example
SickEmp & SickTaken, this is the same type (Sick) and all rows return
0 and the other column is LovewoPay. How can I do this? I have tried to use suspress function in CR, it's works but not what I want because suspress is also reserve the space for the text (unlike suspress for section, suspress
for section won't reserve the space). How about the table's border?? It can suspress dynamically too???
I have tried to search around the Internet and found some possibility, they suggest me to use Cross-tab which is can disabled or hide unwanted column in programmatically but I have tried to use it with the previous dataset, the result return different from
what I want.
Thank you very much for your help,
May 25, 2011 04:50 AM|tiagosalgado|LINK
Select your column and right click > Format Text
Now you select "Common" tab, and check the option "Can Grow".
May 25, 2011 10:34 PM|Novox|LINK
Not works, "Can Grow" is for row dynamically not column.