partial sum

Stimulsoft Reports.NET discussion
Post Reply
alepage
Posts: 56
Joined: Mon Jan 19, 2009 7:02 am
Location: France

partial sum

Post 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 2182 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 2182 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 2182 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 2182 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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: partial sum

Post by HighAley »

Hello.

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

Thank you.
alepage
Posts: 56
Joined: Mon Jan 19, 2009 7:02 am
Location: France

Re: partial sum

Post 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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: partial sum

Post by Alex K. »

Hello,

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

Thank you.
alepage
Posts: 56
Joined: Mon Jan 19, 2009 7:02 am
Location: France

Re: partial sum

Post 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
Attachments
[supplier] test.mrt
(117.5 KiB) Downloaded 342 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: partial sum

Post 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.
alepage
Posts: 56
Joined: Mon Jan 19, 2009 7:02 am
Location: France

Re: partial sum

Post by alepage »

Hello Aleksey,

There is a data file.
Thanks.
Attachments
reportdata.xml
(23.94 KiB) Downloaded 355 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: partial sum

Post 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
Post Reply