topic Re: Executing Two Queries with F5 in Report Server

Executing Two Queries with F5

M_nwadibia — Wed, 26 Oct 2022 12:24:02 GMT

Hello,

I have a requirement to exceute two SQL Queries in Query designer.

select * from Table A;

Select * from Table B

The result produces to tables when exported using excel instance

It works in Toad for Oracle but not working in Query designer. What options do I have as I am seeing this the first time

Re: Executing Two Queries with F5

d_gosbell — Wed, 26 Oct 2022 23:28:45 GMT

It is not clear whether you are talking about the Query designer in Paginated Report Builder or Power BI Desktop. But either way you cannot execute 2 queries at once.

I'm assuming that these are two individual tables and that you don't want to join them.

If you are building a paginated report you will need to create 2 datasets and put each query in it's own dataset. You can then put two tables in your report and link each one to a different dataset.

If this is a Power BI Desktop report you would have to bring each query in as a separate table and you could then use two separate table visuals.

Re: Executing Two Queries with F5

M_nwadibia — Wed, 02 Nov 2022 11:38:18 GMT

Yes these are two separate tables. Linking the two dataset using Parameter will it generate two tables when exported in excel.? The requirement is to export the two tables in a single email to the user

Re: Executing Two Queries with F5

M_nwadibia — Wed, 09 Nov 2022 13:34:12 GMT

What I have done is to create two dataset from the datasource and then have the two dataset reports exported to tab1 and tab2 in excel.