Viewing 15 posts - 16 through 30 (of 248 total)
Ninja's_RGR'us (11/29/2010)
How are you trying to access the reports in ASP .NET? (Direct URL or reportviewer control)?What is the authentication mode of the users on the site?
I want to...
November 29, 2010 at 5:58 am
I need the same thing i.e. Granting the Access to Reports URL (deployed reports - not all but few pages) to a non window non domain user..
Any idea if you...
November 28, 2010 at 11:39 pm
malavika.ramanathan (11/26/2010)
Right click on y-axis. ---> vertical axis properties ----> Number
here you change number type as percentage and set decimal places to 0.
this gives you % values...
November 26, 2010 at 2:32 am
Sorry Guys, I have accidently posted it in the wrong forum.
Please do not reply here but incase you have something to suggest please add your replies to:
http://www.sqlservercentral.com/Forums/Topic1026653-1633-1.aspx
November 26, 2010 at 12:31 am
Lowell (11/19/2010)
depending on the data, for example if it was always N{quote}{three chars}{quote}{Comma}you might just use STUFF and a tally table to for to the length of the variable
Not...
November 19, 2010 at 9:09 am
after debugging it further, I found out that the eal query its building at run time for the problematic casestatement is as below:
WHERE ...
November 19, 2010 at 5:11 am
Reo (11/18/2010)
check http://munishbansal.wordpress.com/2008/12/29/passing-multi-value-parameter-in-stored-procedure-ssrs-report/
Not of much help...I am using a direct query (not SP) so difficult to use in my condition..
Can someone suggest if I have a Case Statement in WHERE...
November 19, 2010 at 3:35 am
nigelrivett (11/18/2010)
so '1,4,2,6'
x in ('1,4,2,6') where x is an integer will give an error as it tries to convert '1,4,2,6' to an...
November 18, 2010 at 6:16 am
Kingston Dhasian (11/17/2010)
But i think this is what you want.
DECLARE @status Varchar (10)
SELECT @status='ALL'
--following is the part of...
November 17, 2010 at 2:45 am
Sachin Nandanwar (11/17/2010)
So what should be the o/p when variable value is ALL?
it needs to be both the values either 1 or 0 (means all the rows either ISSUED or...
November 17, 2010 at 2:37 am
stewartc-708166 (10/25/2010)
This will require some custome code in the textboxes, e.g.
=iif(ISNULL( firstColumn .value ) == true, secondColumn.value, firstColumn .value)
Can you explain a little more about this or suggest any...
October 26, 2010 at 12:22 am
Vishal Singh (10/25/2010)
stewartc-708166 (10/25/2010)
Please refer:SQL2008:http://msdn.microsoft.com/en-us/library/ms157454.aspx
SQL2008 R2: http://msdn.microsoft.com/en-us/library/dd207042.aspx
Thanks. I am currently going through this. I will let you know if this helps me.
Thanks stewartc-708166 ,
This work like a charm.
Can we...
October 25, 2010 at 6:36 am
stewartc-708166 (10/25/2010)
Please refer:SQL2008:http://msdn.microsoft.com/en-us/library/ms157454.aspx
SQL2008 R2: http://msdn.microsoft.com/en-us/library/dd207042.aspx
Thanks. I am currently going through this. I will let you know if this helps me.
October 25, 2010 at 5:09 am
Vishal Singh (9/28/2010)
Raunak Jhawar (9/28/2010)
Vishal Singh (9/28/2010)
We have a daily report in our environment which we generate and email through SSRS. Now recently, we added few more environment and they...
September 28, 2010 at 6:30 am
Raunak Jhawar (9/28/2010)
Vishal Singh (9/28/2010)
We have a daily report in our environment which we generate and email through SSRS. Now recently, we added few more environment and they are not...
September 28, 2010 at 6:28 am
Viewing 15 posts - 16 through 30 (of 248 total)