receiving parameter from VB in Crystal Report

Posted on 2000-01-17
Medium Priority
Last Modified: 2010-05-02
How can i receive the parameter from VB application in to my Crystal Report. I am sending from_date and to_date through the (selection formula ) in my application. How can i print the two date's in my report. And how i change the title of the report
while i run the report?
Question by:kazendirane
1 Comment

Accepted Solution

yjt earned 40 total points
ID: 2359557

To pass the paramters to Crystal Report, you need to create two additional fields in your report structure. Save the Rpt file and in your codes, get the value for these fields and insert it into the report structure.

To change the title of the report while you run it, go to the menu item "Insert" and choose Formula. Click New to bring up the FormulaBuilder. Type in the condition to change the title. Eg:

If {tbl.Balance} = 0 then
     "Report Number 1"
     "Report Number 2"
Save the formula and drag it to where you want to display it.

Hope this helps! Btw, i think you should allocate more marks :-)

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month7 days, 11 hours left to enroll

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question