Formatting spoils when export to HTML Format

I have problem here. when I overlap two or more tables one on other and
export to PDF, it works fine. But when exported to HTML, it doesn't hold the
absolute position and renders tables sequentially.
Thanks,
JigneshThe same thing happens when you overlap charts. Charts render as images,
and are placed side-by-side in HTML rather than overlapping. I presume this
is because the HTML code required to overlap these items (charts, images,
tables), especially while maintaining appropriate transparency, would be
very complex, fragile and browser-specific.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jignesh Nakrani" <Jignesh Nakrani@.discussions.microsoft.com> wrote in
message news:068CD644-4EFF-40A6-B2D7-E86205EFC331@.microsoft.com...
>I have problem here. when I overlap two or more tables one on other and
> export to PDF, it works fine. But when exported to HTML, it doesn't hold
> the
> absolute position and renders tables sequentially.
> Thanks,
> Jignesh|||Jeff,
Thanks for the reply. Hope something comes up with the solution.
"Jeff A. Stucker" wrote:
> The same thing happens when you overlap charts. Charts render as images,
> and are placed side-by-side in HTML rather than overlapping. I presume this
> is because the HTML code required to overlap these items (charts, images,
> tables), especially while maintaining appropriate transparency, would be
> very complex, fragile and browser-specific.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jignesh Nakrani" <Jignesh Nakrani@.discussions.microsoft.com> wrote in
> message news:068CD644-4EFF-40A6-B2D7-E86205EFC331@.microsoft.com...
> >I have problem here. when I overlap two or more tables one on other and
> > export to PDF, it works fine. But when exported to HTML, it doesn't hold
> > the
> > absolute position and renders tables sequentially.
> >
> > Thanks,
> > Jignesh
>
>

Formatting Problems Cont. . . MS PLEASE ANSWER

This is a variation of a post from earlier. I have noticed significant
differences between the on screen vs printed/exported versions of every
report I have done. If a report looks good on the screen, things are so out
of place on the print out/pdf versions that I would never give them to a
customer, and vice versa. Is there something I am doing wrong? Here are
some specific problems:
1) One report has a subreport with nothing more that a single table, it is
displayed at the center at the bottom of one report. When the report is
printed, the subreport is moved so far to the right that it prints on a whole
new page.
2) In that same report, I cannot leave blank space at the bottom after the
subreport, regardless of whether I leave a some space in the report,
subreport, or both.
3) Blanks in the returned data from a stored procedure are ignored
sporadically in my report matrices.
4) All reports extend an inch or so the the right for no reason, moving
everying out of center, and disconnection horizontal lines from their right
hand borders.
If you are reading this post and have not yet chosen whether to use MS
Reporting Services or Crystal, unless someone has given an answer explaining
how to fix these issues, I strongly suggest you use crystal. It will be
cheaper to pay their licensing fees than to deal with the development time of
RS. As far as I can tell, the 2000 version is a miserable excuse for a
release. It should still be a beta.I suggest you open an incident with support. Or, if you have MSDN you can
use managed newsgroups (which is posting here using a registered alias so MS
knows to monitor the post). Just posting here is not guaranteed a response
from MS. It is peer supported. It very well could be that there are work
arounds to your issues. Or ways to design that there is not a problem. RS is
not Crystal and Crystal is not RS. Some things RS does very well, others not
so well. It is a output independent development environment and things can
vary based on the capabilities of the output.
Given how you did not even try to first find out whether there was a
solution before being insulting I'll let others jump in if they want to.
That is the problem with peer support. If you are nasty your peers won't
want to help. I sure don't (and if you hang here at all you will see I help
a whole lot of people).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Evan" <Evan@.discussions.microsoft.com> wrote in message
news:4F087219-EE00-46DA-AEA5-7A073C243FCE@.microsoft.com...
> This is a variation of a post from earlier. I have noticed significant
> differences between the on screen vs printed/exported versions of every
> report I have done. If a report looks good on the screen, things are so
out
> of place on the print out/pdf versions that I would never give them to a
> customer, and vice versa. Is there something I am doing wrong? Here are
> some specific problems:
> 1) One report has a subreport with nothing more that a single table, it is
> displayed at the center at the bottom of one report. When the report is
> printed, the subreport is moved so far to the right that it prints on a
whole
> new page.
> 2) In that same report, I cannot leave blank space at the bottom after
the
> subreport, regardless of whether I leave a some space in the report,
> subreport, or both.
> 3) Blanks in the returned data from a stored procedure are ignored
> sporadically in my report matrices.
> 4) All reports extend an inch or so the the right for no reason, moving
> everying out of center, and disconnection horizontal lines from their
right
> hand borders.
> If you are reading this post and have not yet chosen whether to use MS
> Reporting Services or Crystal, unless someone has given an answer
explaining
> how to fix these issues, I strongly suggest you use crystal. It will be
> cheaper to pay their licensing fees than to deal with the development time
of
> RS. As far as I can tell, the 2000 version is a miserable excuse for a
> release. It should still be a beta.

