how to generate report of data which is in excel?

[LV_user1]

hii...

i am having my database in excel where i have stored complaints information of the particular department in an office.

Now i want to generate the report of the information stored in excel as per complaint,as per departmant,as per all departments and finally report of entire office...

how should i do using report generation toolkit?

is there any other way than report generation toolkit?

plzz tell me...

thanks.......

[muks]

You can use a write to spreadsheet file. Can you post the input data and how you want that to look in excel?

[Harold_Timmis]

if you look through the examples that ship with labview, there are a couple of examples on how to use labview to obtain data from excel.

just search for excel.

[Joe_H]

For more information and some sample VI's and tool kits, you can go to the excel board

[Michael_Munroe]

Sounds like a pivot table would be appropriate.  You need a template document with the reports setup. Just select the entire area before the data is inserted and create the pivot table on another sheet (column headers must be present).  The pivot table will update as the data is entered and can be printed easily with the RGT.  Use separate sheets for other combinations.

[LV_user1]

thanks for the reply....but i didnt get th option what exactly do u mean by pivot table...i have no idea regardin that....can u pls expalin it...where is that option????

thanks in advance

[Mathan]

Pivot table

[Complex]

Hi Joe

Could you help me in attached file, how I can  modify my program to have graph in my excel template, while I want to Y axis has scale(2,4,6,8) and X axis has scale(1,3,5,7)?