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 issues for excel

hi,

I have a column of numbers which export fine to excel when i use the formatting '$0'.

If any of the values in the column = 0 i dont want them to show so i added this line to the value =iif(Fields!Budget.Value = 0, "", Fields!Budget.Value). This works fine except when i export to excel it now doesnt read them as values and you have to convert all the cells individually. I guess this is becuase i have substituted the string "" when the data = 0 and excel does the formatting for the whole column not each cell individually. What should i do so it exports to excel correctly? Is there another way to show nothing in a cell and it still registers as a number?

geoff

WHat about Nothing rather than "" ?

=iif(Fields!Budget.Value = 0, Nothing, Fields!Budget.Value).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

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!

Formatting C# code, specifically curlys {}

1. For some reason, my Debug menu had many options missing. I found some
help that said go to Tools/Import & Export Settings and Choose Reset All. I
did it, and chose C# Developer and now my Debug menu is fully restored.
However, I did lose all of my other customzied settings, i.e. fonts, colors,
etc...
2. In my environment, before I did #1 above, when I keyed in two curly's
like this: {}, it would automatically move the ending curly to a new line
underneath. So, example:
I type this: {}
I get this after pressing enter:
{
}
For some reason, this no longer works.
3. I've changed settings in: Tools/Options/Text Editor/C#/Formatting.
Specifically the 'Automatically format completed block on }'. I'm not sure
if this is even the correct setting, but I tried anyway. I've also tried
the other settings in that screen and nothing happens.
Can someone advise if they've seen or fixed this problem? It worked for me
this morning, I reset my environment to get my Debug menu, and now it doesnt
work anymore.
Kind regards,
JrWhoops. Wrong group. Sorry.
"JrMcG" <JrM@.noemail.noemail> wrote in message
news:%23KRJGv$qGHA.4508@.TK2MSFTNGP04.phx.gbl...
> 1. For some reason, my Debug menu had many options missing. I found some
> help that said go to Tools/Import & Export Settings and Choose Reset All.
> I did it, and chose C# Developer and now my Debug menu is fully restored.
> However, I did lose all of my other customzied settings, i.e. fonts,
> colors, etc...
> 2. In my environment, before I did #1 above, when I keyed in two curly's
> like this: {}, it would automatically move the ending curly to a new line
> underneath. So, example:
> I type this: {}
> I get this after pressing enter:
> {
> }
> For some reason, this no longer works.
> 3. I've changed settings in: Tools/Options/Text Editor/C#/Formatting.
> Specifically the 'Automatically format completed block on }'. I'm not
> sure if this is even the correct setting, but I tried anyway. I've also
> tried the other settings in that screen and nothing happens.
> Can someone advise if they've seen or fixed this problem? It worked for
> me this morning, I reset my environment to get my Debug menu, and now it
> doesnt work anymore.
> Kind regards,
> Jr
>

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

format excel output

In my report I have used the "jump to url" for the report output but when I export this to excel I get a column with the correct data and also the url.

Is there anyway of exporting the data without the url?

I want my users to be able to view the report and click on the column the want to URL jump to but also be able to export just the raw data without the URL?

No. For this I've had to create 2 versions of my reports, 1 with formatting, layout, links etc. and the other just plain data. I then add a link to the formatted version (attached to an excel icon) and just pass through the current parameter values i.e. this is done by constructing the URL using an expression and additionally appending rs:Format=EXCEL to the end of it.

|||Is there any way of having a column that shows up on the report be can't be exported to excel?|||

I thought I already answered that?

The answer is No. You cannot detect within the report which renderer was used.