| Do you use Blob / Clob data in your reports? [message #65978] |
Mon, 08 August 2005 23:49  |
Eclipse User |
|
|
|
Do you currently use Blob/Clob data types in your report database? Do you
use such data with BIRT or any other reporting application, or have plans
to do so? If so we'd like to your feedback to help us continually improve
BIRT.
* What data type(s) do you have a need to feed into a report? Blob and/or
Clob? On
what DBMS platform(s)?
* What's the typical and maximal size of data in these Blob/Clob columns?
* What type of business data is stored in these columns?
* How do you like to see Blob/Clob data in a report? Do they need to bind
to an image, text control etc.?
* Do you have a need to perform searches into the Blob/Clob data?
* Do you need to have Scripting access to Blob/Clob data in BIRT reports?
thanks,
Gary Xue
BIRT Committer
|
|
|
|
| Re: Do you use Blob / Clob data in your reports? [message #66460 is a reply to message #65978] |
Wed, 10 August 2005 09:22  |
| Eclipse User |
|
|
|
Gary,
I have create Actuate solutions that use RTF stored in the data base as
the template in Mail Merge routines. I generate the doc in WordPad
embedding key field values into the WordPad Doc. I then save the doc as
RTF and save the RTF in a CLOB field of a table.
Then within a report I query the RTF, and another data source for the
variable data within the report. For each row of the variable data, I
modify the original doc, doing a string replace of the key fields. In
this way I can let non-report developers create the mail merge template
and it is trivial to actually generate the reports. Even better,
end-users can modify the design of the mail-merge doc without making a
change in the report design.
So in answer to some of your questions:
- Size typically less than 5,000 words, but 10K should to be safe.
- After the string replace, I display the data using a dynamic text control
- Yes I would need to do a search and replace in code across the CLOB
data, but I do not see searching the text control that displays the CLOB
data.
- Yes I would want to have scripting access to the CLOB data.
Scott Rosenbaum
BIRT PMC
Gary Xue wrote:
> Do you currently use Blob/Clob data types in your report database? Do
> you use such data with BIRT or any other reporting application, or
> have plans to do so? If so we'd like to your feedback to help us
> continually improve BIRT.
>
> * What data type(s) do you have a need to feed into a report? Blob
> and/or Clob? On
> what DBMS platform(s)?
> * What's the typical and maximal size of data in these Blob/Clob columns?
> * What type of business data is stored in these columns? * How do you
> like to see Blob/Clob data in a report? Do they need to bind to an
> image, text control etc.?
> * Do you have a need to perform searches into the Blob/Clob data?
> * Do you need to have Scripting access to Blob/Clob data in BIRT reports?
>
> thanks,
> Gary Xue
> BIRT Committer
>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.04562 seconds
Home