Large Data handling and Report generation

[KRAZE4LV]

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?

[crossrulz]

---

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.

[KRAZE4LV]

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.

[KRAZE4LV]

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!

[Yamaeda]

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

[KRAZE4LV]

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

[P@Anand]

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.

[KRAZE4LV]

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.

[KRAZE4LV]

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?

[KRAZE4LV]

 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?