Viewing 15 posts - 16 through 30 (of 30 total)
Hi SSC Enthuastic
Your first method id working perfectly.
Thanks
November 30, 2011 at 1:26 pm
Yeah I can use directly into temp table. But i think that's not the issue. Some where lack in looping . If you know please let me know.
November 30, 2011 at 1:17 pm
Yes I am getting expected result in print statement. But when I execute this proc it is giving me result for only last value which i gave in parameter.
November 30, 2011 at 1:15 pm
Thanks all for your help.
November 29, 2011 at 1:06 pm
I am getting this error while doing this process.
I created function which will covert string into table and using that function in my stored proc. the error is :
Cannot resolve...
November 29, 2011 at 9:22 am
ok.
step 1: create one simple report for one database and run it.(check whatever you want is there or not)
step 2: then create one parameter 'SelectDatabase'. now go to parameter properties->...
November 28, 2011 at 9:31 am
I have few questions:
1. Are all databases in one server?
2. Do you want to select one database at a time or multiple?
Thanks
November 28, 2011 at 8:57 am
HI Jeswanth,
Thanks for the reply!! Sorry to say but your method won't work. You are just making server name dynamic.
My question was can we select multiple values for parameter...
November 24, 2011 at 6:46 am
Thanks Jason!!!!
I will work on that.. Thanks again. 🙂
November 23, 2011 at 12:03 pm
Hi Jason,
Can you please explain in detail if possible with example.
Thanks
November 23, 2011 at 11:44 am
Hi,
I have to create drop down menu for databases so that same report can be use for different databases.
For that I changed the data source connection string and made it...
November 23, 2011 at 11:27 am
Anyone got it working with multiple values of parameter? I get this error:
"Error during processing of the ConnectString expression of datasource ‘xxx’."
conn string: ="Data Source=servername;Initial Catalog="+Parameters!CountryName.Value
For single value...
November 23, 2011 at 9:33 am
Thanks BipinKumar and SSC Vetran
Thanks for those links. They are helpful.. M working on it . Hope I will find the solution
🙂
November 18, 2011 at 12:22 pm
Thanks for reply.
There is no front end facility to create drop down menu. I have to do it only with SSRS tool and sql.
Please let me know if you have...
November 18, 2011 at 11:17 am
hi all
I have a table in which I have different "buyer ID's" . they can be repetetive (1111122222333344444). 1 task: to extract each buyer in text file (Which is did...
July 15, 2011 at 2:36 pm
Viewing 15 posts - 16 through 30 (of 30 total)