Vertical text adjacent to report data

[deswar]

Hi,

Is there a way to print a vertical text adjecent to report data. Report should look like this.

column1 column2 column3 column4
data0 data1 data2 data3
data4 data5 data6 data7
Vertical Text here data8 data9 data8 data6
data1 data2 data1 data3
data1 data2 data1 data3

Can some one please help me in this?

If this text formating is not clear, please look at the same quest raised in another forum:
http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6500



Thanks in advance.

[jawadhashmi]

attach your sample report with database or xml data.

With few details that the what would be in thevertical text ? would it remain same for all the horiz rows would it grow or does they have any relation ?

You can create 2 separate reports and place them side by side on the detail or any other section. The left side report will show the vertical text where as the right side report will show the horiz text.

Now you have to use some programming skills to align the text and relevant text to be placed side by side.

[deswar]

Vertical text will look like this:
23-05-2009 32AR W40246 1 0001-0002 B66595 9.9.99 85-85

Length of the vertical text will remain same and there is no relation to the rows.

Vertical text should be spaned across all the rows of the report data. It should not be repeated for each row.

I have attached the sample application.

Thanks.

[deswar]

Exact report format is attached as an image.

[jawadhashmi]

Have a look on the attached updated report file along with the generated report as PDF.

Now you have the idea and can modify it according to your further requirements.

[deswar]

That’s brilliant, it really worked out… Thanks a lot.

[deswar]

Hi jawadhashmi,

Is there a way to move the vertical text little bit above the footer line? I tried to do so in design time and at run time. But not succeeded!!

[jawadhashmi]

Increase the header size or the section where the vertical text is placed. This will print the vertical text before footer.

[deswar]

I tried increasing it before and it was not working. Please find the report attached.

[jawadhashmi]

Is the situation arise when there is no data or less data to be displayed in detail ?

You have to do a trick here. Create a detail/group section above it and make its size to the size of the header and do it underlay.

Now the sections comming under it will come over it and the footer will start after it. This will atleast consume the space of detail section.

Here you have to do some tricks.

I am unable to work with your attached report.

[deswar]

No. of records in the report is always 10. Even if less than 10, I will add blank records. I have attached complete soution once again.

If I add any new section like Group/Detail and increase its height, its creating a gap between each record which is not allowed.

[jawadhashmi]

Have a look on the updated report attached with the post. I think this is now very close to your requirments.

[deswar]

yes, it is working. Thanks a lot.