logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
[Seal Reort 6.0]issue of Enumerated Lists of model 's restriction
Options
Go to last post Go to first unread
Previous Topic Next Topic
shilei  
#1 Posted : Monday, December 28, 2020 3:27:36 PM(UTC)
shilei

Rank: Newbie

Groups: Registered
Joined: 5/31/2018(UTC)
Posts: 2
China
Location: suzhou
Seal report 6.0: dropdown values of Enumerated Lists of model 's restriction is not shown when report execute
Seal report 5.5: is OK for the same report define

environment: windows server 2012R2, seal report run as web.net (not .netcore)


for example: test.srex
Code:
<?xml version="1.0" encoding="utf-8"?><Report xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><GUID>316e2847-d92d-4d74-ae59-990f789511ff</GUID><ViewGUID>7c4e26ba-96ea-47c7-8bfb-afb1a9b51f31</ViewGUID><Sources><ReportSource><GUID>07934bdb-999a-4ff2-8395-788bec2be67d</GUID><Name>Data Source</Name><Connections><MetaConnection><GUID>6973659f-f9cc-448d-be11-8283dd0beb03</GUID><Name>connection</Name><DatabaseType>Oracle</DatabaseType><ConnectionString>Provider=OraOLEDB.Oracle.1;Persist Security Info=True;Data Source=oracledb</ConnectionString><UserName>dcwip</UserName><Password>sjCsp9dU0G0=</Password></MetaConnection></Connections><ConnectionGUID>6973659f-f9cc-448d-be11-8283dd0beb03</ConnectionGUID><MetaData><Tables><MetaTable><GUID>8c46ff92-3794-420c-8532-5afe64c5818b</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1</Name><Type>TABLE</Type><Columns><MetaColumn><GUID>56f43d60-987a-4b25-a52a-56ad73496284</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.AOLOT</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>AOLOT</DisplayName><EnumGUID>80d76a95-e7f7-408d-b933-3060e37952e4</EnumGUID></MetaColumn><MetaColumn><GUID>7d66b40d-5dd2-429e-97ca-f1634c313b6e</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.AOLOTQTY</Name><Type>Numeric</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>AOLOTQTY</DisplayName><DisplayOrder>2</DisplayOrder><Format>N0</Format></MetaColumn><MetaColumn><GUID>f3326be7-8e59-4e01-871d-ffad7931b312</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.LABELQTY</Name><Type>Numeric</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>LABELQTY</DisplayName><DisplayOrder>3</DisplayOrder><Format>N0</Format></MetaColumn><MetaColumn><GUID>d5de280c-23aa-4fcc-90bb-976df45c32f7</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.WAFERLOT</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>WAFERLOT</DisplayName><DisplayOrder>4</DisplayOrder></MetaColumn><MetaColumn><GUID>56770c48-c5ac-4856-8f69-2b88b6ce438c</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.COMBINELOT</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>COMBINELOT</DisplayName><DisplayOrder>5</DisplayOrder></MetaColumn><MetaColumn><GUID>c9f0eea2-5300-4971-a909-ce91774ea9e6</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.CATEGORY</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>CATEGORY</DisplayName><DisplayOrder>6</DisplayOrder></MetaColumn><MetaColumn><GUID>c696bef3-4e47-4ac0-9218-1048e2f9bc31</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.ATTRIBUTE1</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>ATTRIBUTE1</DisplayName><DisplayOrder>7</DisplayOrder></MetaColumn><MetaColumn><GUID>3adda430-c36c-4471-bdb9-8388ddaca446</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.ATTRIBUTE2</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>ATTRIBUTE2</DisplayName><DisplayOrder>8</DisplayOrder></MetaColumn><MetaColumn><GUID>e003a712-83ca-4d0c-8408-01b74edb8958</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.PRINTTIME</Name><Type>DateTime</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>PRINTTIME</DisplayName><DisplayOrder>9</DisplayOrder><Format>d</Format></MetaColumn><MetaColumn><GUID>fbdf5244-253a-4bef-beef-a04ebd6923d0</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.REPRINTREASON</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>REPRINTREASON</DisplayName><DisplayOrder>10</DisplayOrder></MetaColumn><MetaColumn><GUID>f56fa197-3a35-4695-ad36-eaaf6fbed422</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.REMARK</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>REMARK</DisplayName><DisplayOrder>11</DisplayOrder></MetaColumn><MetaColumn><GUID>a607fa1b-0555-4d69-b4cc-0db65facfed0</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.UNIQUEID</Name><Type>UnicodeText</Type><Category>DCWIP.FWCATNS_LABEL_UNIQUE1</Category><DisplayName>UNIQUEID</DisplayName><DisplayOrder>12</DisplayOrder></MetaColumn></Columns></MetaTable></Tables><Enums><MetaEnum><GUID>80d76a95-e7f7-408d-b933-3060e37952e4</GUID><Name>AOLOT</Name><IsDynamic>true</IsDynamic><IsDbRefresh>true</IsDbRefresh><Sql>SELECT DISTINCT &#xD;
DCWIP.FWCATNS_LABEL_UNIQUE1.AOLOT &#xD;
FROM DCWIP.FWCATNS_LABEL_UNIQUE1 &#xD;
ORDER BY 1</Sql></MetaEnum></Enums></MetaData></ReportSource></Sources><Models><ReportModel><GUID>52db73cd-92ba-42e6-9fd5-451500242bcc</GUID><Name>Model</Name><SourceGUID>07934bdb-999a-4ff2-8395-788bec2be67d</SourceGUID><Elements><ReportElement><GUID>3e986d09-abbf-4461-b697-929381f72c9e</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.AOLOT</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>56f43d60-987a-4b25-a52a-56ad73496284</MetaColumnGUID></ReportElement><ReportElement><GUID>0c0cb18d-a450-4e14-a7e6-f291592944bb</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.AOLOTQTY</Name><DisplayName /><Format>N0</Format><PivotPosition>Row</PivotPosition><MetaColumnGUID>7d66b40d-5dd2-429e-97ca-f1634c313b6e</MetaColumnGUID></ReportElement><ReportElement><GUID>08057219-d49a-4ec4-afd6-6fdce7e70cc2</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.LABELQTY</Name><DisplayName /><Format>N0</Format><PivotPosition>Row</PivotPosition><MetaColumnGUID>f3326be7-8e59-4e01-871d-ffad7931b312</MetaColumnGUID></ReportElement><ReportElement><GUID>69104907-0f36-4632-b7b0-0f01ef809c1c</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.WAFERLOT</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>d5de280c-23aa-4fcc-90bb-976df45c32f7</MetaColumnGUID></ReportElement><ReportElement><GUID>b4501b0e-2395-4040-9c66-1800bc8e6917</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.COMBINELOT</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>56770c48-c5ac-4856-8f69-2b88b6ce438c</MetaColumnGUID></ReportElement><ReportElement><GUID>28d28c19-09fb-482f-94b6-9e871a7a14e8</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.CATEGORY</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>c9f0eea2-5300-4971-a909-ce91774ea9e6</MetaColumnGUID></ReportElement><ReportElement><GUID>2eba272b-5c6f-4c19-8847-816e2d099395</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.ATTRIBUTE1</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>c696bef3-4e47-4ac0-9218-1048e2f9bc31</MetaColumnGUID></ReportElement><ReportElement><GUID>00110d54-fdb3-4891-985d-92ff25bca9fd</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.ATTRIBUTE2</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>3adda430-c36c-4471-bdb9-8388ddaca446</MetaColumnGUID></ReportElement><ReportElement><GUID>4798b83a-d860-4c40-8910-b8318aab8ca2</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.PRINTTIME</Name><DisplayName /><Format>d</Format><PivotPosition>Row</PivotPosition><AggregateFunction>Max</AggregateFunction><TotalAggregateFunction>Max</TotalAggregateFunction><MetaColumnGUID>e003a712-83ca-4d0c-8408-01b74edb8958</MetaColumnGUID></ReportElement><ReportElement><GUID>9351bd2c-f9f6-408f-b0e5-7f966f90c607</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.REPRINTREASON</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>fbdf5244-253a-4bef-beef-a04ebd6923d0</MetaColumnGUID></ReportElement><ReportElement><GUID>064d88c7-9cc7-4e1a-8efb-41e42a9ba5d7</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.REMARK</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>f56fa197-3a35-4695-ad36-eaaf6fbed422</MetaColumnGUID></ReportElement><ReportElement><GUID>3e687201-55cf-4928-b02f-e9459519fc51</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.UNIQUEID</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>a607fa1b-0555-4d69-b4cc-0db65facfed0</MetaColumnGUID></ReportElement></Elements><Restriction>[f520cdad-2476-4c32-9c2e-2cf7cae70582]</Restriction><Restrictions><ReportRestriction><GUID>f520cdad-2476-4c32-9c2e-2cf7cae70582</GUID><Name>DCWIP.FWCATNS_LABEL_UNIQUE1.AOLOT</Name><DisplayName /><PivotPosition>Row</PivotPosition><AggregateFunction>Count</AggregateFunction><MetaColumnGUID>56f43d60-987a-4b25-a52a-56ad73496284</MetaColumnGUID><Prompt>Prompt</Prompt></ReportRestriction></Restrictions></ReportModel></Models><Views><ReportView><GUID>7c4e26ba-96ea-47c7-8bfb-afb1a9b51f31</GUID><Name>View</Name><Views><ReportView><GUID>8a7cd096-ae1c-4eb8-ae5f-3d61e57cadc2</GUID><Name>Model</Name><Views><ReportView><GUID>1ad48d50-2631-4c96-b63f-70111c0e9495</GUID><Name>Model Container</Name><Views><ReportView><GUID>f01e8149-a10b-4966-a2a6-ae95d5110db7</GUID><Name>Page Table</Name><TemplateName>Page Table</TemplateName><SortOrder>1</SortOrder></ReportView><ReportView><GUID>aecf0f51-e4bb-4ac6-9dcd-b2061c60e92a</GUID><Name>Chart JS</Name><TemplateName>Chart JS</TemplateName><SortOrder>2</SortOrder></ReportView><ReportView><GUID>3f7e4daf-4a83-446e-af5d-c7b81f2fb529</GUID><Name>Chart NVD3</Name><TemplateName>Chart NVD3</TemplateName><SortOrder>3</SortOrder></ReportView><ReportView><GUID>2be09e8a-a8b7-42c1-8ac3-62cc8eb3ee5c</GUID><Name>Chart Plotly</Name><TemplateName>Chart Plotly</TemplateName><SortOrder>4</SortOrder></ReportView><ReportView><GUID>295eb1fe-5049-48de-bcfd-7d1e4ece6410</GUID><Name>Data Table</Name><TemplateName>Data Table</TemplateName><SortOrder>5</SortOrder></ReportView></Views><TemplateName>Model Container</TemplateName><SortOrder>1</SortOrder></ReportView></Views><TemplateName>Model</TemplateName><ModelGUID>52db73cd-92ba-42e6-9fd5-451500242bcc</ModelGUID><UseModelName>true</UseModelName><SortOrder>1</SortOrder></ReportView></Views><TemplateName>Report</TemplateName><SortOrder>1</SortOrder></ReportView></Views><Cancel>false</Cancel></Report>
Back to top

