Oracle Analytics and AI

3018071

I have a parent report that contains

   

Month	Brand	Header 3
Jan Feb Mar Apr May Jun	lee spyker wragler zara veromoda mango	282 478 246 267 309 264

Here 282 is the count(item_no) .

In the child report i want all the item wise detail. If the user clicks on 282 ,it should display all the 282 item details in the child report.

Item no	item name	item purchase date	item mfg date	size
10003211	jeans	01-01-2017	31-01-2016	30
10003212	jeans	01-01-2017	31-01-2016	32

All i need is, i need to pass all the item numbers from parent report to child report. Can it be possible.

I am unable to achieve it please help me in this regard.

Reagrds,

Bishnu

Gianni Ceresa

Hi,

3018071 wrote:All i need is, i need to pass all the item numbers from parent report to child report.

This is actually the wrong question and wrong approach...

In your summarized table the item numbers doesn't exist, it's an aggregated view, so you do not pass the item numbers to the child report but you pass the information of the aggregation.

In your case for 282 what you need in the child report is "month=Jan" and "brand=lee", that's all you need.

Filtering your child report based on these 2 values you will then get all your details out.

On the child report you don't need to display the information of Month and Brand but they will definitely be helpful for the use to remember what he is seeing (in case of an export or print).