sql report
1. Is there a way to change the alignment of the text so that it reads top to bottom, then left to right? The tb-rl option isn't what i'm looking for, I need it to display like this:
<table><tr><td>D<br>I<br>S<br>P<br>L<br>A<br>Y</td><td>T<br>H<br>I<br>S</td><td>W<br>A<br>Y</td></tr></table>
sorry if the code didn't come up right, but need it like this:
D T W
I H A
S I Y
P S
L
A
Y
2. I need help with setting up a matrix. The rows are supposed to list locations and the columns list items, and not items are available at all locations, and the database only stores items that are available for a location (so if location 1 has item A and item B and location 2 has item 1, there are 3 entries). The data field states if the item is available at a location, and if it is not, a number indicating the reason it wasn't available, or a default reason if there is no database record. The report renders correctly, but it gives a warning saying the data uses a field outside the scope, which doesn't allow the report to be exported to pdf; right now it's possible to export to Excel then convert to pdf, but need a way that would go straight to pdf.