Wanna join the discussion?! Login to your Seal Report Forum forum accountor Register a new forum account.
Back to top  
epf  
#2 Posted : Monday, December 28, 2020 5:54:34 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,189
Switzerland

Thanks: 14 times
Was thanked: 197 time(s) in 190 post(s)
Yes it looks like a bug (listed as number 167).
If you really need to refresh the enum values when the report is executed, as a workaround, I suggest to click on 'General' in the TreeView and use the following 'Report Execution Init Script':
Code:
@{
    Report report = Model;
    foreach (var source in report.Sources) {
        foreach (var el in source.MetaData.Enums.Where(i => i.IsDynamic && i.IsDbRefresh)) {
            report.LogMessage("Handling {0}", el.Name);
            el.RefreshEnum();
            el.IsDbRefresh = false;
        }
    }
}


This will refresh the values and set the flag IsDbRefresh to false, so the values are displayed.
Back to top
shilei  
#3 Posted : Wednesday, December 30, 2020 7:05:27 AM(UTC)
shilei

Rank: Newbie

Groups: Registered
Joined: 5/31/2018(UTC)
Posts: 2
China
Location: suzhou
thanks, I'll try as your suggestion
Back to top
TelexpressOlivia  
#4 Posted : Friday, August 20, 2021 9:55:13 AM(UTC)
TelexpressOlivia

Rank: Newbie

Groups: Registered
Joined: 8/20/2021(UTC)
Posts: 2
Taiwan, Province Of China
Location: Taipei
Hi,

Our version is 6.1 and if we use "IsDbRefresh = false;" as you suggested, the values will not be displayed.
Is this also a bug for 6.1?
Back to top
epf  
#5 Posted : Sunday, August 22, 2021 7:22:34 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,189
Switzerland

Thanks: 14 times
Was thanked: 197 time(s) in 190 post(s)
No, there is no bug open for this in 6.1, can you reproduce it with Northwind database sample ?
Back to top
TelexpressOlivia  
#6 Posted : Wednesday, August 25, 2021 11:25:59 AM(UTC)
TelexpressOlivia

Rank: Newbie

Groups: Registered
Joined: 8/20/2021(UTC)
Posts: 2
Taiwan, Province Of China
Location: Taipei
Hi,

We use the Northwind database sample and add two fields "customer contains" and "customer country equals".
The value of "customer country equals" won't filter based on the value of "customer contains" until we manually click the execute button.
The files we created are as following:

https://drive.google.com...vvG6IEv/view?usp=sharing

https://drive.google.com...ZEo4QHu/view?usp=sharing

Thank you for helping!
Back to top
epf  
#7 Posted : Thursday, August 26, 2021 3:10:12 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,189
Switzerland

Thanks: 14 times
Was thanked: 197 time(s) in 190 post(s)
I think that your enum "Customer country" must be defined using the Dynamic Display properties:

you have to fill "SQL Select statement for prompted restriction" to define a dependency with another restriction.

please check: https://sealreport.org/Sources#lineEnums_dd

however (in the current version) it is not possible to filter your enum based on another restriction which is not an enum....
this feature would require enhancements
Back to top
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET 2.2.4.11 | YAF.NET © 2003-2023, Yet Another Forum.NET
This page was generated in 0.120 seconds.