Sub Totals in CSV output

rbuser

Can we not get sub-total (Group footer) and Grand Total (Page footer) lines
in a report that is output to CSV format?
It seems to only output detail lines. I could not find any reference to it
in help.

Thanks,
Vikram Kulkarni
Senior Software Engg.
Captools co.

--

nardmoseley

From the Designer, you can use the File | Print To File setup dialog to
specify which componenents in which bands get saved to delimited text file
export.

Programmatically you can specifiy which components to save by using the
Band.Save boolean and the Component.Save boolean, and the
Component.SaveOrder properties.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Thank you for your response.
I set the "save" property for the groupfooter band and also the Tppvariable
components within that band. But the subtotals still don't get included in a
CSV report. They do however showup in a regular report.
I think I am missing something here.

Vikram

nicocizik

Hi Vikram,

In my testing, a TppVariable component in the GroupFooter and PageFooter
with their Save property set to True are showing up in an exported Text
file. Are you by chance loading a template? Try using the Print To File
dialog by selecting File | Print To File Setup from the main menu in the
designer and be sure the proper components are added.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Sorry I should have mentioned that I am loading the report from a template
file. I also have custom data in the offset region. I have to print the
report programmatically and not through Print|File as I create a custom data
set to connect the report to.

However, I can open the report in the designer by specifying a offset and
when I inspect the components in the footer band they do have the Save
property correctly set.

Thanks for your prompt response.

Vikram

nicocizik

Hi Vikram,

If you are loading a template, you need to be sure you are altering the Save
property for the bands/components, then resaving the template to file or
database. If you do not do this, once you load the template, you will loose
all these property values.

If you need to set the Save property in code, be sure you do it after the
template has been loaded, in the Template.OnLoadEnd event.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com