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; } } }

To display large string/text in table detail row for PDF

easothomas

Hi, 
 
BIRT version - 3.7.1.v20110905 on Windows XP 
 
I am trying to show a large sql query generated by one of the tools in my PDF report. The db used here is IBM DB2. 
 
The table schema is something like this 
 
CREATE TABLE MOSTEXPENSIVESQL 
( 
MOST_EXP_SQL_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), 
MOST_EXP_SQL_STRING VARCHAR(10000) NOT NULL, 
MOST_EXP_SQL_MD5HASH VARCHAR(32) NOT NULL 
); 
 
As you can see the sql string is given a length of 10,000 chars. 
 
A Sample entry in the db would look like this. 
 
MOST_EXP_SQL_STRING - SELECT LOCATIONGROUP.LAST_USED_DT "P.PA.3515", LOCATIONGROUP.LAST_VERIFIED_DT "P.PA.3516", LOCATIONGROUP.CONT_ID "P.PA.2948", LOCATIONGROUP.PREFERRED_IND "P.PA.2960", LOCATIONGROUP.START_DT "P.PA.2962", ADDRESSGROUP.ADDRESS_ID "P.PA.42", ADDRESSGROUP.CARE_OF_DESC "P.PA.44", ADDRESSGROUP.LOCATION_GROUP_ID "P.PA.48", LOCATIONGROUP.EFFECT_END_MMDD "P.PA.2949", LOCATIONGROUP.EFFECT_START_MMDD "P.PA.2951", LOCATIONGROUP.EFFECT_END_TM "P.PA.2950", LOCATIONGROUP.EFFECT_START_TM "P.PA.2952", LOCATIONGROUP.END_DT "P.PA.2953", LOCATIONGROUP.SOLICIT_IND "P.PA.2961", LOCATIONGROUP.LAST_UPDATE_DT "P.PA.2954", LOCATIONGROUP.LAST_UPDATE_TX_ID "P.PA.2955", LOCATIONGROUP.LAST_UPDATE_USER "P.PA.2956", LOCATIONGROUP.SOURCE_IDENT_TP_CD "P.PA.3517", LOCATIONGROUP.UNDEL_REASON_TP_CD "P.PA.2963", ADDRESSGROUP.ADDR_USAGE_TP_CD "P.PA.43", ADDRESSGROUP.LAST_UPDATE_DT "P.PA.45", ADDRESSGROUP.LAST_UPDATE_TX_ID "P.PA.46", ADDRESSGROUP.LAST_UPDATE_USER "P.PA.47", ADDRESS.POSTAL_BARCODE "P.PA.AD.34", ADDRESS.LAST_UPDATE_USER "P.PA.AD.30", ADDRESS.LAST_UPDATE_TX_ID "P.PA.AD.29", ADDRESS.LAST_UPDATE_DT "P.PA.AD.28", ADDRESS.ADDR_LINE_ONE "P.PA.AD.21", ADDRESS.ADDR_LINE_THREE "P.PA.AD.22", ADDRESS.ADDR_LINE_TWO "P.PA.AD.23", ADDRESS.CITY_NAME "P.PA.AD.25", ADDRESS.COUNTY_CODE "P.PA.AD.27", ADDRESS.LATITUDE_DEGREES "P.PA.AD.31", ADDRESS.LONGITUDE_DEGREES "P.PA.AD.32", ADDRESS.RESIDENCE_NUM "P.PA.AD.40", ADDRESS.ADDR_STANDARD_IND "P.PA.AD.24", ADDRESS.OVERRIDE_IND "P.PA.AD.33", ADDRESS.POSTAL_CODE "P.PA.AD.35", ADDRESS.ADDRESS_ID "P.PA.AD.20", ADDRESS.BOX_ID "P.PA.AD.5089", ADDRESS.BUILDING_NAME "P.PA.AD.5082", ADDRESS.STREET_NUMBER "P.PA.AD.5083", ADDRESS.STREET_NAME "P.PA.AD.5084", ADDRESS.STREET_SUFFIX "P.PA.AD.5085", ADDRESS.PRE_DIRECTIONAL "P.PA.AD.5086", ADDRESS.POST_DIRECTIONAL "P.PA.AD.5087", ADDRESS.BOX_DESIGNATOR "P.PA.AD.5088", ADDRESS.STN_INFO "P.PA.AD.5090", ADDRESS.STN_ID "P.PA.AD.5091", ADDRESS.REGION "P.PA.AD.5092", ADDRESS.DEL_DESIGNATOR "P.PA.AD.5093", ADDRESS.DEL_ID "P.PA.AD.5094", ADDRESS.DEL_INFO "P.PA.AD.5095", ADDRESS.COUNTRY_TP_CD "P.PA.AD.26", ADDRESS.PROV_STATE_TP_CD "P.PA.AD.36", ADDRESS.RESIDENCE_TP_CD "P.PA.AD.41", ADDRESS.P_CITY "P.PA.AD.5081", ADDRESS.P_STREET_NAME "P.PA.AD.8634", MISCVALUE.LAST_UPDATE_DT "P.PA.AD.TAVB.2978", MISCVALUE.VALUE_STRING "P.PA.AD.TAVB.2996", MISCVALUE.DESCRIPTION "P.PA.AD.TAVB.2974", MISCVALUE.START_DT "P.PA.AD.TAVB.2985", MISCVALUE.END_DT "P.PA.AD.TAVB.2975", MISCVALUE.VALUEATTR_TP_CD_9 "P.PA.AD.TAVB.2995", MISCVALUE.ATTR0_VALUE "P.PA.AD.TAVB.2964", MISCVALUE.ATTR1_VALUE "P.PA.AD.TAVB.2965", MISCVALUE.ATTR2_VALUE "P.PA.AD.TAVB.2966", MISCVALUE.ATTR3_VALUE "P.PA.AD.TAVB.2967", MISCVALUE.ATTR4_VALUE "P.PA.AD.TAVB.2968", MISCVALUE.ATTR5_VALUE "P.PA.AD.TAVB.2969", MISCVALUE.ATTR6_VALUE "P.PA.AD.TAVB.2970", MISCVALUE.ATTR7_VALUE "P.PA.AD.TAVB.2971", MISCVALUE.ATTR8_VALUE "P.PA.AD.TAVB.2972", MISCVALUE.LAST_UPDATE_USER "P.PA.AD.TAVB.2980", MISCVALUE.LAST_UPDATE_TX_ID "P.PA.AD.TAVB.2979", MISCVALUE.VALUEATTR_TP_CD_0 "P.PA.AD.TAVB.2986", MISCVALUE.VALUEATTR_TP_CD_1 "P.PA.AD.TAVB.2987", MISCVALUE.MISCVALUE_TP_CD "P.PA.AD.TAVB.2982", MISCVALUE.PRIORITY_TP_CD "P.PA.AD.TAVB.2983", MISCVALUE.MISCVALUE_ID "P.PA.AD.TAVB.2981", MISCVALUE.INSTANCE_PK "P.PA.AD.TAVB.2977", MISCVALUE.VALUEATTR_TP_CD_2 "P.PA.AD.TAVB.2988", MISCVALUE.VALUEATTR_TP_CD_3 "P.PA.AD.TAVB.2989", MISCVALUE.VALUEATTR_TP_CD_4 "P.PA.AD.TAVB.2990", MISCVALUE.VALUEATTR_TP_CD_5 "P.PA.AD.TAVB.2991", MISCVALUE.VALUEATTR_TP_CD_6 "P.PA.AD.TAVB.2992", MISCVALUE.VALUEATTR_TP_CD_7 "P.PA.AD.TAVB.2993", MISCVALUE.VALUEATTR_TP_CD_8 "P.PA.AD.TAVB.2994", MISCVALUE.VALUEATTR_TP_CD_9 "P.PA.AD.TAVB.2995", MISCVALUE.ATTR0_VALUE "P.PA.AD.TAVB.2964", MISCVALUE.ATTR1_VALUE "P.PA.AD.TAVB.2965", MISCVALUE.ATTR2_VALUE "P.PA.AD.TAVB.2966", MISCVALUE.ATTR3_VALUE "P.PA.AD.TAVB.2967", MISCVALUE.ATTR4_VALUE "P.PA.AD.TAVB.2968", MISCVALUE.ATTR5_VALUE "P.PA.AD.TAVB.2969", MISCVALUE.ATTR6_VALUE "P.PA.AD.TAVB.2970", MISCVALUE.ATTR7_VALUE "P.PA.AD.TAVB.2971", MISCVALUE.ATTR8_VALUE "P.PA.AD.TAVB.2972", MISCVALUE.ATTR9_VALUE "P.PA.AD.TAVB.2973", ALERT.LAST_UPDATE_DT "P.PA.AD.TANB.57", ALERT.LAST_UPDATE_TX_ID "P.PA.AD.TANB.58", ALERT.LAST_UPDATE_USER "P.PA.AD.TANB.59", ALERT.END_DT "P.PA.AD.TANB.54", ALERT.START_DT "P.PA.AD.TANB.61", ALERT.DESCRIPTION "P.PA.AD.TANB.53", ALERT.ALERT_TP_CD "P.PA.AD.TANB.51", ALERT.ALERT_SEV_TP_CD "P.PA.AD.TANB.50", ALERT.ALERT_ID "P.PA.AD.TANB.49", ALERT.INSTANCE_PK "P.PA.AD.TANB.56", PPREFENTITY.LAST_UPDATE_TX_ID "P.PA.PAPP.3118", PPREFENTITY.PPREF_INSTANCE_PK "P.PA.PAPP.3122", PRIVPREF.VALUE_STRING "P.PA.PAPP.3140", PRIVPREF.START_DT "P.PA.PAPP.3139", PRIVPREF.END_DT "P.PA.PAPP.3132", PRIVPREF.PPREF_ACT_OPT_ID "P.PA.PAPP.3136", PPREFENTITY.LAST_UPDATE_DT "P.PA.PAPP.3117", PPREFENTITY.LAST_UPDATE_USER "P.PA.PAPP.3119", PRIVPREF.LAST_UPDATE_DT "P.PA.PAPP.3133", PRIVPREF.LAST_UPDATE_USER "P.PA.PAPP.3135", PPREFENTITY.PPREF_ENTITY "P.PA.PAPP.3120", PRIVPREF.PPREF_ID "P.PA.PAPP.3137", PRIVPREF.PPREF_ID "P.PA.PAPP.3137", PRIVPREF.PPREF_ID "P.PA.PAPP.3137", PPREFENTITY.SOURCE_IDENT_TP_CD "P.PA.PAPP.3124", PRIVPREF.PPREF_TP_CD "P.PA.PAPP.3138", PPREFENTITY.PPREF_REASON_TP_CD "P.PA.PAPP.3123", PRIVPREF.LAST_UPDATE_TX_ID "P.PA.PAPP.3134", PPREFENTITY.PPREF_INSTANCE_PK "P.PA.PAPP.3122", PPREFINSTANCE.LAST_UPDATE_DT "P.PA.PAPP.EIPP.3127", PPREFINSTANCE.LAST_UPDATE_USER "P.PA.PAPP.EIPP.3129", PPREFINSTANCE.PPREF_INST_ID "P.PA.PAPP.EIPP.3131", PPREFINSTANCE.ENTITY_NAME "P.PA.PAPP.EIPP.3125", PPREFINSTANCE.INSTANCE_PK "P.PA.PAPP.EIPP.3126", PPREFINSTANCE.LAST_UPDATE_TX_ID "P.PA.PAPP.EIPP.3128", PPREFINSTANCE.PPREF_ID "P.PA.PAPP.EIPP.3130" FROM LOCATIONGROUP LOCATIONGROUP INNER JOIN ADDRESSGROUP ADDRESSGROUP ON (ADDRESSGROUP.LOCATION_GROUP_ID = LOCATIONGROUP.LOCATION_GROUP_ID) INNER JOIN ADDRESS ADDRESS ON (ADDRESS.ADDRESS_ID = ADDRESSGROUP.ADDRESS_ID) LEFT JOIN ALERT ALERT ON (((ALERT.INSTANCE_PK = ADDRESS.ADDRESS_ID) ) AND ((ALERT.END_DT > ? ) OR (ALERT.END_DT is null ))) LEFT JOIN MISCVALUE MISCVALUE ON (((MISCVALUE.INSTANCE_PK = ADDRESS.ADDRESS_ID) ) AND ((MISCVALUE.END_DT > ? ) OR (MISCVALUE.END_DT is null ))) LEFT JOIN PPREFENTITY PPREFENTITY ON ((PPREFENTITY.PPREF_ENTITY = 23) AND (PPREFENTITY.PPREF_INSTANCE_PK = ADDRESSGROUP.LOCATION_GROUP_ID)) LEFT JOIN PRIVPREF PRIVPREF ON ((PRIVPREF.PPREF_ID = PPREFENTITY.PPREF_ID) AND ((PRIVPREF.END_DT is null ) OR (PRIVPREF.END_DT > ?))) LEFT JOIN PPREFINSTANCE PPREFINSTANCE ON (PPREFINSTANCE.PPREF_ID = PRIVPREF.PPREF_ID) WHERE LOCATIONGROUP.CONT_ID = ? AND (((LOCATIONGROUP.END_DT is null ) OR (LOCATIONGROUP.END_DT > ? ))) 
 
