Viewing 15 posts - 256 through 270 (of 279 total)
I have to do something in report using this table.
September 14, 2011 at 1:29 pm
Did you do simple select to test if there is data in Database??? or run the query you used to generate the report in managemnt studio and see if it...
September 6, 2011 at 1:32 pm
Thank you for all responses...I got it!!!
August 31, 2011 at 12:49 pm
I got query to get month order and year but not getting month names.
SELECT [year], [month]
FROM (
SELECT 2005 AS [year] UNION ALL
SELECT 2006 UNION ALL...
August 31, 2011 at 9:40 am
If there are 4-5 drop down list into my report then on selecting any values from drop down list whole report get refresh and slow down the process.I dont want...
August 26, 2011 at 1:11 pm
hey...I am not using any cascading paramters!!!
August 26, 2011 at 12:50 pm
I used other split function.But still not working.Is there any way to pass multiple values in dropdown..and get data for the selected values in paramter??
August 26, 2011 at 12:18 pm
I tried Remving Join () and pass multile values to paramter.It is still not working.
My Splitfunction :
ALTER FUNCTION [dbo].[SplitParameterValues]
(
@RowData NVARCHAR(MAX),
...
August 25, 2011 at 2:11 pm
I achieved this by adding an expression in report and also added group by Cname and Lofcoverage.I think it will be helpfull to others too.
My expression to achieve last...
August 9, 2011 at 9:43 am
My expression is :
= CASE WHEN Fields!PremuimMonth.Value >= DATEADD("mm",-3,NOW())THEN Fields!PremiumAmount.Value ELSE " " END As "AVERAGE AMOUNT"
August 8, 2011 at 4:06 pm
Case is not working in SSRS...It is just showing #error
August 8, 2011 at 3:56 pm
Getting errors while write the case statement...can we try same thing in switch??
August 8, 2011 at 2:46 pm
I want to get the past 12months date depending on the parameters chosen from report!!!!! I need to write an expression to get it...but getting errors:
=DATEADD("MM",DATEDIFF("MM",0,Parameters!RunMonth.Value)-11,0)
tried different ways...:(
August 4, 2011 at 3:03 pm
Thank you....I have another issue with datepart .I have @Year and @Month values comming from Parameter.
I need to write expression to get the 12month rolling date ,selected...
August 4, 2011 at 1:56 pm
I got it...I created another Dataset for Guid which is tied to Name and passed those values to GUID.:)
August 4, 2011 at 9:38 am
Viewing 15 posts - 256 through 270 (of 279 total)