Report Summary condition

Stimulsoft Reports.NET discussion
Post Reply
User avatar
Fabio Pagano
Posts: 355
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Report Summary condition

Post by Fabio Pagano »

Hello,
I'm using report summary and i'd like to set the condition in order to a value printed in a text field
This text field (Text35) print a sum result
I'd like condition enable property of an other filed (richText9) in the report summary in order of the value of "text35"

I'll try to explain better

In Text35 is set the follow expression:
{Sum(DataBandImpiantoAccettazioneParziale,
Switch(
Left(DescrizioneLavoroDettagliata.Lavoro__Codice,4)== "OA14",1000,
Left(DescrizioneLavoroDettagliata.Lavoro__Codice,4)== "OA16",100,
Left(DescrizioneLavoroDettagliata.Lavoro__Codice,4)== "OA12",10)
)
/CountRunning()}

the result is 1110

I attached an image of my report summary with fields

How can I use the value of Text35 to set a condition for printing an other text field?
thanks in advance
Attachments
report summary1.jpg
report summary1.jpg (57.49 KiB) Viewed 3843 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Report Summary condition

Post by HighAley »

Hello, Fabio.

There could be different reasons for the issue.
Could you send us your report template with sample data?

Thank you.
User avatar
Fabio Pagano
Posts: 355
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Report Summary condition

Post by Fabio Pagano »

Hello,
I attached data file and report.

As you can see the text is cut when the page ends, and it is reported in full on the next page.

May you help me?
Thanks
Attachments
data.xsd
(31.9 KiB) Downloaded 136 times
data.xml
(88.52 KiB) Downloaded 139 times
Test Stimulreport.mrt
(1.9 MiB) Downloaded 143 times
data.xml
(88.55 KiB) Downloaded 170 times
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary condition

Post by Lech Kulikowski »

Hello,

We need some additional time to investigate the issue.

Thank you.
User avatar
Fabio Pagano
Posts: 355
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Report Summary condition

Post by Fabio Pagano »

ok, I'm waiting.
Thank you.
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary condition

Post by Lech Kulikowski »

Hello,

Names of tables in the sent files and in the dictionary are different.
Please modify your report that we can run it with sent data.

Thank you.
User avatar
Fabio Pagano
Posts: 355
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Report Summary condition

Post by Fabio Pagano »

Hello Lech Kulikowski,

look at the attached files.
I hope you can help me.
thank you


Lech Kulikowski wrote: Wed Jun 12, 2019 5:46 pm Hello,

Names of tables in the sent files and in the dictionary are different.
Please modify your report that we can run it with sent data.

Thank you.
Attachments
Test Stimulreport.mrt
(1.9 MiB) Downloaded 142 times
data.xsd
(31.9 KiB) Downloaded 127 times
data.xml
(265.61 KiB) Downloaded 136 times
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary condition

Post by Lech Kulikowski »

Hello,

Please modify your report that we can run it with sent data.

Thank you.
Attachments
Annotation 2019-06-27 232216.jpg
Annotation 2019-06-27 232216.jpg (77.93 KiB) Viewed 3296 times
User avatar
Fabio Pagano
Posts: 355
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Report Summary condition

Post by Fabio Pagano »

I'm sorry, I followed thin instructions to generate xml and xsd files

Re: Problem with Switch operator in Text ekenent
Post by Lech Kulikowski » 14 Aug 2018 14:13


You could send some data to XML file if you write next code in the BeforePrint event of a page:
[YourDataSourceName].DataTable.DataSet.WriteXml(@"e:\data.xml");
[YourDataSourceName].DataTable.DataSet.WriteXmlSchema(@"e:\data.xsd");


Unfortunately It seems that the names of the original tables have been replaced by genrerics.

There is an alternative method to generate files?
Thanks in advance
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary condition

Post by Lech Kulikowski »

Hello,

You can try to save it before registration in the report, in your code.

Thank you.
Post Reply