Report Summary condition
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Report Summary condition
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
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 (57.49 KiB) Viewed 3949 times
Re: Report Summary condition
Hello, Fabio.
There could be different reasons for the issue.
Could you send us your report template with sample data?
Thank you.
There could be different reasons for the issue.
Could you send us your report template with sample data?
Thank you.
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Report Summary condition
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
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 148 times
-
- data.xml
- (88.52 KiB) Downloaded 148 times
-
- Test Stimulreport.mrt
- (1.9 MiB) Downloaded 151 times
-
- data.xml
- (88.55 KiB) Downloaded 178 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Report Summary condition
Hello,
We need some additional time to investigate the issue.
Thank you.
We need some additional time to investigate the issue.
Thank you.
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Report Summary condition
ok, I'm waiting.
Thank you.
Thank you.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Report Summary condition
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.
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.
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Report Summary condition
Hello Lech Kulikowski,
look at the attached files.
I hope you can help me.
thank you
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 150 times
-
- data.xsd
- (31.9 KiB) Downloaded 135 times
-
- data.xml
- (265.61 KiB) Downloaded 147 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Report Summary condition
Hello,
Please modify your report that we can run it with sent data.
Thank you.
Please modify your report that we can run it with sent data.
Thank you.
- Attachments
-
- Annotation 2019-06-27 232216.jpg (77.93 KiB) Viewed 3402 times
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Report Summary condition
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
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
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Report Summary condition
Hello,
You can try to save it before registration in the report, in your code.
Thank you.
You can try to save it before registration in the report, in your code.
Thank you.