LiveReports - need to prompt on multiline text attribute
I have a LiveReport displaying several attributes from a category. Some of these attributes are datatype Multiline Text. I can display them in the report but I cannot use them as user input (ie where the user is prompted for a select query input). How do I do this? The user input in the LiveReport lists only STRING but to display the attribute I have to define it as ValLong. Any suggestions?Below is my sql query:Select %5, ISNULL(d.ValStr,'') "Company Code", ISNULL(b.ValStr,'') "Division", ISNULL(DTree.Name,''), ISNULL(e.ValStr,'') "Primary Operating Area", ISNULL(h.ValLong,'') "Drawing Title", ISNULL(j.ValStr,'') "Status", ISNULL(c.ValStr,'') "Facility Name" From DTree, /* Division */ LLAttrData b, /* Facility Name */ LLAttrData c, /* Company Code */ LLAttrData d, /* Primary Op Area */ LLAttrData e, /* Drawing Title */ LLAttrData h, /* Status */ LLAttrData j Where DTree.DataID=b.ID AND DTree.VersionNum=b.VerNum AND b.DefID in (select distinct CatID from CatRegionMap where CatName='Pipeline') AND b.AttrID=3 AND DTree.DataID=c.ID AND DTree.VersionNum=c.VerNum AND c.DefID in (select distinct CatID from CatRegionMap where CatName='Pipeline') AND c.AttrID=11 AND DTree.DataID=d.ID AND DTree.VersionNum=d.VerNum AND d.DefID in (select distinct CatID from CatRegionMap where CatName='Pipeline') AND d.AttrID=2 AND DTree.DataID=e.ID AND DTree.VersionNum=e.VerNum AND e.DefID in (select distinct CatID from CatRegionMap where CatName='Pipeline') AND e.AttrID=4 AND DTree.DataID=h.ID AND DTree.VersionNum=h.VerNum AND h.DefID in (select distinct CatID from CatRegionMap where CatName='Pipeline') AND h.AttrID=22 AND DTree.DataID=j.ID AND DTree.VersionNum=j.VerNum AND j.DefID in (select distinct CatID from CatRegionMap where CatName='Pipeline') AND j.AttrID=13 AND (UPPER(ISNULL(d.ValStr,'')) like (UPPER(ISNULL(%1,'')) + '%%'))AND (UPPER(ISNULL(h.ValStr,'')) like (UPPER(ISNULL(%2,'')) + '%%'))AND (UPPER(ISNULL(e.ValStr,'')) like (UPPER(ISNULL(%3,'')) + '%%'))AND %4 AND %6 order by DTree.Name
