Page 1 of 1

partial sum

Posted: Wed Dec 03, 2014 2:45 pm
by alepage
Hi,

I'm trying to calculate partial sum for each line of a data band :
1st_attachment.jpg
1st_attachment.jpg (110.12 KiB) Viewed 2188 times
The first solution i found is to use a text output with a summary that i put in the data band :
2nd_attachment.jpg
2nd_attachment.jpg (35.65 KiB) Viewed 2188 times
The others text outputs located above are using the increazingSize and the descreasingSize shiftmode parameters. Those components are also setting up with conditional formatting to disable them under conditions
3rd_attachment.jpg
3rd_attachment.jpg (121.92 KiB) Viewed 2188 times
In a edition, if those components are just disable, the increazingSize and descreazingSize parameters don't work, and I have a large blank in the data band left by the output texts
4th_attachment.jpg
4th_attachment.jpg (59.58 KiB) Viewed 2188 times
The second solution i found is to use a child band below the data band. The blank is fill, but the output text with the summary doesn't add up anymore.

Is there another solution to calculate a partial sum with each line of the data band with the others contraints.

Best regards,
Arnaud

Re: partial sum

Posted: Thu Dec 04, 2014 8:36 am
by HighAley
Hello.

Please, send us a report template with sample data to reproduce your issue.

Thank you.

Re: partial sum

Posted: Thu Dec 04, 2014 9:03 am
by alepage
Hi Aleksey,

I found an issue by assigning a null expression in the conditions of the different text components.

Thanks and best regards,
Arnaud

Re: partial sum

Posted: Thu Dec 04, 2014 9:47 am
by Alex K.
Hello,

Ok.
Let us know if you need any additional help.

Thank you.

Re: partial sum

Posted: Thu Dec 04, 2014 10:46 am
by alepage
Well,

My report almost works, but I have difficulties with blanks.
Using a child band might be preferable, but the text components (in brown in the report) doesn't calculate that I want.

Thanks

Re: partial sum

Posted: Fri Dec 05, 2014 11:32 am
by HighAley
Hello.

We need to reproduce the issue to help you.
There is no data for the report template.
Please, send us sample data for the report.

Thank you.

Re: partial sum

Posted: Mon Dec 08, 2014 9:46 am
by alepage
Hello Aleksey,

There is a data file.
Thanks.

Re: partial sum

Posted: Tue Dec 09, 2014 11:01 am
by HighAley
Hello.

Sorry, but we still couldn't reproduce the issue.
Could you use the following code in the BeforePrint event of a page and sent us the files you will get.

Code: Select all

{YourDataTableName}.DataTable.DataSet.WriteXml("e:\\data.xml");
{YourDataTableName}.DataTable.DataSet.WriteXmlSchema("e:\\data.xsd");
Thank you