MOST_EXP_SQL_MD5HASH = 50303b05850234a435e49941d8c2475f 
 
 
But when I generate a pdf report, I am not able to show all the data in a table detail row for it is showing only the first two lines and hide the rest. 
 
If I increase the row height size to something larger, it will show one or two more lines, but the rest is hidden. 
 
Also there can be queries which are very small like "select * from tablename" and hence the there should not be any white space shown in between. 
 
I am using the dynamic text from the Palette to display the row from the dataset. 
Also it is put in the detail row of the table. 
 
I tried setting different values for Overflow property for both the dynamic text and also for the detail table column holding the text. But during preview and also for HTML reports, it shows a scroll. But for PDF reports, the string is trunctated/hidden. 
 
Also I tried dragging the row to big size and then use the shrink=true property. But all rows, despite the small string size, are also taking the large row height. 
 
How can I show full text if the string is large like this? 
 
thanks 
Thomas

Find more posts tagged with

Comments

lnix

Hello,

Have you tried setting the row height to a blank value?

easothomas

<blockquote class='ipsBlockquote' data-author="'lnix'" data-cid="96835" data-time="1330368483" data-date="27 February 2012 - 11:48 AM">
Hello, 
 
Have you tried setting the row height to a blank value? </blockquote>
 
Hi, 
Thanks a lot. 
 
