Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Rotate table?

Author  Topic 

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-12-19 : 09:54:49
Is it possible to rotate the table like a 90 degree? We are planning to purchase a DYMO LabeWriter to do some labeling by using Reporting Services. Not sure if I need to set my report so the text rotate 90 degree from it's current position or will it automatically do it from the LabelWriter itself.

jhermiz

3564 Posts

Posted - 2005-12-19 : 10:58:54
The labelwriter will not do it on its own, you will have to perform some manually adjusting of text direction and page width / height.




Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-12-19 : 12:46:13
See the thing is I'm not sure how to set it so that it will be rotate 90 degree. Any ideas?

For example a text like:

---------
----------
-----------
------------

Needs to rotate to look like:

||||
||||
||||
||||

So the text is turn right about 90 degrees to go on the LabelWriter.
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-12-19 : 13:22:19
There should be a text direction property, i see your point you have:

hello
goodbye

in a rs table and you want it to read

oe
ly
lb
ed
ho
o
g

right ?



Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-12-19 : 13:43:57
There's a text direction and writing mode in the advance section of the textbox properties. However I can only set to LTR(left to right) or RTL(right to left) and mode LR-TB(Left right and top bottom) and TB-RL(top bottom and right to left). These does not produce the result i'm looking for which is to rotate the text 90 degree right.
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-12-19 : 14:02:01
Right but there is no option for that, the printer or whatever your using should be able to rotate the text.
I dont know if that one you mentioned in particular will do that for you. The only thing I can think of is creating a landscape type report...but that wont fit your needs.

Sorry I dont have a better answer.


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-12-20 : 16:00:56
I found a SDK from their website that lets me create a program in VB and then print out the results. Yes, I talked to one of the salesrep and he said that you can set it when you go print. So if the report doesn't work, then I still have the SDK package to work with.

Thanks.
Go to Top of Page
   

- Advertisement -