General discussion

Locked

Crystal Reort Formaula Writing Help

By rehan ·
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.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Miss Kitty In reply to Crystal Reort Formaula Wr ...

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

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums