Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Data is cutting in export to PDF
bokya
Hi All,
I have a serious doubt, when i do export to pdf and save pdf then data in the column is getting cut across column line. For example my data in the column is 'EMQLMZ129067553736436433236', this data is displaying properly on Report viewer in single line but problem is in exporting to PDF. I am using " 2.5.1.v20090710-7c957AFOKfquKtWRHVnZG1" this version.
Thanks & Regards
Bokya
Find more posts tagged with
Comments
bokya
Hi All,
Please reply to my post
mwilliams
And you would like it to wrap in PDF output? Or is there enough space for it to list all the way on one line, but it's just getting cut off? Let me know.
bokya
Thanks for replying BIRt Guru,
Yes i want to wrap the text in to PDF output without cutting the data acroos columns. There is no way to wrap wrap in to single line. because if we try to wrap the the text like "7c957AFOKfquKtWRHVnZG1" in to single line then other Neighboring columns are affecting due to this and getting same problem with them also. So its better to take it in next line. But i dont know in export to PDF for dynamic text which is very big without having any space how to take it in next line. Becaus esame text is adjusting on GUI in single line but problem is with Export to pdf only.
Thanks & Regards
Bokya
mwilliams
The PDF won't adjust like the GUI because of the fixed size constraint. To get a long, unbroken string to break, you'll have to add break characters of your own, either in a computed column or using a dynamic text box to write the script to break the long text up. Once you've broken the long text up, it should wrap to multiple lines within your PDF. Let me know if you have questions.
bokya
Hi BIRT Guru,
Can you please tell me where and how to break the string/integer? is there any script i need to write? Please provide me one sample example. and where to put this script and how to apply it to data?
Thanks,
Bokya
mwilliams
You could do something like this, in a computed column, replacing "data1" with your column's name:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
temp = "";
i=0;
while (i<row["data1"].length){
if (row["data1"].length - 10 < i){
temp = temp + row["data1"].substring(i,row["data1"].length);
}
else{
temp = temp + row["data1"].substring(i,i+10) + "\n";
}
i += 10;
}
temp;
</pre>
bokya
Hi BIRT GURU,
Thanks for valuable reply. Can you please tell me how to apply same script for whole report. I mean to say if my report has 50 columns then i cant write same script every where. Is there any place where i can write same script for all the columns.
mwilliams
You could do a script in your beforeFactory method, stepping through your data elements, changing their expression. The easiest way would be to name your data elements, element1, element2, element2, etc., in the property editor. Then, you can easily access them by name, in your script.
CanuckDuck
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="108189" data-time="1344267069" data-date="06 August 2012 - 08:31 AM"><p>
You could do a script in your beforeFactory method, stepping through your data elements, changing their expression. The easiest way would be to name your data elements, element1, element2, element2, etc., in the property editor. Then, you can easily access them by name, in your script.<br /></p></blockquote>
<br />
Is there a way to apply this to QBR Reports as well?
mwilliams
I'm not familiar with QBR reports. I'm assuming you're talking about the IBM product rather than a Quarterly Business Report made with any old version of BIRT. Are there any scripting areas available? Do you have access to modify the actual .rptdesign that's created?
CanuckDuck
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="115062" data-time="1363267581" data-date="14 March 2013 - 06:26 AM"><p>
I'm not familiar with QBR reports. I'm assuming you're talking about the IBM product rather than a Quarterly Business Report made with any old version of BIRT. Are there any scripting areas available? Do you have access to modify the actual .rptdesign that's created?<br /></p></blockquote>
<br />
Sorry should have been more clear. This is for Maximo quick reports. They are ad hoc reports and unfortunately I don't have access to the rptdesign file until after the reports are saved. Ideally I would like to script something as you say before the report is generated. <br />
<br />
I guess this is more of a Maximo Configuration issue than a BIRT one.
mwilliams
Do you have to use Maximo quick reports to create the reports? Have you tried creating them with a separate install of the designer and then loading them to where you need them for use within Maximo?
CanuckDuck
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="115113" data-time="1363372846" data-date="15 March 2013 - 11:40 AM"><p>
Do you have to use Maximo quick reports to create the reports? Have you tried creating them with a separate install of the designer and then loading them to where you need them for use within Maximo?<br /></p></blockquote>
<br />
Our users have the ability to use these quick reports and there doesn't seem to be a way to customize the date display (unless saved and updated). All of our other customized reports are fine. It's just these on-the-fly reports. thanks.
mwilliams
Interesting that they wouldn't have implemented a way for you to format the date. You're right, this definitely isn't a BIRT issue. Have you asked over on their support forums?