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
jovanni  
#1 Posted : Thursday, November 13, 2014 2:06:56 PM(UTC)
jovanni

Rank: Member

Groups: Registered
Joined: 10/29/2014(UTC)
Posts: 12
Italy
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 ?
epf  
#2 Posted : Friday, November 14, 2014 9:22:15 AM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 205 time(s) in 198 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.
jovanni  
#3 Posted : Friday, November 14, 2014 11:40:04 AM(UTC)
jovanni

Rank: Member

Groups: Registered
Joined: 10/29/2014(UTC)
Posts: 12
Italy
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

epf  
#4 Posted : Monday, November 17, 2014 12:34:52 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 205 time(s) in 198 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.
jovanni  
#5 Posted : Monday, November 17, 2014 12:50:58 PM(UTC)
jovanni

Rank: Member

Groups: Registered
Joined: 10/29/2014(UTC)
Posts: 12
Italy
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 ?
epf  
#6 Posted : Wednesday, November 19, 2014 9:06:06 AM(UTC)
epf

Rank: Administration

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

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