Charts no longer showing on report?

Hi, I have 8 charts on a report that no longer show up on the report.

the datasets they are based on still produce data when queried.

All I see is white space plus the textbox titles?

The charts are there in layout view and still correctly reference the right datasets and fields.

figured it out, one field was 1 char longer than I thought rtrim sorted the problem

Chart actions produce blue border

When I place a chart in a table group header and specify a hyperlink action, the chart becomes adorned with a blue border. When I take the chart out of the table, the border disappears. The same problem occurs in a matrix.
Is this by design (is this somehow a hyperlink blue)? If so, how do I turn this off.
MaxUnfortunately browsers draw this blue border even if border style is set
None.
As workaround you may try to place rectangle into table or matrix cell, and
then put a chart into this rectangle.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Max" <Max@.discussions.microsoft.com> wrote in message
news:DDCBA9DF-DCBB-4F4A-843C-C128DFABA5F3@.microsoft.com...
> When I place a chart in a table group header and specify a hyperlink
> action, the chart becomes adorned with a blue border. When I take the
> chart out of the table, the border disappears. The same problem occurs in
> a matrix.
> Is this by design (is this somehow a hyperlink blue)? If so, how do I
> turn this off.
> Max
>|||Thanks Lev. This worked.
Good software finds bugs in other software!
"Lev Semenets [MSFT]" wrote:
> Unfortunately browsers draw this blue border even if border style is set
> None.
> As workaround you may try to place rectangle into table or matrix cell, and
> then put a chart into this rectangle.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Max" <Max@.discussions.microsoft.com> wrote in message
> news:DDCBA9DF-DCBB-4F4A-843C-C128DFABA5F3@.microsoft.com...
> > When I place a chart in a table group header and specify a hyperlink
> > action, the chart becomes adorned with a blue border. When I take the
> > chart out of the table, the border disappears. The same problem occurs in
> > a matrix.
> >
> > Is this by design (is this somehow a hyperlink blue)? If so, how do I
> > turn this off.
> >
> > Max
> >
>
>

changing time format

I have a datetime field that looks like this:
2004-04-15 09:31:37.000
I used the convert function (convert(char(8),executiontime,108)) to produce this:
09:31:37
How do I make the result return:
093137
Thanks
You could use REPLACE()
select CONVERT(char(8),REPLACE(convert(char(8),executiont ime,108), ':', =
'')) from foo
--=20
Keith
"Chambers" <anonymous@.discussions.microsoft.com> wrote in message =
news:4041CE38-C011-4CB7-BBBC-C651870B1C37@.microsoft.com...
>=20
>=20
> I have a datetime field that looks like this:
>=20
> 2004-04-15 09:31:37.000
>=20
> I used the convert function (convert(char(8),executiontime,108)) to =
produce this:
>=20
> 09:31:37
>=20
> How do I make the result return:
>=20
> 093137
>=20
> Thanks

changing time format

I have a datetime field that looks like this:
2004-04-15 09:31:37.000
I used the convert function (convert(char(8),executiontime,108)) to produce
this:
09:31:37
How do I make the result return:
093137
ThanksYou could use REPLACE()
select CONVERT(char(8),REPLACE(convert(char(8),
executiontime,108), ':', =
'')) from foo
--=20
Keith
"Chambers" <anonymous@.discussions.microsoft.com> wrote in message =
news:4041CE38-C011-4CB7-BBBC-C651870B1C37@.microsoft.com...
>=20
>=20
> I have a datetime field that looks like this:
>=20
> 2004-04-15 09:31:37.000
>=20
> I used the convert function (convert(char(8),executiontime,108)) to =
produce this:
>=20
> 09:31:37
>=20
> How do I make the result return:
>=20
> 093137
>=20
> Thanks