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
Enum list do be dynamic based on Restrictions?
Options
Go to last post Go to first unread
Previous Topic Next Topic
TheStigh  
#1 Posted : Tuesday, May 2, 2017 12:44:43 AM(UTC)
TheStigh

Rank: Member

Groups: Registered
Joined: 4/17/2017(UTC)
Posts: 12
Norway

Thanks: 6 times
Hi,

Can the Enumerated list be dynamical depending on Restrictions set?

Example would be a counter inside a table that increases twice per day, and by setting restriction of DATE, the ENUM should be populated with the two counter-values valid for today only (as an extra Restriction?

Or is there a different way of doing this?


Thx,
Stigh
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 : Tuesday, May 2, 2017 8:02:11 AM(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)
If the enum is built dynamically from your database, you could check the option:
'List is refreshed upon the database connection' to True, in this case the enum is rebuilt before executing the report using your SQL statement (may be time consuming).

Another option is to schedule a task to refresh the enums of your Data Source twice a day (in your case), you can see a sample with the report 30 in the sample directory.

Good luck.
Back to top
TheStigh  
#3 Posted : Tuesday, May 2, 2017 8:07:35 AM(UTC)
TheStigh

Rank: Member

Groups: Registered
Joined: 4/17/2017(UTC)
Posts: 12
Norway

Thanks: 6 times
Originally Posted by: epf Go to Quoted Post
If the enum is built dynamically from your database, you could check the option:
'List is refreshed upon the database connection' to True, in this case the enum is rebuilt before executing the report using your SQL statement (may be time consuming).

Another option is to schedule a task to refresh the enums of your Data Source twice a day (in your case), you can see a sample with the report 30 in the sample directory.

Good luck.


Ok, but this means it can't do what I was asking, which is;
During report creation, I set from and to date (the date-range), then it should update the available list of counter's to be in a list?

I think there was another question on this page about the same, but the poster didn't follow up on the question...


Thx,
Stigh
Back to top
epf  
#4 Posted : Tuesday, May 2, 2017 2:52:00 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)
For this you have to code a little bit in your init script.
Check this post: https://sealreport.org/forum/default.aspx?g=posts&t=343#post811

In your case, you have to get the restriction values and insert them in the SQL generated for the enum...
Back to top
Users browsing this topic
Guest (2)
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-2024, Yet Another Forum.NET
This page was generated in 0.078 seconds.