Report Summary condition

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

Report Summary condition

Post by Fabio Pagano » Thu Mar 14, 2019 1:39 pm

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 942 times
HighAley
Posts: 8065
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Report Summary condition

Post by HighAley » Fri Mar 15, 2019 9:12 am

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: 352
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Report Summary condition

Post by Fabio Pagano » Tue May 28, 2019 3:57 pm

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 13 times
data.xml
(88.52 KiB) Downloaded 11 times
Test Stimulreport.mrt
(1.9 MiB) Downloaded 13 times
data.xml
(88.55 KiB) Downloaded 18 times
Lech Kulikowski
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary condition

Post by Lech Kulikowski » Fri May 31, 2019 1:34 pm

Hello,

We need some additional time to investigate the issue.

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

Re: Report Summary condition

Post by Fabio Pagano » Fri Jun 07, 2019 11:37 am

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

Re: Report Summary condition

Post by Lech Kulikowski » 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.
User avatar
Fabio Pagano
Posts: 352
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Report Summary condition

Post by Fabio Pagano » Tue Jun 25, 2019 4:57 pm

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 10 times
data.xsd
(31.9 KiB) Downloaded 12 times
data.xml
(265.61 KiB) Downloaded 11 times
Lech Kulikowski
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary condition

Post by Lech Kulikowski » Thu Jun 27, 2019 9:22 pm

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 395 times
User avatar
Fabio Pagano
Posts: 352
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Report Summary condition

Post by Fabio Pagano » Tue Jul 02, 2019 8:36 am

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: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary condition

Post by Lech Kulikowski » Wed Jul 03, 2019 10:47 pm

Hello,

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

Thank you.
Post Reply