Print Page | Close Window

how to pass a crystal report formula as a paramete

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=630
Printed Date: 04 Apr 2025 at 4:57am


Topic: how to pass a crystal report formula as a paramete
Posted By: mikechrist
Subject: how to pass a crystal report formula as a paramete
Date Posted: 07 May 2007 at 5:40pm
All,
 
How to pass a crystal report formula as a parameter to SQL QUERY created using ADDCOMMAND
 
my query:
 
SELECT <TABLE.COLUMN1> FROM <TABLE> WHERE <TABLE.COLUMN2>='CR FORMULA'
 


-------------
thanks
mike


Replies:
Posted By: BrianBischof
Date Posted: 07 May 2007 at 7:04pm
On the right-hand side of the SQL Query dialog box is an 'Add Parameter' section. Just add a new parameter and then double-click on it to insert it into the SQL query. Very easy once you see how it works!

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: mikechrist
Date Posted: 08 May 2007 at 7:02am
Brian,
 
Thanks for your reply..
 
The question is not creating a parameter using dialogbox.
 
i want to pass crystal report formula already created in report
 
that formula i have to pass as a parameter to SQL  QUERY in addcommand
 
like
 
SELECT EMP_NAME FROM EMP WHERE mailto:DEPT_NO=%7b@DEPTNO - DEPT_NO={@DEPTNO }
 
mailto:%7b@DEPTNO - {@DEPTNO } is a formula already created for a column
 
i created a formula for each columns
 
so that i can fetch a column values..
 
 
 


-------------
thanks
mike


Print Page | Close Window