Current Position:Home > Report based on stored procedure

Report based on stored procedure

Update:11-30Source: network consolidation
Advertisement
I want to create a report based on stored procedure(not ref cursor!!!!!)
For example - Invoice report with data with complicated rules:
1.line - product_name and price
2.line - annual fee name and price
3.line - some special fee name and price
4..............
5..............
[b][b][b]Is it possible or not?
We can solve the problem using functions, i.e. select line_1_1(param),line_1_data2(param6) from dual union all and select line_2_1(param1,param2),line_2_2(sysdate) from dual and so on, but I am looking for better solution.
We also can use stored procedure to populate data into temporary table, run report and clear the data in the table after that, but database is read-only for users and we don't want to change the security roles.
Thanks in advance.
Iassen Houbenov

The Best Answer

Advertisement
See:
"Using a Collection Instead of a Temporary Table in Complex Reports"
http://www.revealnet.com/pipelines/plsql/tips03.htm#NOVEMBER
Regards,
Zlatko Sirotic
  • Report based on stored procedure Update:11-30

    I want to create a report based on stored procedure(not ref cursor!!!!!) For example - Invoice report with data with complicated rules: 1.line - product_name and price 2.line - annual fee name and price 3.line - some special fee name and price 4.....

  • How to edit a report based on Stored procedure in Deski Update:10-11

    hi all, We have a report based on a stored procedure in Deski format.I can see the sp name it is using under View Data >definition but cannot figure out which database or server it is pointing to . Also ,please let me know how to edit/change the sp i

  • Help: Creating a report based on STORED PROCEDURE in Oracle DB Update:10-11

    Hi, We are creating an application with FORMS and REPORTS. A set of stored procedures were created for the FORMS and the ref cursor from the select statement are the same for the REPORTS. Is there a way that directly use relevant stored procedure to

  • Prompts in Universe based on Stored Procedure Update:11-30

    Hello All, I have a universe based on stored procedure. There are two prompts "Date from" and "Dateto" which I set up as "prompt me a for a new value" in the universe. When I run the webi report it prompts me to enter the dat

  • Support a singly report on SQL Stored Procedure and Oracle Stored Procedure Update:11-30

    Hi, I have a requirement in which I need to create a report that will run both on oracle and sql server. Report is designed as follows. Main report contain 2 sub-reports.Sub-reports are  based on stored procedure that takes three input parameters(beg

  • Calling a report from a Stored Procedure Update:10-11

    Is it possible to call a Oracle Report from a Stored Procedure or a Packaged Stored Procedure. If Yes, please provide some details. Thanks ShaluShalu, there's an API available to do this.The feature is called "event driven publishing" (because y

  • Help: FORMS based on stored procedures Update:10-11

    I am working on a FORM based on stored procedures. This particular FORM performs a query and generates say, customer_name, item1_sale, item2_sale and sum of the item1_sale and item2_sale. I'd like to know if there are ways that the query procedure re

  • Creating Sap Crystal Report Through Oracle Stored Procedure Packages Update:11-30

    Hi,    1.How we can create crystal report through oracle stored procedure packages pls tell me the steps through adding command then tell me the syntax what should i write in command to call the stored procedure packages or if have some other option

  • Would like to create a file upload facility in a form based on stored procedure Update:11-30

    Hello, I would like to create a 'File Upload' in a 'form based on stored procedure'. The version of portal that I am running is 3.0.7.6.2. In this version, only 'form based on table' has the ability to upload files. Or is it that I am missing somethi

  • Block based on Stored Procedures & Locking_Mode Update:11-30

    Hello, I'm creating a block in Forms 6.0.8 based on Stored Procedures. I'm using the example given in Metalink doc 52778.1. Updates to data work fine if locking_mode = 'Immediate'. If I set locking_mode to 'Delayed' and run the form, when I try to up