Showing posts with label hlp. Show all posts
Showing posts with label hlp. Show all posts

Tuesday, March 27, 2012

HLP! PDF headings suddenly squished

I had a report that was working fine ... and now suddenly when it renders it
looks fine but if I export to pdf it squishes up the headings on the table.
All I can think of that changed is that I am showing or hiding table based on
the value of a field (this expression on the visibility for table =IIF(SUM(
Fields!Downtime.Value) > 0, False, True). AND I am showing or hiding a doc
map based on that same expression. This is very odd If the report werent so
complex I would just delete and re-create again. Any suggestions
appreciated!!This was fixed with SP2 which I now have
"MJT" wrote:
> I had a report that was working fine ... and now suddenly when it renders it
> looks fine but if I export to pdf it squishes up the headings on the table.
> All I can think of that changed is that I am showing or hiding table based on
> the value of a field (this expression on the visibility for table =IIF(SUM(
> Fields!Downtime.Value) > 0, False, True). AND I am showing or hiding a doc
> map based on that same expression. This is very odd If the report werent so
> complex I would just delete and re-create again. Any suggestions
> appreciated!!sql

Hlp Rendering Issue

RS2005
I have a legend that I designed which has 11 textboxes surrounded (enclosed)
within a rectangle that I use on reports for documentation purposes. It
renders perfectly fine in preview and exports to pdf fine but it is not
rendering on the server correctly and that is not acceptable to the users - I
dont know why the web version looks different. It is changing the size of
the textboxes (and they are all set to the same size and set to
shrink/grow=false). I can provide more information if needed.
The legend is to portray the meaning of colors used in the report so the
textboxes are similar to the following arrangement ( the texbox on the right
really just displays the color as the background). Any help/clues would be
appreciated!!
Color Legend
critical | color
warn | color
target | color
optimum | colorHi MJT.
I had a similar problem. I placed a pixel of space between each textbox and
the problem went away. It may have something to do with the way the HTML
rendering extension handles textboxes that are "too close together".
-Tim
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:8C1074B0-F42C-4FB7-8B52-6A6A3BD3FA72@.microsoft.com...
> RS2005
> I have a legend that I designed which has 11 textboxes surrounded
> (enclosed)
> within a rectangle that I use on reports for documentation purposes. It
> renders perfectly fine in preview and exports to pdf fine but it is not
> rendering on the server correctly and that is not acceptable to the
> users - I
> dont know why the web version looks different. It is changing the size of
> the textboxes (and they are all set to the same size and set to
> shrink/grow=false). I can provide more information if needed.
> The legend is to portray the meaning of colors used in the report so the
> textboxes are similar to the following arrangement ( the texbox on the
> right
> really just displays the color as the background). Any help/clues would
> be
> appreciated!!
> Color Legend
> critical | color
> warn | color
> target | color
> optimum | color
>|||thank you ... how do I put one pixel of space between them?
"Tim Dot NoSpam" wrote:
> Hi MJT.
> I had a similar problem. I placed a pixel of space between each textbox and
> the problem went away. It may have something to do with the way the HTML
> rendering extension handles textboxes that are "too close together".
> -Tim
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:8C1074B0-F42C-4FB7-8B52-6A6A3BD3FA72@.microsoft.com...
> > RS2005
> > I have a legend that I designed which has 11 textboxes surrounded
> > (enclosed)
> > within a rectangle that I use on reports for documentation purposes. It
> > renders perfectly fine in preview and exports to pdf fine but it is not
> > rendering on the server correctly and that is not acceptable to the
> > users - I
> > dont know why the web version looks different. It is changing the size of
> > the textboxes (and they are all set to the same size and set to
> > shrink/grow=false). I can provide more information if needed.
> > The legend is to portray the meaning of colors used in the report so the
> > textboxes are similar to the following arrangement ( the texbox on the
> > right
> > really just displays the color as the background). Any help/clues would
> > be
> > appreciated!!
> >
> > Color Legend
> > critical | color
> > warn | color
> > target | color
> > optimum | color
> >
>
>|||Tim,
I also need this to look like there is no space between the textboxes
"Tim Dot NoSpam" wrote:
> Hi MJT.
> I had a similar problem. I placed a pixel of space between each textbox and
> the problem went away. It may have something to do with the way the HTML
> rendering extension handles textboxes that are "too close together".
> -Tim
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:8C1074B0-F42C-4FB7-8B52-6A6A3BD3FA72@.microsoft.com...
> > RS2005
> > I have a legend that I designed which has 11 textboxes surrounded
> > (enclosed)
> > within a rectangle that I use on reports for documentation purposes. It
> > renders perfectly fine in preview and exports to pdf fine but it is not
> > rendering on the server correctly and that is not acceptable to the
> > users - I
> > dont know why the web version looks different. It is changing the size of
> > the textboxes (and they are all set to the same size and set to
> > shrink/grow=false). I can provide more information if needed.
> > The legend is to portray the meaning of colors used in the report so the
> > textboxes are similar to the following arrangement ( the texbox on the
> > right
> > really just displays the color as the background). Any help/clues would
> > be
> > appreciated!!
> >
> > Color Legend
> > critical | color
> > warn | color
> > target | color
> > optimum | color
> >
>
>|||Just move the textbox down (turn off snap to grid, click on the textbox and
hit your down arrow on the keyboard).
You will eventually find the "sweet spot" where the HTML rendering extension
won't act like it's putting a break between two texboxes that are suppposed
to be horizontally adjacent. Another note is that it WILL print adjacent.
Not sure why it's not rendered that way to screen.
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:5FE2C79B-FB9B-45AC-BD84-E8BBC4A94F52@.microsoft.com...
> Tim,
> I also need this to look like there is no space between the textboxes
> "Tim Dot NoSpam" wrote:
>> Hi MJT.
>> I had a similar problem. I placed a pixel of space between each textbox
>> and
>> the problem went away. It may have something to do with the way the HTML
>> rendering extension handles textboxes that are "too close together".
>> -Tim
>> "MJT" <MJT@.discussions.microsoft.com> wrote in message
>> news:8C1074B0-F42C-4FB7-8B52-6A6A3BD3FA72@.microsoft.com...
>> > RS2005
>> > I have a legend that I designed which has 11 textboxes surrounded
>> > (enclosed)
>> > within a rectangle that I use on reports for documentation purposes.
>> > It
>> > renders perfectly fine in preview and exports to pdf fine but it is not
>> > rendering on the server correctly and that is not acceptable to the
>> > users - I
>> > dont know why the web version looks different. It is changing the size
>> > of
>> > the textboxes (and they are all set to the same size and set to
>> > shrink/grow=false). I can provide more information if needed.
>> > The legend is to portray the meaning of colors used in the report so
>> > the
>> > textboxes are similar to the following arrangement ( the texbox on the
>> > right
>> > really just displays the color as the background). Any help/clues
>> > would
>> > be
>> > appreciated!!
>> >
>> > Color Legend
>> > critical | color
>> > warn | color
>> > target | color
>> > optimum | color
>> >
>>

hlp ... new with sub-report

I dont like to use subreports and havent ... but now I have a legit need for
one. I have a report which has to use 2 data sources but correlate them.
There will be a summary table followed by detail for the summarized resource
and then another table needs to follow that which is also contains separate
detail for the same summarized resource (but from a different data source).
So the report will need nested lists - an outer list for resource group and
an inner list for the 2 detail tables (from separate data sources) for the
resource group) - I hope that makes sense. Essentially Summary - detail -
detail .... Summary - detail - detail. Anyway ... I have a report which has
the Summary and the first detail ... I tried to add a subreport and it wont
render. I can run the subreport separately and it works ... I have the
parameter values supplied ... but all I see on the rendered report
(containing the subreport ) is error - Subreport could not be shown. No
clues as to what the problem is ... can someone help me 'deleted and recreated the same report over again that I was going to use for
the subreport ... and it seems to work ... I dont understand what would be
different ... its the same report just created all over again. Sometimes
this tool is so qwerky! I still dont have it repeating just yet though ...
so the jury is still out on whether it will work or not. To have the
subreport repeat every time a group changes ... I have to enclose it in a
rectangle with the other table that it is tied to? I was reading this from
Microsoft Reporting Services In Action which said that to tie it to a data
region ... put it in a rectangle with the region it is tied to. We'll see
how that works.
"MJT" wrote:
> I dont like to use subreports and havent ... but now I have a legit need for
> one. I have a report which has to use 2 data sources but correlate them.
> There will be a summary table followed by detail for the summarized resource
> and then another table needs to follow that which is also contains separate
> detail for the same summarized resource (but from a different data source).
> So the report will need nested lists - an outer list for resource group and
> an inner list for the 2 detail tables (from separate data sources) for the
> resource group) - I hope that makes sense. Essentially Summary - detail -
> detail .... Summary - detail - detail. Anyway ... I have a report which has
> the Summary and the first detail ... I tried to add a subreport and it wont
> render. I can run the subreport separately and it works ... I have the
> parameter values supplied ... but all I see on the rendered report
> (containing the subreport ) is error - Subreport could not be shown. No
> clues as to what the problem is ... can someone help me '