Home » Developer & Programmer » Reports & Discoverer » How to create report at runtime / use parameter for column (merged)
How to create report at runtime / use parameter for column (merged) [message #227115] Tue, 27 March 2007 06:24 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
hi master
sir my director give me task that my user selet column in form and push button then create report that have only selected column only

please give me idea how i create runtime report

thank's

aamir



Re: how create report at runtime [message #227344 is a reply to message #227115] Wed, 28 March 2007 01:30 Go to previous messageGo to next message
bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore
Member
Hi
Hope you will get some idea from this.
Its one kind of dynamic report called from form

Check that here
http://www.orafaq.com/forum/m/182834/88695/#msg_182834


Bhupinder Singh
how use parameter for column in report [message #227483 is a reply to message #227115] Wed, 28 March 2007 06:29 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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...

Re: how use parameter for column in report [message #227608 is a reply to message #227549] Wed, 28 March 2007 15:22 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@mfa_786: This is the same problem you're talking about; you use the same query. So, please, keep discussion in the same topic - don't open a new one.
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: srw.run_report
Next Topic: How to call a report from a report in reports 10g ?
Goto Forum:
  


Current Time: Sun Dec 04 10:55:41 CST 2016

Total time taken to generate the page: 0.13461 seconds