Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameter passing to RDC (crystal reports)
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00641930
Message ID:
00642052
Views:
16
Ignore this parent message. Please see corrected entry sent later.

>>How do I send variables of type date as parameter to RDC for crystal report?
>
>It is not possible to pass values to date parameter fields in the Report Design Component (RDC). The solution involves inserting a formula field in the report from the RDC. You can then use the formula field instead of a parameter field in a Selection Formula for example.
>
>To reference a formula field by name and populate it at runtime:
>
>'assuming that the formula name is "@formula"
>For Each crxFormulafield In Report.FormulaFields
> If crxFormulafield.FormulaFieldName = "formula"
> crxFormulafield.Text = "'11/7/1998'"
> Exit
>
>EndFor
>
>or
>
>If you know how the formula is indexed:
>
>Report.FormulaFields.Item(1).Text = "'" & CDate("11/7/1998") & "'"
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Reply
Map
View

Click here to load this message in the networking platform