|
|
-
V Shah Commented 1 Months ago through Ask
Hi Alex,
IIF([Measures].[YOUR MEASURE NAME]=0,NULL,
COUNT([Measures].[YOUR MEASURE NAME]))
Thanks...
|
-
V Shah Commented 6 Months ago through Blogs
Hi Sherry,
The above information is very helpful. The question i have is "Is there a way to make the FROM field dynamic from SSRS itself? I know we can write custom code in SSIS but i was thinking if there is any way to do in SSRS itself.
Thanks...
|
-
V Shah Commented 8 Months ago through Blogs
Hi,
Statement 4 is incorrect because the maximum prefixes required is 2 in Create Table statement....
|
-
V Shah Commented 10 Months ago through Blogs
Hi jason,
When i change the rotatetransform from 270 to 45, it does not work. Any help would be appreciated
Thanks...
|
-
V Shah Commented 10 Months ago through Ask
Hi Jason, I found an answer. I added Union in my dataset query and now i am able to achieve the result.
Thanks for the reply....
|
-
V Shah Commented 10 Months ago through Ask
Please find the dataset query below:
Select AFK,ReportMonth,ReportYear,Convert(Decimal(5,2),AVG(Percentage)) as [Overall%]
into #temp
From B
Group By AFK,ReportMonth,ReportYear,Report_Month
order by Report_Month,ReportYear
Select B.Id,B.AFK,B.R...
|
-
V Shah Question Asked 10 Months ago through ASK
Hi Jason,
I have a question which i thought if you can answer. My question is: " I have created a report in SSRS with 4 line charts. From my dataset, i display Avg % in the Values Section, Year and Month in Category Group Section. I have a parameter which...
|
-
V Shah Liked 10 Months ago through What is New
Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"...
|
-
V Shah Posted 10 Months ago through Ask
Hi Jason,
I have a question which i thought if you can answer. My question is: " I have created a report in SSRS with 4 line charts. From my dataset, i display Avg % in the Values Section, Year and Month in Category Group Section. I have a parameter whi...
|
-
V Shah liked 11 Months ago through Interview Questions
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|