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

Notification

Icon
Error

Options
Go to last post Go to first unread
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>
epf  
#2 Posted : Monday, December 28, 2020 5:54:34 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 967
Switzerland

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.
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
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.