It did the trick. I did all other possible things, except this

Thomas

lnix

<blockquote class='ipsBlockquote' data-author="'easothomas'" data-cid="96838" data-time="1330370793" data-date="27 February 2012 - 12:26 PM">
If I increase the row height size to something larger, it will show one or two more lines, but the rest is hidden. 
 </blockquote>
 
Then what did you mean by this? Usually, if the row height is blank, the height will dynamically increase or descrease to fit the data. You must have something setting a hard value to the height. 
 
I've attached a sample report that shows what I'm talking about. Please refer to the far right column containing a dynamic text element.

easothomas

<blockquote class='ipsBlockquote' data-author="'lnix'" data-cid="96839" data-time="1330371404" data-date="27 February 2012 - 12:36 PM">
Then what did you mean by this? Usually, if the row height is blank, the height will dynamically increase or descrease to fit the data. You must have something setting a hard value to the height. 
 
I've attached a sample report that shows what I'm talking about. Please refer to the far right column containing a dynamic text element. </blockquote>
 
Hi lnix, 
 
Thanks again for the prompt response. 
 
I confused you. Sorry. 
 
When I was testing, I was using small strings. So after each string was printed, I wanted some space to be present before the next string was printed. So I dragged the row height in Layout to make some space between rows. For smaller strings, this worked okay. Please see the image attached. 
 
But when larger strings were put, it caused the pruning because I had dragged the row height and it (without my knowledge) set the row height. 
 
I could have achieved the spacing between the rows using some padding or so or even by creating an empty row in between. But as a newbie I am now, I didn't know much options. 
 
thanks, 
Thomas

easothomas

See the large text truncated when row height was dragged. This was what I explained.

Edit - Image attachment went bad I guess. Click on it and you can see the image.

lnix

Oh, I see. So, did you get it working? If you go back and remove all row height settings, the row height should be set dynamically. Like you said, you can add spacing with padding.