Viewing 15 posts - 31 through 45 (of 99 total)
In SSRS 2008 R2 (hopefully the same for you):
Go to the Design View of the Chart. Right click on the Y-Axis and select Veritcal Axis Properties. In the...
August 22, 2011 at 11:34 am
This query should return the data in the format you are looking for and then you can walk through the report wizard to get it set up with drilldown enabled:
SELECT...
August 18, 2011 at 1:34 pm
That's good, that is what I would expect and for the most part what you want. Now what does this return?
=IIF(Fields!CreditAllowance.Value > 0, Fields!Sales.Value, 0)
August 16, 2011 at 1:15 pm
Just to take a step back, what do you get when you just try:
=SUM(Fields!Sales.Value, "DataSet1")
August 15, 2011 at 3:55 pm
Sorry, I read this too quickly the first time. I think this is what you are trying to accomplish:
August 15, 2011 at 3:45 pm
And the other fields in the expression Percent and Sales (I just guessed those were the field names), are those valid names of your fields. Is anything underlined in...
August 15, 2011 at 2:37 pm
The expression should be fine to use in the details, but you need to replace DataSet1 with the name of your dataset. If you do not know it, while...
August 15, 2011 at 2:23 pm
Is this a detail line or a group line? I've only tested this partially, but think it should work... In your TotalSales column use the expression:
If it's a...
August 15, 2011 at 1:49 pm
Do you know if Kerberos is enabled? Typically I have seen this error when it is not and trying to use the SA account would usually confirm this...
Assuming you...
August 15, 2011 at 1:36 pm
The AVG function works exactly as you described which is a bit annoying to say the least. Typically, if you want the real average you have to write the...
August 15, 2011 at 1:18 pm
The two groups you mentioned could have an impact. Can you go into the local users and groups console and verify what users have been added to the local...
August 15, 2011 at 11:12 am
You could try adding a page header and moving the text values to the page header, but it can be difficult to line everything up then
August 15, 2011 at 10:51 am
Yes, I am suggesting that one way of accomplishing your task is to build the template in the OLE DB source (there could certainly be other ways). What makes...
August 15, 2011 at 6:17 am
Can you convert the date into the correct format in the stored procedure to return the correct data?:
CONVERT(nvarchar(10), GETDATE(), 101) -for US
CONVERT(nvarchar(10), GETDATE(), 103) -for British
Additional info on...
August 10, 2011 at 10:08 am
I still think there is a good chance it will be easier to get the customer name as a column in the main query to put in the main report....
August 10, 2011 at 10:00 am
Viewing 15 posts - 31 through 45 (of 99 total)