Viewing 14 posts - 16 through 29 (of 29 total)
Thanks for the replies.
As usual, the specs have changed and now I no longer have to report those machines without goals.
Bill
September 16, 2010 at 10:38 am
This is something I found some time ago...
function SafeDivide(a, b, c)
if b = 0 then
return c
else
return a/b
end if
end function
HTH
June 4, 2010 at 6:40 am
Yes.
I chose to use a table for these values.
After creating the row groups, I added a column group on the 'Period' value. Under group properties, I just...
March 5, 2010 at 12:05 pm
Found a solution...I added a filter to a 'Period' grouping.
March 5, 2010 at 9:00 am
I would just insert a row above your table headers. You can merge the cells, and by default they will grow as needed ('CanGrow' property) to accommodate any text...
March 5, 2010 at 8:46 am
This should work:
Where field Between 0
And
(Case
When parameter = 0 Then 1
Else 2
End)
February 24, 2010 at 9:35 am
This is a link to an article that desribes a method for custom grouping and subtotaling.
http://www.simple-talk.com/sql/reporting-services/reporting-at-the-top/
It may be flexible enough for your requirements...
Bill
September 22, 2009 at 11:39 am
That feature is new in 2008...
One thing you can try...Check the 'Logarithmic scale' option on the Y Axis. I made a test chart, and it does display the lines...
Bill
January 29, 2009 at 11:47 am
I should have asked which version you were using...Sorry...
Those instructions are for 2008. I'm not certain if that exists in 2005. I'll check.
January 29, 2009 at 11:32 am
You should be able to enable scale breaks.
Go to your Axis properties, and choose 'Enable scale breaks' under Axis options.
HTH,
Bill
January 29, 2009 at 11:06 am
If you right-click on the project name (in your developer window), and choose properties, you will get a dialog box that will allow you to fill in 'TargetServerURL'. It...
August 27, 2008 at 12:21 pm
I link to RS 2005 reports from within LBI at our company.
Instead of referencing the RDL, use http. This is a sample link for your URL field:
August 27, 2008 at 9:35 am
Check this out:
http://www.simple-talk.com/sql/sql-server-2005/reporting-at-the-top/
This is a link to a similar report. It was sent in the SQL Server Central daily email on 11/21....
November 28, 2007 at 12:16 pm
Viewing 14 posts - 16 through 29 (of 29 total)