Click here to Skip to main content
15,867,756 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I am using Oracle BI for reporting purpose, I have a report which contains user details(ID, name, address etc) now details of each user gets printed on a page(the report template).

I have a list of values which contains the IDs of the users when I select an ID from the list, details of that user gets displayed on the screen.
The template is actually a form, so it can contain details of one user at one time.

To get the report printed I select an ID from the list and click "View" and the details of that ID gets displayed on the screen(one user at one time).
As I have hundreds of users it is quite difficult for me to print the result one by one.

Now what I want is to select the "All" option from the list and the details of all IDs in the list get displayed on screen(each User on separate page).
The template is in RTF format.

Is there any way that I select the "All" option and if there are 10 IDs in the list, the template gets printed 10 times each copy containing details of single different user.
Posted
Updated 17-Aug-15 18:05pm
v4
Comments
Afzaal Ahmad Zeeshan 10-Aug-15 7:44am    
What have you tried until now?
Brittle1618 10-Aug-15 7:51am    
I simply select single ID from the list and get the report for it, then select another ID and report(for that single ID) gets displayed. Haven't come across any solution to get the template(repeating, one after another) for each ID by selecting the "ALL" option from the list.
Kornfeld Eliyahu Peter 17-Aug-15 3:34am    
Not clear...
What is 'ALL' option? What 'menu' do you talking about?
Are you using a UI made by ORACLE for its BI solution - in that case ask them!
Did you wrote a code to interface with the BI engine - show us your code/problem!
Brittle1618 17-Aug-15 3:51am    
Oracle BI gives an option that you can select a list of values(IDs in my case) a query works behind that list(select distinct id from table) then you link this list with your parameter which you've used in your main query (like, where id = :id)

Now in the report View page you can select a value from the list and you get the result of that value, and there is an option that you select all the values from the list and result of all the values get displayed in report template.

now in my case the problem is that the template can contain details of only one user at one time so that all option won't work.
what I want to ask is, is there any way that by selecting "All" option I get the details of each user, each on separate page.

I improved the question too, is it a bit more clear now??
Kornfeld Eliyahu Peter 17-Aug-15 3:57am    
It sounds to me like a question to Oracle - you should look for one-to-many reports...
(In ever had the money to by Oracle products :-))

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900