Regrading Excel Group Report

[Poojaavi123]

Hi, In my LabVIEW project, we currently generate a group report of 2–3 specimens in Word. How can we replicate this in Excel—specifically, how can we create a combined group report in Excel and merge the specimens the same way we do in Word?

Can you please support me regarding this.

[Bob_Schor]

It really helps us to help you if you provide information about the following:

• What version of Windows are you running?  10?  11?  32-bit?  64-bit?
• What version of LabVIEW are you running?  Base?  Full?  Professional?  Academic?  Community?  32-bit?  64-bit?
• What version of Microsoft Office are you running?
• How much LabVIEW experience do you have (weeks?  months?  years?)

Please provide an example of what you mean by "a group report of 2–3 specimens in Word".  Open Excel, and provide an example of what you mean by "a combined group report in Excel".  What do you mean by "merge the specimens the same way we do in Word"?

You use the term "we" -- are you students working on a project together?  Engineers developing a product?

Bob Schor

[Poojaavi123]

Hi,

Thank you for your response. Please find the requested information below to help clarify my query:

1. Windows Version: Windows 11, 64-bit

2. LabVIEW Version: LabVIEW 2023 Professional, 64-bit

3. Microsoft Office Version: Microsoft Office 365 (64-bit)

4. LabVIEW Experience: Approximately 4 year of experience (including usage of the Report Generation Toolkit and basic data acquisition tasks)

5. Clarification on "Group Report of 2–3 Specimens in Word":
   In our LabVIEW project, we typically generate individual test results for 2–3 specimens and combine them into a single Word document using the Report Generation Toolkit. This document includes data tables, graphs, and conclusions for each specimen, grouped under their respective headings.

6. Clarification on "Combined Group Report in Excel":
   We are trying to replicate this process in Excel — that is, instead of generating separate Excel files for each specimen, we want to merge the data from 2–3 specimens into a single Excel report, ideally with separate sheets or well-structured sections within the same sheet.

7. Meaning of "Merge the Specimens the Same Way We Do in Word":
   By this, we mean consolidating the data of multiple specimens into a single file, maintaining their identities clearly (e.g., headings, labels, results), just as we do in the combined Word report. Our goal is to automate this grouping in Excel using LabVIEW.

8. Regarding "We":
   We are a team of engineers working together on product testing and data reporting automation using LabVIEW.

Please let me know if you need sample files or screenshots for further clarity. I appreciate your support and guidance.

Best regards,

Pooja

[Bob_Schor]

Thank you for the clear explanation.  Yes, you certainly should be able to do what you describe with the Report Generation Toolkit (I've done it myself on several occasions).

How familiar are you with using the RGT?  Do you know how to create a "structured" Excel Report, say something that looks like this?

If not, you can find the source code I posted on the Forum a decade ago -- look for "Revised Generate Excel Report Example".

As you describe what you want to do, I see three steps you need to consider: 

• Gather the data from "Report 1" and "Report 2".  The "easy" way is if the data are not on Excel, but somewhere else (where you used them, perhaps, to write Excel Report #1 and Excel Report #2).  Slightly harder (but not too bad) is to re-acquire the data from the two Excel reports.
• Decide how you want to organize your two sets of data, especially how you want to organize the various Excel Worksheets.  You might want separate sheets for data from single Reports, and various "combination" pages where you combine the data.
• Now you can design the output Workbook and Worksheets.  This is usually the simplest step -- you are just writing Excel.

Hope this is helpful.  Good luck with your project.

Bob Schor