Hello,

I have multiple webfocus reports that need to be consolidated into one excel file. Essentially each tab of excel workbook would represent each individual excel report.

How can this be done? Appreciate if someone can guide me with this.

Thank you,
Gagan

This message has been edited. Last edited by: FP Mod Chuck,

The answer/technic may differ according to answers to below questions :

1- Are they from the same fex/execution ?
2- Are they using all the same TABLE FILE...END result ? Meaning, are they all using the same data source or each have their own ?
3- Do they have the same output layout or each have its own list of displayed column ? (Rpt 1 = col A, B & C, Rpt 2 = col A, B, C, D & E, …)
4- How the reports are produced ? Direct execution, from Report Caster, … ?

and maybe other questions that I don't think of actually

Check the documentation like Mike has posted.

Also what version are you on, there are many versions of 8.