cancel
Showing results for 
Search instead for 
Did you mean: 

run two report in one Excel sheet1 and sheet2

Former Member
0 Kudos

Hi all;

I want to have my one report in sheet1 and another one in sheet2 when I opened my excel sheet. How can I perform this two report in one excel sheet. I can copy the report and paste but then there would be no drill down or other functionality.

thank. you.

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Krishma,

Goto the second sheet and Insert your query here too. You can do this from the Tools button.

Hope this helps...

Former Member
0 Kudos

I didn't see that insert query there. could you please give me the steps. .

1. I execute my first query

2. ...

3...

thanks.

former_member188975
Active Contributor
0 Kudos

Hi Krishma,

As you mention, you executed the first query.

It is on Sheet 1.

Then goto Sheet 2 of your Excel workbook.

From the Bex toolbar click Tools button and choose Insert Query.

Hope this helps...

Former Member
0 Kudos

Bhanu;

How can I send this combined report to the users so that they can have this refresh option if they want to refresh the query. Can I send an workbook directly to the users? How?

thanks.

former_member188975
Active Contributor
0 Kudos

Hi Krishma,

You can save this workbook to your PC and email it to your user. They need to open the workbook (with Bex running in Excel). When they click the refresh button they system will prompt them to log on (if they are already not logged in) and then the queries will be executed.

Hope this helps...

Answers (0)