Home Discussions Questions & Answers Excel output with data in multiple tabs

Excel output with data in multiple tabs

Avatar photoCustomer December 27, 2024 at 6:37 pm

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.

Viewing 0 reply threads
  • Author
    Replies
    • Support December 29, 2024 at 7:02 pm  

      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

Viewing 0 reply threads
  • You must be logged in to reply to this post.

Login with: