Home » Developer & Programmer » Reports & Discoverer » use of parameter in the other parametrs in reports
use of parameter in the other parametrs in reports [message #89301] Sat, 24 January 2004 00:04
Amit
Messages: 166
Registered: February 1999
Senior Member
Supoose there are 2 user parameter p1, p2 in reports. From property pallette, i choose "list of values' option for p1. Undet it, I choose 'select statement' option.
Now i write select * from emp where empno=:p2
The above statement is not allowed as it gives error "bind variable not allowed'.
Tell me how can I use where clause in select statement.

Report message to a moderator

Previous Topic: Problems with columns totals in Matrix with group
Next Topic: Graphics Builder 6 - Line chart using week and year data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 05:26:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.