Custom Y Axis Labels

Greetings.
I have data that is bit data type. I'd like the Y axis to display "Yes" for
1, "No" for Zero or Negative one.
How can this be accomplished? Thanks in advance.
--
Tim Heuer
heuert at Comcast dot netThe closest you can get is to use a bar chart (and therefore the x-axis
becomes the y-axis) with two static series - one for "Yes" and one for "No".
The aggregate functions would look similar to this:
Yes: =Sum( iif(Fields!BitField.Value = 1, 1, 0))
No: =Sum( iif(Fields!BitField.Value <> 1, 1, 0))
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Heuer" <heuert at Comcast dot net> wrote in message
news:4BB4D6A1-693D-4292-986B-DB66E6C17669@.microsoft.com...
> Greetings.
> I have data that is bit data type. I'd like the Y axis to display "Yes"
for
> 1, "No" for Zero or Negative one.
> How can this be accomplished? Thanks in advance.
> --
> Tim Heuer
> heuert at Comcast dot net

Custom labels for DTS steps

Hi,
we have DTS packages which call other DTS packages, sometimes a few levels
deep.
In our error logs out DTS steps are labelled like
"DTSStep_DTSExecutePackageTask_4"
Is there a way to give our DTS steps custom labels so that it'll be easier
to work out which dts and which step has failed?
Server 2K
ThanksYes you can, and should do this...
Open your package and right click in the white space, go to Disconnected
Edit... There you can change the names of the Tasks and Steps... Be careful
tho,,, Change the Task name, then you have to go to the step which calls the
task, and change the taskname there to match... While there, you can also
change the Step name...
Save a copy before messing with this... It's easy to mess up..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Joe Gass" wrote:

> Hi,
> we have DTS packages which call other DTS packages, sometimes a few levels
> deep.
> In our error logs out DTS steps are labelled like
> "DTSStep_DTSExecutePackageTask_4"
> Is there a way to give our DTS steps custom labels so that it'll be easier
> to work out which dts and which step has failed?
> Server 2K
> Thanks
>
>|||well I had no idea that was there.
Many thanks for you help.
Cheers
Joe
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:324ED758-4CC5-4DB1-A01A-D041548013CD@.microsoft.com...
> Yes you can, and should do this...
> Open your package and right click in the white space, go to Disconnected
> Edit... There you can change the names of the Tasks and Steps... Be
> careful
> tho,,, Change the Task name, then you have to go to the step which calls
> the
> task, and change the taskname there to match... While there, you can also
> change the Step name...
> Save a copy before messing with this... It's easy to mess up..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Joe Gass" wrote:
>|||Use "Disconnected Edit" and name your steps...