Report Generation

[Brad_Henry]

How can I update an open Excel report with a date in this format 10/04/2012.  When I try it, the date overwrites the previous date instead of going down to the next row.

[Mark_Ramsdale]

Looks like you have append new line set to false.  Set to True.

[Brad_Henry]

I tried that I had the same result.

Thanks

[Mark_Ramsdale]

Hi,

Here is a snippet that appends lines to a report.

The PNG you provided doesn't explain how the report reference is generated and it only shows one "run" of data.  This snippit is generic loop.   If you can provide more detail this can be looked at.

mark

[Brad_Henry]

Will this work in Excel too?

Brad

[Mark_Ramsdale]

Of course not, that would be to simple 🙂

let me see why it is over writing. 

[Mark_Ramsdale]

Hi,

Here ya go.  I often have to build wrappers around the report VI's in order to mess with formatting and stuff.  In this case the Excel position.

Interestingly, the append no longer seems to matter with excel.

[Wayne.C]

Mark,

Pretty sure this changed when they rewrote the toolkit to use classes.

[Brad_Henry]

I was wondering how to interact with the MS Office Parameters!

Thanks!

[Brad_Henry · Accepted solution]

Works great!

Thanks for your help!

Brad