Excel output with data in multiple tabs
Hello Support,
Is there a way to create Blitz report which produces output in EXCEL but has multiple queries, each query output going to a different tab/worksheet in EXCEL?
If so, please send us some details on how to get this setup.
1 reply
Unfortunately, the current Blitz Report version does not have this functionality yet.
We have had this on our todo list for a while already and will definitely build it in the future, but as there are many code dependencies, it is not a quick development.
The only possibility to create different worksheets with Blitz Report right now would be using the Sheet Break functionality on the Template screen.
So as a workaround for now, you might be able to use a union all query and break up the data by a column value, but this has the limitation that the column names would need to be the same across the different datasets.
Regards,
Andy
- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.