nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How would I turn a cross tab column header sideways?

mkdz

Is there any way to get the crosstab column headers to go up vertically? If so, how? Thanks!

Find more posts tagged with

Comments

Yaytay

There are a couple of options:<ul class='bbc'><li>There is a BIRT plugin for rotated text. 
<a data-ipb='nomediaparse' href='http://code.google.com/a/eclipselabs.org/p/birt-controls-lib/'>http://code.google.com/a/eclipselabs.org/p/birt-controls-lib/</a> 
This works for printed output, but it operates by rendering the text to an image, so it's not perfect for spreadsheet output.</li><li>The SpudSoft Excel emitters (in version 4.3 or on BitBucket for versions after 2.5.2) have an option for rotating text that works with Excel output - I don't whether other emitters (for Excel or other formats) have similar functionality. 
<a data-ipb='nomediaparse' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/downloads'>https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/downloads</a></li></ul>If you are outputting to Excel the SpudSoft approach is much better than the BIRT rotated text plugin, but if you are outputting to PDF the plugin approach is fine. Jim

mkdz

Well, I'm looking to output to web, PDF, and Excel.

Yaytay

For the best output then I'd try to have both approaches used - which you can do by adding two items to the report and setting them to only display on the appropriate output formats.

mkdz

So I got the BIRT plugin for rotated text working. The text shows up as rotated in an image on the PDF output. However, the resolution is a little lacking. It looks like it is being output as a PNG. Is there a way to up the resolution or change the plugin so it's outputted as a SVG? Thanks!

Yaytay

I'm not sure, but I think either of these two will work:<ul class='bbc'><li>Set EngineConstants.APPCONTEXT_CHART_RESOLUTION in the AppContext. 
I set this to 300 by default in my report server.</li><li>Set IRenderOption.CHART_DPI in the RenderOption.</li></ul>I don't use that plugin, but I've just had a rummage through the source and I think they'll do it. Jim

mkdz

So I would have to set these in my Java code I'm using to generate the report?

Yaytay

If you want consistent results across all of your reports, then yes, but I think it will work if you just set the values in the beforeFactory script of the report too.The only issue with that is that you'll need to know the values for the constants:<ul class='bbc'><li>public final static String APPCONTEXT_CHART_RESOLUTION = "CHART_RESOLUTION";</li><li>public static final String CHART_DPI = "ChartDpi";</li></ul>Jim

mkdz

Isn't the script part of the report JS and not Java?

Yaytay

Yes (well, you could make Java if you wanted to, but it's not worth it for this).All I'm saying is that you can use a JS beforeFactory script to set up the values which will give you a very quick way to check whether they work or not.

mkdz

Oh, I get it now. You're saying to turn this Java code:<ul class='bbc'><li>public final static String APPCONTEXT_CHART_RESOLUTION = "CHART_RESOLUTION";</li></ul>into JS to use in the Script section of the report

Yaytay

Not quite. The beforeFactory script would have to be:<pre class="_prettyXprint"> reportContext.getAppContext().put("CHART_RESOLUTION",300);</pre>Except it might not get away with being that simple because the appContext might be null - but for a first test try that as it is.