Add and Remove Fields at Runtime???

[hneal98]

I know I can hide fields, but is there a way to actually add or remove fields at runtime???

Thanks

 

[TheBlondOne]

Have you tried using an if-then-else statement in a formula.

 

[hneal98]

Nope, that's why I posted here, to get ideas.

Now the next question then would be, should I set that up using the Evaluation Time functions, and if so, which would be best for this?

Thanks

 

[kskid]

I hate getting on the soapbox but it would sure help if you provided just a little more information on the data you are working with and what you are expecting as output.

Adding or removing fields can be handled with conditional suppression if that is what you mean. I have done that in some of my 8.5 reports depending on whether the user selects a abbreviated or full report.

Cheers,
-LW

 

[hneal98]

I know fields can be handled with suppresion, as I stated in my first post (well, sort of.) I want to ADD or REMOVE fields AT RUNTIME based on what the user selects. For instance, if the choose DENIED, I want to only show fields that would be pertenant to Denied Claims, if they select PAID, I want to show fields for the paid claims and the Check no, amounts, etc.

By the way, you can get on the soapbox any time you want.

 

[synapsevampire]

You can dynamically create reports from vb or other languages, adding or removing fields, depending upon your Crystal version.

Otherwise people generally use multiple sections with different fields in each and suppress the appropriate sections based on your parameters, or they'll just use dynamic formulas using the aforementioned if then.

-k

 

[hneal98]

That would be great, but I can't becuase we have another program that we attach the reports to for the users to use. This other program stores a blob of the report and calls Crystal reports from within. We do not have access to it's code.

I like your other idea though of using multiple sections. I would just need to figure out how to change the page orientation at runtime then.

If you have any ideas whether that is possible, that would be great.

Thanks again.

 

[kskid]

Why not just insert another detail section placing Denied fields in one detail section and Paid field in the other. You can then go to section expert and conditionally suppress the section based on user option. This is what I did on my full report. The report included all payments made by the individual whereas the summary report just had Paid = "Yes"

The conditional suppression for the "Denied" section would be

{?Option} <> "Denied"

and for the "Paid" Section

{?Option} <> "Paid"

Cheers,

-LW

 

[hneal98]

Thanks. That is the same good suggestion that synapsevampire made. I understand that part now. Now I to know if it is possible to change the page orientation (Portraite vs. Landscape) at runtime.

 

[synapsevampire]

Nope, but check out your other thread, I tossed in a white paper on using virtual pages, not an ideal solution though.

-k

 

[synapsevampire]

Nope, but check out your other thread, I tossed in a white paper on using virtual pages, not an ideal solution though.

-k

 

[hneal98]

Ok. will do. I didn't think it was possible, but sometimes people come up with some amazing solutions to problems.

Thanks again for your time and help.

 

[hneal98]

I looked at the other thread, but did not see any link to a white paper.