Formatting in Exported Reports

Hi. I have a matrix report that has very dynamic data attached to it,
specifically text that can vary in length from 5 characters to 100 or more.
I found the best solution for rendering was to keep the actual matrix row and
column widths to a minimum and let the matrix grow as required.
The problem I have run into is, when you export to Excel or PDF, it appears
the export uses these minimum column/row widths, and the report does not look
good and requires alot of formatting by hand (including another problem with
column headings I posted).
So my question is, is there any way to work around this or a best practices?
Any help would definitely be appreciated.Actually, this problem is only in Excel.
"comet61" wrote:
> Hi. I have a matrix report that has very dynamic data attached to it,
> specifically text that can vary in length from 5 characters to 100 or more.
> I found the best solution for rendering was to keep the actual matrix row and
> column widths to a minimum and let the matrix grow as required.
> The problem I have run into is, when you export to Excel or PDF, it appears
> the export uses these minimum column/row widths, and the report does not look
> good and requires alot of formatting by hand (including another problem with
> column headings I posted).
> So my question is, is there any way to work around this or a best practices?
> Any help would definitely be appreciated.sql

Formatting exported Reports in Excel

Hi All,
I'm using SQL Services 2000, and have a report with 3 tables. I export
this to Excel and use Subscriptions to email this report daily. I have
inserted page breaks after each table and so each table gets printed
on separate sheets in the Excel spreadsheet. All this is fine.
Now my problem are:
1) How could I format the sheets in such a way that they print neatly
on 1 page? Right now, they spill on to the next page when it is
printed.
2) Also, how could I name these sheets so that they represent the
report the user is viewing?
I tried many options in the table properties..but couldn't figure it
out!
Any help in these issues will be greatly appreciated!
Thanks in advance.
SSIf you have grouping in your report, when you export it goes into diferent
sheets depending on the pages, Dont give grouping if possible and no page
breaks then it prints in one page. you can check in the preview itself, that
it should show 1 of 1 page and asnwering your 2nd part, It is not possible to
do Sheet naming.
Amarnath, MCTS
"SMS" wrote:
> Hi All,
> I'm using SQL Services 2000, and have a report with 3 tables. I export
> this to Excel and use Subscriptions to email this report daily. I have
> inserted page breaks after each table and so each table gets printed
> on separate sheets in the Excel spreadsheet. All this is fine.
> Now my problem are:
> 1) How could I format the sheets in such a way that they print neatly
> on 1 page? Right now, they spill on to the next page when it is
> printed.
> 2) Also, how could I name these sheets so that they represent the
> report the user is viewing?
> I tried many options in the table properties..but couldn't figure it
> out!
> Any help in these issues will be greatly appreciated!
> Thanks in advance.
> SS
>|||On Mar 13, 12:18 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> If you have grouping in your report, when you export it goes into diferent
> sheets depending on the pages, Dont give grouping if possible and no page
> breaks then it prints in one page. you can check in the preview itself, that
> it should show 1 of 1 page and asnwering your 2nd part, It is not possible to
> do Sheet naming.
> Amarnath, MCTS
Amarnath,
I guess I'll need to remove the page breaks.
I'll try this. Thanks!

FormatNumber >> Excel export?

Hi all

I want my measures to be exported(Excel) as numbers instead of text.
When i simply use them as is it does this correct but as soon
as I as the following number formating it no longer exports
correctley.

=FormatNumber(Fields!Example.Value,2,True,True,True)

The same apllies to whe I set the formatting in the text box properties to N

Can some please tell me how I can acheive this result when exporting

Thanks in advance

G

Apply formatting using N in the Format property, then in the value textbox, apply an explicit cast of the value. E.g.

=CDbl(Fields!Example.Value)

Bizzare, but I've found this to work for me.

|||

Thanks Adam

I came accros the same thing today when i was casting
the values returned from custom code. I just hope the same
principal will aplly to currency.

In my case I had to figure to use N0
as format type to get 1,345,456

When using the cdbl() to do this you cant use FormatNumber(,,,)
that was my snag.

Thanks again for your time

G