Hi Mark,

This will do the trick for you:

If Not Exists (Select ....)

Begin

RAISERROR ('Aborting report because no data was found.', 16, 1)

End

Else

Begin

Select ....

End

I found this in another post some time ago,...

I would use the sub-report method.

Use an 'outer' table or matrix so that you can control the page breaks by customer. Then embed the detail sub-report in...

Thanks for the replies.

As usual, the specs have changed and now I no longer have to report those machines without goals.

Bill

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

Amen!!

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...

Found a solution...I added a filter to a 'Period' grouping.

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...

This should work:

Where field Between 0

And

(Case

When parameter = 0 Then 1

Else 2

End)

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

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

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.

You should be able to enable scale breaks.

Go to your Axis properties, and choose 'Enable scale breaks' under Axis options.

HTH,

Bill

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...

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: