mibuso.com

Microsoft Business Solutions online community
It is currently Fri May 24, 2013 10:33 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: listbox source expr setting from databse option field
PostPosted: Fri Mar 30, 2012 9:58 am 
Offline

Joined: Mon Nov 28, 2011 2:31 pm
Posts: 57
Country: Georgia (ge)
I have a "season" option field in Itemledger entry table and option string is " ,Spring,Summer,Spring-Summer,Autumn,Winter,Autumn-Winter"

I am trying to make a report and need a listbox for season field.
I want to set listbox source expr =Itemledger entry ."Season".



But it is not working.

It works when i create a global season option variable . I want to take data direct from Itemledger entry table field.

how to do this?


Top
 Profile E-mail  
 
 Post subject: Re: listbox source expr setting from databse option field
PostPosted: Fri Mar 30, 2012 10:05 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4226
Location: New Delhi
Country: India (in)
monir_asian wrote:
I want to take data direct from Itemledger entry table field.


What does this statement mean?
you want to apply the filter directly without writing code?

If Item Ledger Entry is your dataitem then did you try by adding season in ReqFilterFields ?

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
 Post subject: Re: listbox source expr setting from databse option field
PostPosted: Fri Mar 30, 2012 10:09 am 
Offline

Joined: Mon Nov 28, 2011 2:31 pm
Posts: 57
Country: Georgia (ge)
I do not want in request filter field.

I want to add this on option form and want to add source expr of textbox field=Itemledgerentry.Season that data can come from table.


Top
 Profile E-mail  
 
 Post subject: Re: listbox source expr setting from databse option field
PostPosted: Fri Mar 30, 2012 10:35 am 
Offline

Joined: Thu Oct 30, 2008 10:38 am
Posts: 987
Location: Earth
Country: Netherlands (nl)
Quote:
It works when i create a global season option variable . I want to take data direct from Itemledger entry table field.

You have 2 choices, either create a global season option var and it will work.
Or you create a global rec variable of item ledger entry that you only use to let the user select the optionstring in a field.
Like globalrec.season.

_________________
|Pressing F1 is so much faster than opening your browser|
|MCBMSS: 5.0 intro|MCTS:NAV09 839..841|JetReports© Certified Specialist|
|Dynamics Anywhere: Mobile Business Solutions|


Top
 Profile  
 
 Post subject: Re: listbox source expr setting from databse option field
PostPosted: Fri Mar 30, 2012 11:33 am 
Offline

Joined: Mon Nov 28, 2011 2:31 pm
Posts: 57
Country: Georgia (ge)
thanks


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: medianoche and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: