|
|
|
|
| how use parameter for column in report [message #227483 is a reply to message #227115] |
Wed, 28 March 2007 06:29   |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
sir i use this query in report
select :pm1, :pm2, :pm3 from accbal
but not give my result
table stractur of accbal
accid string
entdate date
credit int
debit int
when i geve accid in parameter report give me same accid not give data
please give me idea how i use that
thank's
aamir
how use parameter for column in report
|
|
|
|
| sir thank you very much [message #227530 is a reply to message #227344] |
Wed, 28 March 2007 08:36 |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
hi master
sir thank you very much your given link it's very helpfull for my
sir i try give columns name by using the parameter but report give me parameter value not show column value
such as i give in parameter
MY REPORT QUERY QUERY
select :pm1, :pm2, :pm3 from accbal
ACC_CODE
REPORT SHOW ME
ACC_CODE
ACC_CODE
ACC_CODE
ACC_CODE
ACC_CODE
NOT SHOW ME THE VALUE OF ACC_CODE THAT IN TABLE
PLEASE GIVE ME IDEA HOW I PASS COLUMN NAME THROUGH PARAMETER
THANK'S
AAMIR
|
|
|
|
| Re: how use parameter for column in report [message #227549 is a reply to message #227483] |
Wed, 28 March 2007 10:46 |
tllocke
Messages: 22
Registered: March 2006
|
Junior Member |
|
|
I'm not a sir, but I'll attemp to help. I'm not quite clear on the issue from your post, but why not try to select the actual fields, and put the parameters in the WHERE clause? Something like this:
SELECT accid, entdate, credit, debit
FROM accbal
WHERE accid = :pm1
AND entdate = to_date(:pm2, 'YYYY-MM-DD') <-- if your param isn't date... etc...
|
|
|
|
|
|
| how my user select column from form and send to report [message #227658 is a reply to message #227549] |
Wed, 28 March 2007 23:12 |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
thank you for your reply
sir i have too many column in my view (80) i give oracle form to my user that select column by using lov in grid he can select 12 column in one time
i design report that show 12 column
this type
select :col1,col2,col3,col4 from myview
my user can send any type of column in report
it means user select column from oracle form and send to report
please give me idea how my user select column from form and send to report
thank's
aamir
|
|
|
|
| Re: How to create report at runtime / use parameter for column (merged) [message #227683 is a reply to message #227115] |
Thu, 29 March 2007 01:00 |
 |
bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore
|
Member |
|
|
Hi!!
Whether your problem is solved or what?
Actually the form and report given in the link (Dynamic Report) is very much tested and working properly.
In the form select table or view name, its columns will be displayed, now select columns you want to display.
Press 'Build Script' button and click on 'run Report' to run the report.
What else you want?
Bhupinder Singh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
