| Problem passing a DATA_PARAMETER to a report [message #80933] |
Sun, 15 December 2002 21:18  |
priya
Messages: 108
Registered: February 2000
|
Senior Member |
|
|
I am passing a record group as a data parameter from a form to a report. Following is the query I have used:
SELECT COUNT(*) FROM EMP_DATA;
While calling the report from the form it gives the following error:
REP-1340 - Cannot match passed-in column with the report definition of <Query name>
The report runs properly when I invoke it from the report builder.
Also, when I changed the query as follows, the report gets invoked successfully:
SELECT EMP_DAME from EMP_DATA;
I think the problem here is when I have count(*) in my query, which gets passes as a DATA_PARAMETER.
Is there anyway to overcome this problem?
|
|
|
|
| Re: Problem passing a DATA_PARAMETER to a report [message #80939 is a reply to message #80933] |
Mon, 16 December 2002 06:55  |
Piyush Balan
Messages: 26
Registered: December 2002
|
Junior Member |
|
|
Hi,
With the current query having a well defined columns and alongiwth it's datatype as character, what u obviously need to do is give an alias to ur count(*) and apply a to_char() function over it.
eg. instead of
SELECT COUNT(*) FROM EMP_DATA
try
SELECT TO_CHAR(COUNT(*)) EMP_NAME FROM EMP_DATA
it should definitely work.
Regards,
Piyush Balan
Consultant
Comsoft Pte Ltd
Singapore
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
