gkaindia.com

Home > > Avoid boilerplate in reports

Avoid boilerplate in reports

Advertisement
Hi,
Unfortunately I have to work with Oracle Reports 2.5 and I am having trouble with controlling the report layout.
Here are the two queries in my report
1.
SELECT
     D.DEPT D_DEPT,
     D.DEPT_NAME D_DEPT_NAME,
     C.CLASS C_CLASS,
     S.SUBCLASS S_SUBCLASS
FROM
     CLASS C,
     SUBCLASS S,
     DEPS D
WHERE     
     D.DEPT = 3
AND     C.CLASS = 19
AND     D.DEPT = C.DEPT
AND      C.DEPT = S.DEPT
AND      C.CLASS = S.CLASS
AND      S.SUBCLASS < 20
GROUP BY
     D.DEPT,
     D.DEPT_NAME,     
     C.CLASS,
     S.SUBCLASS
2.
SELECT
     DL.DEPT DL_DEPT,
     DL.CLASS DL_CLASS,
     DL.SUBCLASS DL_SUBCLASS,
     DL.SKU,
     DL.DESC_UP,
     SUPS.SUP_NAME,
     SUM(ISH.UNITS) ISH_UNITS,
     SUM(ISH.SALES) ISH_SALES_RET,
     SUM(ISH.UNITS*ISH.UNIT_COST) ISH_SALES_COST,
     SUM(ISH.SALES -                (ISH.UNIT_COST*ISH.UNITS)) ISH_GM
FROM      
     ITEM_SALES_HIST ISH,
     DESC_LOOK DL,
     SUPS SUPS,
     ITEM_SUPPLIER ISU,
     V_ORG_HIER VOH
WHERE      
     DL.SKU = ISH.ITEM
AND      ISH.YEAR_454 = 2003
AND      ISH.MONTH_454 = 9
AND      VOH.DIST_COMPANY IN (1,4)
AND      VOH.STORE = ISH.STORE
AND      SUPS.SUPPLIER = ISU.SUPPLIER
AND      ISU.ITEM = DL.SKU
AND      SUPS.VENDOR_GROUP ='UCS'
AND ISH.ITEM IN (40407344,40956266,41782356,41883867)
AND DL.SKU IS NOT NULL
GROUP BY
     DL.DEPT,
     DL.CLASS,
     DL.SUBCLASS,
     DL.SKU,
     DL.DESC_UP,
     SUPS.SUP_NAME
HAVING SUM(ISH.SALES) <> 0
ORDER BY 8 DESC
When I run this report I am getting a page with Dept and Class even if there are no subclasses (detail) found. I only want to show pages with details. Can anyone help me to solve this problem?
Thank you!
Mohan (Developer)
Advertisement
Hi Mohan,
I couldn't get rid of the Dept and Class headers with an empty pageYou can try this:
1. Create a summary column in the data model inside the dept group. Choose function > Count and source > subclass, and reset at > dept_group
2. Go to the Dept repeating frame, and in the property inspector > format trigger, write the code in my previous post. Instead of <subclass> write the <summary_column>. Or, you could also use the conditional formatting UI (select hide object if the summary_column value is 0). You can reach the conditional formatting UI through the property inspector of the Dept and Class headers.
Note that this will only hide the dept repeating frame, so your headings should be in this repeating frame. This may be fine in your case, as you have only one record per page.
The max no of records that you have set should have no effect on the above suggestion.
Navneet.
Read the other 4 answers
Hi friends, is there any possibility to get rid of the above said message box, when user decides to not to run the report after actuallyhe called the report using RUN_PRODUCT built-in. some time the users do like this, and when they close the report
Hi All, In a query output, # values are shown for the charactersitics which are null. I would appreciate if someone would help showing null instead of # in the reports for the null values. Regards SubbaHi, There are various options. 1. Exclude the #
Hello, My report is grouped by Account, all fields are placed in the Group Footer section. The detail section id suppressed. I am showing narratives for accounts, and each account can have multiple narratives. Because I put narratives in the group fo
after Developer tools migrate from D2K60 to D2k6i (with patch7), if call multi reports with ASYNCHRONOUS comm mode from forms, these will have multi reports background engine will startup, so need more session will connect to database, this is my nee
Hello gurus, We are implementing several security measures in our application, some of them are related to reports execution/visualization, we need to avoid users accessing reports that they don't have privilege to see. The reports were execute by Fo
Hi, In one of My report is using for calculating the age for material.In that report first i am selecting the all quantites from MARD table then for each material i am calculating the quantity from MCHB table fnally i am calculating the age and calcu
Hi,    There is a need to show hide/show tabs based on User Profile or any other method.    There are 1. Summary  2. Detailed Tab in report.    For data analysts client want to show Detailed tab so that Analysts can work on Analysis.  Managers shoud
Hello, I have a Webi report with a query that has one filter (it states the starting and ending date of data to be displayed in the report). This report has to be scheduled but it has to contain different filter values each time the report is run. I'
I have 2 report objects which are scheduled/refreshed daily around 8:00am ish. History shows a new report instance is successfully created each day. I have a recurring daily publication which emails them out to dynamic recipients as PDF attachements
Hi, when i am using ttitle and btitle options in oracle report, page number & date gets automatically added top of my report. Is there any option if i don't want these two to appear on my report. how can i disable them.Hi, user8531525 wrote: Hi, when
Hi all, In our R/3 system, there is a custom sales report. My question is: is there possibility to get data by running this report and grab it the result with code and store it in internal table? Sorry if my question too basic because I am not abaper
When our report server is restarted always a number of reports are started automatically. I don't know why these are started automatically? Is there a avoid starting these reports?Hello, If you are storing the jobs on the database then please check:
I am using sql 2008 R2 SE. Currently I have separated out our reports databases that are being used for internal purpose. However these report databases are logshipped secondary databases being hosted on secondary server. The reason I separated repor
Experts - Is there a method (or best practice) to clone a snapshot of a hierarchy at year end, and allow for reporting off of it should the users need to go back in time and see how things look? (due to audits - changes to previous fiscal year can oc
hi everyone, In the SAP Customizing, I deactivate the integration of Travel Request with Travel Expense to avoid creating expense report from travel request. But I still have in the Web Dynpro service, the possibility to select a travel request every
Hello, When we migrated from a Windows environment for our Reports10g Services to Linux, for some reports, the default parameter form generated from the browser (rwservlet) has prompts with font size 2 which is rather small for some users. Is there a
Hi All, We have created many reports and sqvi querys,  After marked deletion flag for material it is reflecting in reports and queries. What will be reason and how it will be avoid in reports. YusufHi, This is just one of the problems with writing cu
Hi All, Is it possible to avoid triggering same report by multiple users at the same time? If so please let me know. Thanks, MohanNo, Each user will run a instance of the report , with different/same parameters. So its not possible to restrict from t
Dear all, is there a way to generate a report instance only if there hits in the recordset? This would avoid sending empty reports. My first idea work-around was to create a report doing a count on the recordset and fire an event in case of hits. Thi