June 14, 2011 at 4:29 am
hi,
i have a situation where i need to display the selected values in multivalued parameters in table format so that when we export it will display in as a row by row. how can i achieve this by using custom coding/or any other way.
kindly help me out.
Thanks
🙂
June 15, 2011 at 12:50 am
hi
I am sure whatever values you select from your multi velue parameter , you are getting it from a table..
FOr example of EMployee Id as multi velue parameter
if I select Employee Id 1001 and 1002
there must be one select statement with IN statement with it
e.g. SELECT COL1,col2
FROM <Table>
WHERE employeeID in (@Multivalueparameter)
Solution:
Well in above statement all you need is add EmoloyeeID in SELECT statement
e.g. SELECT EmployeeId,Col1,Col2
FROM <table>
WHERE employeeID in (@Multivalueparameter)
If you need to show this in other table matrix you can make different dataset which accepts same multiValue parameter variable
and you can have SELECT statement like below
SELECT employeeID
FROM <Table>
WHERE employeeID in (@Multivalueparameter)
Let me know if you need further clearification !!!
Enjoy your day!!
June 15, 2011 at 4:18 am
its good, but i dont want query again,
becasue it(selected values are) was already in the drop down, my concern is using this dropdown and populate the table.
Thanks
🙂
June 16, 2011 at 10:09 pm
Badra,
You dont need to query again, you can use same data set you have created to displlay the result
all you need is add Necessary column in that dataset (here EmployeeId) , this is the way you dont need to Run/ Write query again. And ofcource you will get it in table form.
Let me know if you need further clearification
June 17, 2011 at 2:54 am
hi thanks for your reply,
i dont understand how it can be done? please post any links that help me to do this task( any links)
thanks
🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply