Seal Report Forum
»
Report Edition
»
Reports
»
Restriction values vs table's values
Rank: Member
Groups: Registered
Joined: 10/29/2014(UTC) Posts: 12  Location: Schio
|
Hi,
I'm trying to use the feature Restriction values to give the possibility to user to choose a value from a list instead of insert it manually.
When I go to define the Restriction values I found only possible to insert some value manually
Value 1
Value 2
Value 3
Value 4
Instead of inserting a SELECT id, description FROM TABLE...
How can use the feature as showed on samples ?
On some fields of samples it comes out "<Click to edit values>" but I'm not able to do it on my report.
Where I set the list of possible table values admitted ?
Am I missing a step or something ?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Yes, to have restriction values listed from a table, this means creating an enumerated list for this element in the data source,
you have to:
Go in your Data Source, select the Table and the Column,
Then click on the helper 'Create an enumerated list from this column'
this will do most of the job: your column is now linked to a new enumerated list that you can customize as you want...
Check the samples in Northwind.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 10/29/2014(UTC) Posts: 12 Location: Schio
|
OK, I now understood how it works. Thanks Additional question: If you have a long list of values how can I limit the rows displayed by Restriction filter Edited by user Friday, November 14, 2014 1:48:39 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
You can just limit your values by adding a WHERE clause in the Select statement of the Enum definition.
Or by editing them directly: set first 'List is loaded dynamically from database' to false, then click on the Values property and edit the values.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 10/29/2014(UTC) Posts: 12 Location: Schio
|
OK, thanks.
If I have for istance 50 values on table and I need to be able to choose one of them what are the possibilities by default ?
I need to show for istance 5 records and then to have the scrolling bar active to scroll to that one I want to choose.
If I have to show all list completly I have a very ugly list before the report.
The 5 records in this case are settable as vertical lenght of list showed on filters when I access to report header or is it automatic ?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
You can limit the list of the enum values only the enum definition...
Sorry but there is today no option to customize/modify the presentation of the list when the restrictions are prompted, could be an improvement for future versions...
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
Restriction values vs table's values
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.
