Advanced Crystal Report

[AsifCh]

Hi,

 

I have used the crystal reports few times but now I have to design a really complex crystal report so I want to ask some thing from you gurus.

The Report which I am going to design has a number of column which are decided at the runtime, means that at the time of viewing the report it will be decided that weather the report contain the 10 columns or the 15 or some thing else. also the columns headers are decided at the run time that the first column is corrosponds to the Name or something else. I have build a dyamic query at the runtime which I will pass to the report but the main problem is the design of the report. Like If the report has seven columns to display then all the pther should be suppresses and their should be no emty space like if the column 2 has no data then it should be supressed and the column 3 should be shifted to its place means the empty space will be used at maximum possible.

 

if any body have builded such a dynamic report or have some idea then please share it.

 

Regards,