Last post Jun 13, 2011 10:52 PM by necro_mancer
May 25, 2011 03:47 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,
Jun 10, 2011 07:43 AMfirstname.lastname@example.org|LINK
this is possible from Crystal Report 11.5 that means service pack 2. i did the same like this before 2 years.
for static report we have to design the report at design time for the dynamic report we have to design it at run time. that is for header columns we have to place the Crystal Report Textboxes for displaying data then we can use the labels. we can also specify
the data and header position by x and y axis.
so, first install that CR version then you can see the Textboxes,Labels in the Tool box under crystal report tab then refer this page
Jun 13, 2011 10:52 PM|necro_mancer|LINK
are you able to make it work? Please keep us posted!