LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Large Data handling and Report generation

I need some suggestion.

I am first time using the report generation toolkit.

I have a task where I first do acquistion at 8 channels, receive 50's of excel file, each file is 36,700KB. Each files I reduce twice using each excel file, with data handling program which I made,which is a tedious job.

Then I make the report using MS Word, manually.

I want to make the process simpler using the report generation toolkit and better data handling of large data.

I will attach the sample data file and my data handling program which I run twice to reduce the data.

How can I make the report automatically?

Download All
0 Kudos
Message 1 of 17
(3,641 Views)

KRAZE4LV wrote:Each files I reduce twice using each excel file

Instead of running the VI twice, why not change your decimation factor to 100 (instead of 10)?

 

I don't know what your reports are supposed to look like, so it's kind of hard to tell you what to do with the report generation toolkit VIs.  All I can tell from your description is you need to create a report of Word type.  I'm guessing from there you would want the Append Table To Report.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
Message 2 of 17
(3,626 Views)

Thank you for your reply!

Yes I want to generate a MS Word report, showing the Graph and description.

As you said before I may reduce now 1 time but I have n-number of data files,  first all the data should be merged in one excel file. What function is useful for that? One graph should be displayed in the report.

I want to combine the acqusition program+ data reducing program + report generation.

 

0 Kudos
Message 3 of 17
(3,584 Views)

When I make the program I am getting the error for report generation, as my data is very large.

How can I solve the problem? Please suggest!

0 Kudos
Message 4 of 17
(3,562 Views)

I'm not too familiar with the Report tool, but can't you create a graph in LV and export the image to the report?

/Y

G# - Award winning reference based OOP for LV, for free! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
Message 5 of 17
(3,558 Views)

The aim of my program is to:

1. Receive data for 8 channel

2. Reduce the data and merge the excel data and plot graph

3. Finally make a sample report with the graph

I am not able to achieve the last two issues.

Please advice! where I am getting wrong.

I want to generate the report with the graph of reduced data

0 Kudos
Message 6 of 17
(3,552 Views)

What do you mean by reducing the data? Do you have any acceptance format so that take only those data and can remove the rest?. Please explain.

Also what is the issue you are facing here?. Memory leakage error? As Yameda suggested you can take the image of the plot done in LabVIEW and insert into the MS Word report that will be simple instead of plotting the data in MS word using Report toolkit.

-----

The best solution is the one you find it by yourself
0 Kudos
Message 7 of 17
(3,543 Views)

Yes I am actually sampling the data to every 1000 value and am removing the rest.

I want all data to be merged in excel file and be plotted. I saw some report generation example plot the graph in the word file. Please suggest some way to merge all files and plot the graph automatically and be displayed in the report.

0 Kudos
Message 8 of 17
(3,539 Views)

Actually, in the VI if I put the acquision ON and Report ON, multiple reports are generated of Large excel data.

My purpose is to reduce the data by sampling.

Merge the excel data

Plot the One graph and generate one report with the merged excel data and graph.

How to merge the excel data?

0 Kudos
Message 9 of 17
(3,484 Views)

 workflow similar to this:

 

1) Open the Excel file

2)  create a new worksheet

 

3) Append data

 

4) Save report

 

5) Close report

I have to combine 30excel files into one excel file. It will use the for loop as the combining the excel worksheet is repeated 30 times. Plot the graph of combined excel sheet. How to use the Excel report generation tools to do this job? which VI is suitable?

0 Kudos
Message 10 of 17
(3,470 Views)