Viewing 12 posts - 1 through 12 (of 12 total)
i got the answer here
http://www.sqlservercentral.com/Forums/Topic576286-1063-1.aspx
October 4, 2011 at 12:58 am
Eugene Elutin (7/21/2010)
Have you tried to use the column from the DataSet used for report to populate the Paramaeter ListBox? Does it works at all?
Yes i have done that and...
July 21, 2010 at 8:32 am
Praveen Goud Kotha (7/21/2010)
What you are going to achieve with this..??Can i know where you are going to implement(practically) this..?
I have an SSRS report which takes a value in COL2...
July 21, 2010 at 6:48 am
I have made some clarification.
I basically want COL3 to return the Distinct values of COL2, (remove duplicates from COL2 and return the unique values in COL3. Hope am much...
July 21, 2010 at 5:21 am
if i am preparing for exams 70-433 and 70-451, should i expect questions relating to SQL Server 2008 R2?. would it be ok to use SQL server 2008 R2 books...
April 12, 2010 at 1:06 am
bitbucket-25253 (1/14/2010)
Have you considered eliminating the computed columns from the table and do all the calculations in your T-SQL select statement?
I haven't. are there any know serious drawbacks that i...
January 14, 2010 at 7:40 am
bitbucket-25253 (1/13/2010)
Pardon me for injecting this comment, but I believe your problem to some extent currently lies outside of being a T-SQL problem. Rather it lies in...
January 13, 2010 at 10:53 pm
stopitallready (1/12/2010)
You can place the original calculation for MonthsInService into the calculation for MyCol3. It would look like this:datediff(year,[DateEngaged],getdate()) * 2
Hope this helps,
Eli
thanks.
true this datediff(year,[DateEngaged],getdate()) is not reliable, what...
January 12, 2010 at 11:23 pm
thanks.
January 12, 2010 at 11:21 pm
I'm not sure if there is another method but may give a look to these links
http://msdn.microsoft.com/en-us/library/ms156421.aspx
http://www.sqldbatips.com/showarticle.asp?ID=62
http://kevinmarquette.blogspot.com/2007/04/migrating-sql-reporting-services-2005.html
July 7, 2009 at 12:41 am
i think you will have to open your reports project in BIDS, go to the project property pages and change the TargetServerUrl to your new server and re-deploy your reports....
July 7, 2009 at 12:20 am
Viewing 12 posts - 1 through 12 (of 12 total)