Problem in viewing the complete data in a column

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

SQL Server 2000 Forums

SQL Server Development (2000)

Problem in viewing the complete data in a column

Author

Topic

sreehari
Starting Member

37 Posts

Posted - 2006-08-04 : 08:16:01

Hi all

here..REPORT_TEMPLATE column is of type NTEXTwhen i execute the following command, the record is getting inserted. but when i query the REPORT_TEMPLATE column , i am not able to view the comoplete data in it..i also tried changing the default result target int Tools menu to file and text..still i could not see the complete data..
how to see the completed data in a column ,,

Thanks in advance..

insert into report_info_detail (REPORT_INFO_ID, REPORT_EXPORT_TYPE_CODE, PLUGIN_CLASS_NAME, IS_ACTIVE,REPORT_TEMPLATE)
select r.report_info_id, --REPORT_INFO_ID
'pdf', --REPORT_EXPORT_TYPE_CODE (htm, pdf,csv)
'com.ocs.poetic.reports.JRActivatedLicAssetReportPlugin',--PLUGIN_CLASS_NAME
-1, --IS_ACTIVE
--REPORT_TEMPLATE
'<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport
name="ActivatedLicAssetReportTemplate"
language="java"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="842"
pageHeight="595"
columnWidth="782"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="AllSectionsNoDetail"
isTitleNewPage="false"
isSummaryNewPage="false"
resourceBundle="JasperReportsLocalization"
whenResourceMissingType="Empty">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />

<parameter name="DataFile" isForPrompting="true" class="java.lang.String"/>
<parameter name="CompanyName" isForPrompting="true" class="java.lang.String"/>
<parameter name="CertStatus" isForPrompting="true" class="java.lang.String"/>

<field name="COMPANY_NAME" class="java.lang.String"/>
<field name="CITY" class="java.lang.String"/>
<field name="TARGET_ID" class="java.lang.String"/>
<field name="LKP(PRODUCT_LINE)PRODUCT_LINE" class="java.lang.String"/>
<field name="LKP(FAMILY)PRODUCT_FAMILY_CODE" class="java.lang.String"/>
<field name="LKP(COUNTRY)COUNTRY_CODE" class="java.lang.String"/>
<field name="EMAIL" class="java.lang.String"/>
<field name="LTU" class="java.math.BigDecimal"/>

<variable name="ltuGroupSum" class="java.math.BigDecimal" resetType="Group" incrementType="Group" incrementGroup="COMPANY_NAME" resetGroup="COMPANY_NAME" calculation="Sum">

<variableExpression><![CDATA[$F{LTU}]]></variableExpression>
</variable>
<variable name="LtuSum" class="java.math.BigDecimal" resetType="Group" resetGroup="GROUP_LTU" calculation="Sum">

<variableExpression><![CDATA[$F{LTU}]]></variableExpression>
</variable>

<group name="COMPANY_NAME" >
<groupExpression><![CDATA[$F{COMPANY_NAME}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle>
<reportElement
x="0"
y="0"
width="780"
height="20"
forecolor="#000000"
backcolor="#0066CC"
key="rectangle"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="0"
y="0"
width="100"
height="20"
forecolor="#000000"
key="staticText-1_COMPANY_NAME"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{COMPANY_NAME}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="105"
y="0"
width="144"
height="20"
forecolor="#000000"
key="textField-1_COMPANY_NAME"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{COMPANY_NAME}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="250"
y="0"
width="42"
height="20"
forecolor="#000000"
key="staticText-2_EMAIL"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{EMAIL}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="296"
y="0"
width="49"
height="20"
forecolor="#000000"
key="textField-2_EMAIL"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{EMAIL}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="350"
y="0"
width="29"
height="20"
forecolor="#000000"
key="staticText-3_CITY"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{CITY}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="381"
y="0"
width="149"
height="20"
forecolor="#000000"
key="textField-3_CITY"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CITY}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="538"
y="0"
width="65"
height="20"
forecolor="#000000"
key="textField-4_COUNTRY_CODE"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{LKP(COUNTRY)COUNTRY_CODE}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="608"
y="0"
width="50"
height="20"
forecolor="#000000"
key="staticText-5_LTU"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{LTU}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="#0" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="COMPANY_NAME" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="665"
y="0"
width="50"
height="20"
forecolor="#000000"
backcolor="#FFCCCC"
key="textField-5_ltuGroupSum"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ltuGroupSum}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="#0" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="COMPANY_NAME" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="719"
y="0"
width="50"
height="20"
forecolor="#000000"
backcolor="#FFCCCC"
key="textField-5_LtuSum"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{LtuSum}]]></textFieldExpression>

