February 3, 2010 at 9:10 am
i am creating an report which displays the application details
one of the parameter should be server name and the other parameter should be application name
both should not depend on each other
if the user type in the server the records should show up
this is query i am using in the dataset
SELECT *
FROM dbo.server
WHERE server in( @server)
This works fine.
but now i need to add another parameter with appname
This is the query i use for other dataset
select distinct appname from dbo.server
I have to select either one of the parameter and not both.
how do i achieve it please suggest
February 3, 2010 at 1:15 pm
Allow the blank values to both the parameters and get the results data from the main query passing either of the parameters.
select * from dbo.server
where server in (@server) OR appname in (@appname)
February 4, 2010 at 9:25 am
Thanks for the reply
still i get a prompt Please select server when i select only the application or the other way round
i choose allow blank.
in both the dropdown i get <select a value>
Not sure what i am doing wrong.
February 4, 2010 at 10:17 am
Can you able to confirm me that, are you getting the query executed when you pass the blank values to the parameters and the way you want to see in the report.
If you can get the reuslts in the dataset, then you can repeat that in the report designing without any problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply