Joined: 16 Apr 2009
Location: United Arab Emirates
Online Status: Offline
Posts: 1
Topic: Parameter Problem Posted: 16 Apr 2009 at 1:31am
Hi Guys,
I have a material consumption summary report. That has two parameters: Project e.g AE1-1274,PK-2172,OM-1667 ...etc and the second parameter of Task e.g 01-101,02-101,03-102 ..etc. However now i have a requirement from end-user that they want to select multiple projects and corresponding task values and summary should appear for all the values selected. Ideally what i want is that users should be able to select multiple values from a drop down list having concatenated values like : AE1-2172-02-101 PK-1234-01-101 PK-1234-02-101 Upon selection i want to break that value and use it and present the summary for corresponding values of Projects and Tasks. Is it possible to tie parameters with a query ? Or what should be the strategy to acheive the desired result. Hope i made myself clear. Any sort of help will be highly appreciated !!
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 16 Apr 2009 at 5:08am
You can populate a multiple selection box based on a Command, which is just a SQL Select statement. You can create a command by click on the database expert. where you see the list of tables to select your report from, there is an entry, New Command. You will be able to concatenate and then populate. From there it would be filtering out the data you don't want, but you can check if it is in the array that the user selected.
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
IP Logged
