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
Showing posts with label specifically. Show all posts
Showing posts with label specifically. Show all posts
Wednesday, March 21, 2012
Formatting in Exported Reports
Monday, March 19, 2012
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
>
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
>
Subscribe to:
Posts (Atom)