| Building Queries dynamically, in case of Reports [message #88151] |
Tue, 16 April 2002 22:11  |
rajesh
Messages: 173
Registered: November 1998
|
Senior Member |
|
|
I want to create a query dynamically. The scenario is like this
I am passing around 5 parameters from the form to call a report and all the parameters may be null or may not and I am also going to use these parameters in the where condition of the query, accordingly I want to create a query dynamically depending upon the passed parameter is null or not. If passed parameter is not null I am going to use the same in the where condition of the query if not I am not going use that parameter in the where condition.
Can anybody help me in this regard
|
|
|
|
|
|
| Re: Building Queries dynamically, in case of Reports [message #88170 is a reply to message #88151] |
Wed, 24 April 2002 04:13  |
arun kumar
Messages: 13
Registered: April 2002
|
Junior Member |
|
|
Hi
The Proble can be of 2 Ways as i understood
1. Change in Where Clause only
2. change in the whole Structure Of the Query
Ans 1. You can form a where clause through the forms and add a parameter to it and send it as a TEXT_PARAMETER from forms and send it through RUN_PRODUCT and Receive as a LEXICAL PARAMETER in the reports as stated below
:empno is for bind parameter
&empno is Lexical parameter
Ans 2. You can form a full Query in the forms and Send the whole query to the Reports as a DATA_PARAMETER from forms and The query which u send will replace the Report Query which u have alredy developed in the Reports
Enjoy u'r Self if u have any Queried Please send it to me
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