</textField>
</band>
</groupHeader>
<groupFooter>
<band height="2" isSplitAllowed="true" >
<line direction="BottomUp">
<reportElement
x="0"
y="-6"
width="1"
height="1"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</line>
</band>
</groupFooter>
</group>
<group name="TARGET_ID" >
<groupExpression><![CDATA[$F{TARGET_ID}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle>
<reportElement
x="35"
y="0"
width="745"
height="20"
forecolor="#000000"
backcolor="#0099CC"
key="rectangle-1"
positionType="FixRelativeToBottom"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="35"
y="0"
width="100"
height="20"
forecolor="#000000"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{TARGET_ID}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="140"
y="0"
width="300"
height="20"
forecolor="#000000"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{TARGET_ID}]]></textFieldExpression>

</textField>
</band>
</groupHeader>
<groupFooter>
<band height="2" isSplitAllowed="true" >
<line direction="BottomUp">
<reportElement
x="0"
y="-5"
width="1"
height="1"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</line>
</band>
</groupFooter>
</group>
<group name="PRODUCT_LINE" >
<groupExpression><![CDATA[$F{LKP(PRODUCT_LINE)PRODUCT_LINE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle>
<reportElement
x="35"
y="0"
width="745"
height="20"
forecolor="#000000"
backcolor="#009999"
key="rectangle-2"
positionType="FixRelativeToBottom"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="35"
y="0"
width="100"
height="20"
forecolor="#000000"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{PRODUCT_LINE}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="140"
y="0"
width="300"
height="20"
forecolor="#000000"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{LKP(PRODUCT_LINE)PRODUCT_LINE}]]></textFieldExpression>

</textField>
</band>
</groupHeader>
<groupFooter>
<band height="10" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="GROUP_LTU" >
<groupExpression><![CDATA[$F{LTU}]]></groupExpression>
<groupHeader>
<band height="0" isSplitAllowed="true" >
</band>
</groupHeader>
<groupFooter>
<band height="0" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="30" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
x="0"
y="0"
width="782"
height="1"
forecolor="#808080"
key="line"/>
<graphicElement stretchType="NoStretch" pen="2Point"/>
</line>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="0"
y="5"
width="782"
height="20"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{activation_report_title}]]></textFieldExpression>

</textField>
<line direction="TopDown">
<reportElement
x="0"
y="25"
width="782"
height="1"
forecolor="#808080"
key="line"/>
<graphicElement stretchType="NoStretch" pen="2Point"/>
</line>
</band>
</title>
<pageHeader>
<band height="0" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="45" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="50"
y="0"
width="100"
height="20"
key="staticText-1_FAMILY"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{FAMILY}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="150"
y="0"
width="335"
height="20"
key="textField-1_FAMILY"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{LKP(FAMILY)PRODUCT_FAMILY_CODE}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="50"
y="20"
width="100"
height="20"
key="staticText-2_LTU"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{LTU}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="150"
y="20"
width="335"
height="20"
key="textField-2_LTU"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{LTU}]]></textFieldExpression>

</textField>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="40" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
x="0"
y="0"
width="782"
height="1"
key="line"/>
<graphicElement stretchType="NoStretch" pen="2Point"/>
</line>
<image scaleImage="FillFrame" isUsingCache="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
mode="Opaque"
x="0"
y="5"
width="140"
height="35"
key="image-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<graphicElement stretchType="NoStretch"/>
<imageExpression class="java.lang.String"><![CDATA[$R{image_ocs_logo}]]></imageExpression>

</image>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="145"
y="0"
width="200"
height="15"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Right">


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="351"
y="0"
width="127"
height="15"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="607"
y="0"
width="69"
height="15"
key="textField-5"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{execution_date}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="679"
y="0"
width="101"
height="15"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>


</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="145"
y="15"
width="350"
height="10"
key="textField-3"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{disclaimer_line_1}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="145"
y="30"
width="350"
height="10"
key="textField-4"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">


</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{disclaimer_line_2}]]></textFieldExpression>

</textField>
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>'
from report_info r where security_resource_name = 'ACTIVATED_LIC_ASSET_REPORT'

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-04 : 08:47:35

You can't. The Query Analyzer only can show up to 8192 characters for a column.

You XML text is about 25,500 characters long.

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources