Seal Report Forum
»
Troubleshooting
»
Bug Reports
»
[Seal Reort 6.0]issue of Enumerated Lists of model 's restriction
Rank: Newbie
Groups: Registered
Joined: 5/31/2018(UTC) Posts: 2  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 
DCWIP.FWCATNS_LABEL_UNIQUE1.AOLOT 
FROM DCWIP.FWCATNS_LABEL_UNIQUE1 
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>
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 967  Thanks: 14 times Was thanked: 167 time(s) in 161 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.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 5/31/2018(UTC) Posts: 2  Location: suzhou
|
thanks, I'll try as your suggestion
|
|
|
|
Seal Report Forum
»
Troubleshooting
»
Bug Reports
»
[Seal Reort 6.0]issue of Enumerated Lists of model 's restriction
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.