Reporting on Dynamic tables

[eibrahim]

I would like to report on a table that changes e.g.
Table1 will have columns id,ver,length
but it could change to contain id,ver,length,width,height
etc...
I would like to create a report that will display id and ver all the time and then display the other variable fields.

So the report could be :
id ver length
1 4 54.4
and then change to
id ver length width
1 3 34.2 32.1
and so on.

Is there also a way to hide a field and it's label if it's null so if length is null then the report will look like:
id ver width
1 3 76.1

Thanks for your help.

 

[Guest_imported]

Create your report on all fields where dynamic fields heading should be formula which contain heading text like "Length".
id ver length width Height
1 3 34.2 32.1 13

and also create formula or parameter for each dynamic fields
in run time just send some value like true for all dynamic fields to whom you want display and false for fields you want to suppress. Now suppress or display your field heading or field on the basis of these formula value.
I hope you know how to pass formula and parameter value to a Cry report in run time