Data type for 'Template Field' for TppReport

rbuser

Hi All,
I m using delphi7.0, ms-sql 2005, n reportbuilder enter prise edition
10.07 in my project.

I want to manipulate (loading, storing, etc) report layouts thru my
project.

I have some predefined layouts stored in Database table, where field has
datatype as 'Text'.
So in project my template field is of 'Text' datatype. but that gives
me 'Invalid template format' error while I m trying to open any
particular layout in my project.
Previously, I worked with these types of layouts with out any problems
but at that time my Template Field is of 'Image' type.

Can u guide me to solve this critical problem?

Satisfactory and Reliable Solutions Comes here

--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Sheetal,

If you are loading and saving report templates using the built-in
Template.LoadFromDataBase/SaveToDataBase mechinism, you will need to use a
BLOB field to save the template data (or in SQL Server an Image field).

Otherwise you might try streaming the data first, then loading it using the
Template.LoadFromStream routine.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nardmoseley

I asked you before to please not post to the newsgroups and to
support@digital-metaphors.com.

Please be respectful of our resources and to other customers.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

I am now avioding usage of 'support@digital-metaphors.com' but i didn't
understood about newsgroups.
if u won't mind please give me info abt it as i m unaware abt it.
with ur info i can stop posting my queires if by chance unknowningly i m
doing that.

Sorry to distruct product image, and i m regretful about it.

Can i know, by posting queires\joining this forum (digital-
metaphors.public.reportbuilder.end-user) had i done the same thing?


Satisfactory and Reliable Solutions Comes here

--- posted by geoForum on http://delphi.newswhat.com

nardmoseley

Please post questions to a /single/ destination. Use the newsgroups /or/
support@digital-metaphors.com. Do not send the same question to /multiple/
destinations.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Thanks for Kind Concern!!!

use a
I can't Change Field type. Firstly I Already contains much Data, and man
clients are using it so this is not possible.
the
How to stream data. Can you help out me with some sample or so.

I am new to these Report Builder and so to this forums.

All Help would be appreciated.

Regards,
Sheetal

Satisfactory and Reliable Solutions Comes here

--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Sheetal,

How are you connecting to the SQL Server database? If you are using the
BDE, you may be running into an issue with the MaxBlobSize being too small.
I would first suggest switching to ADO to access you database however if you
must us the BDE, try increasing the MaxBlobSize property and see if that
helps the problem.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nicocizik

Hi Sheetal,

Sorry for misleading you. It is possible to save a template (as ascii text)
to a Text field in SQL Server and successfully load it from the database.
In my quick testing I was able to save a report as text to a text field in
SQL Server, then re-load that report from the DB and view it correctly.

Are you certain the templates you have saved to your database are valid
ReportBuilder templates saved as ascii text? Try saving one of the
templates to file and see if you can manually open one.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hello Nico

I m using ADOConnedtion component to connect to SQL Server. so no
question abt BDE and so MaxBlobSize.

My problem is 'text' Field type as you said, it should be 'Image' type.

You suggested me to use Streams and all for layout (Template)
manipulation.

I want to know how they are used. Any Demo\Sample Project that will help
me to guide it will do. Aur any other guides to know its working will
work.

Great Thanks for all your Concern!!!

Regards
Sheetal.

Satisfactory and Reliable Solutions Comes here

--- posted by geoForum on http://delphi.newswhat.com