Web Development

Ask something
Discussion Locked

Crystal Reort Formaula Writing Help

0 helpful
1 reply

by rehan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

i m using crsytal report with vb6. i have designed a report in Crystal report8.5. Now i want to give some selection formula to it but i m ubale to do so please help me. i m posting the code here please review it.

1. cr1.SelectionFormula = "{cfcdata1.DMIDNO} = ' adviceNo '"
2. cr1.SelectionFormula = "{cfcdata1.DMIDNO} = '" & adviceNo &"'"

cr1 is the crystalReport control
cfcfdata1 is the table name
dmidno is the field name and adviceNo is a string type variable.

i have tried both ombinations above but it gives me error remaining test doest not seem to be part of formula or some thing like that.

please help me in this regard.

1 reply

by miss kitty

Have you set up your Crystal report with parameters for adviceNo? Does your report run like you want it in Crystal? The report has to be set up first, then you can pass it parameters based on what the user inputs in the VB6 application.
Cathy

This discussion is closed to new replies.