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: 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.
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
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-2021, Yet Another Forum.NET
This page was generated in 0.032 seconds.