logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


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: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 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
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?
epf  
#5 Posted : Sunday, August 22, 2021 7:22:34 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
No, there is no bug open for this in 6.1, can you reproduce it with Northwind database sample ?
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!
epf  
#7 Posted : Thursday, August 26, 2021 3:10:12 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 206 time(s) in 199 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
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.