Change CR fields at runtime 1

[160473]

I run a mysql query that populates as dataset. This is then used for displaying data in a Crystal Report.

But now to the problem. The dataset contains many columns but only a few is used in the report. Is it possible to change the datafields in the report to show different data based on what I want to see? (based on checkboxes on a form).
The dataset always contains the same columns.

Example:

Dataset: Col1, Col2, Col3 ..... Col10

 

[bigfoot]

In your query, use the "as" statement and rename the fields.
For example:
Select Col1, Col2, Col3 from mytable could read
Select Col1 as mycol1, Col2 as mycol2, Col3 as mycol3 from mytable

Now set up your report to use mycol1,mycol2,mycol3.

Then you could have a case statement to append the sql statements together. I can create you some code if this is what you had in mind.

 

[160473]

Thanks!
That was a new approach to the problem

No need to create code, done that already and it works greate!!!

 

[bigfoot]

Cool, glad to be of help.