Crystal Reports

[rringsred]

I was wondering if anyone had any suggestions on making reports dynamic in Crystal. Just started using Crystal and I want my reports to create with the data being relitive to what they enter. Thanks

Next topic: I am loking to purchase a new home theatre package! I was going to to buy some AM10 Bose speakers. I was looking for some feedback on them or opinions

Thanks for everything
Rings

[preeti]

Hi,

You need to create an empty formula field in your report then fill it dynamically through VB.

CrystalReport1.Formulas(0) = "Legend" & LgndIndex & " = '" & chk_index(i).Caption _
& " Term Certain for" _
& Mid(chk_index(i).Caption, 3, 2) & " Years'"

(This will place the text inside the report. But you can really do anything with a formula.

You can also use the selectionformula property to define what to look for:

CrystalReport1.SelectionFormula = "{Table_name.Field_Name}=" & somevalue

HTH,

Preeti