Appending multiple tables and exporting them as one table to Excel

[#1]

Hi,

I want to append 3 Tables (created on the front end ) from QV and want to export them to excel as one single table ?
Thanks,

Jaskirat

[senarath]

Hi,

What you could do is that;

01.Create a Report incorporating 03 reports under Reports menu

OR

02. You could create a single table which includes content of all 03 reports and keep it either minimized or show dynamically until when you want to export to excel.

thanx

[#3]

Hi,

Thanks for  your prompt reply!
But the issue is that we have 3 straight tables on frontend with similar fields, just want the data from all 3 to get appended when we export all three to excel....

[ashfaq_haseeb]

This is not possible directly.

You have to go with some macro.

Regards

ASHFAQ

[vardhancse]

1. if you want to load only one single table by merging all the 3 tables, then join the tables based on the common field.

and then you can create one table box with all the fields.

then we can export in to excel sheet from front end

2.    if you want to export after loading in to 3 separate table, there must be some relation between tables.

the in the table box we can select required fields and can export in to excel

[#6]

Hi,

Thanks ! I need to simply export the tables to excel and append them .
Constraints are :
-Use a single app, cannot create another to app to load 3 tables and apply the merge.
-Cannot Use MAcros.
Thanks,
JAskirat

[senarath]

Hi.

You mean to say that you want all columns in that 03 report to amalgamate into a single report ?

01.You could think of using Concatenation at script level

OR

02. As I mentioned, could develop a new report in such a manner that includes dim and expressions of other 03 reports in common if the fields are similar

If you could post a example, it will be helpful for any body who is going to reply you.[including me :-)]

Sorry if I have misunderstood your requirement.

[vardhancse]

how you are loading the tables in the app.

we can use table box: and add the required fields and can export in to excel