Report Lost Connection

rbuser

Hello,
I want to change something in my report, for example only the size of a
label. And i won't do this in my project where I have create the report
and where all connections, querys, and pipelines exist.
So I open a new project, put the component ppReport on my form and load
my report I want to change.
But the problem is, that when I save the report, the connection is lost,
because I've got only the report and no necessary connections or querys
on my form.
Now I want to know, if there is any option to say to the report, that
the connection should be save also when the connection is not existing
on the form?

nicocizik

Hi David,

Unfortunately no, once you load a report that does not have access to
the proper pipeline connections, these will be ignored and lost in the
template when you save again.

The best way to work around this issue is to keep all data connections
local to the template itself using DADE. DADE is a feature of
ReportBuilder Pro or higher that allows you to create and maintain the
report data access inside the report (using the data workspace or data
tab). Then when the template is saved, all data access is saved as well
an there is no need for pipeline components on the form. For more
information on DADE, see the following web pages.

http://www.digital-metaphors.com/products/visual_data_access/

http://www.digital-metaphors.com/rbWiki/DADE

Another option would be to save your templates as ASCII text and edit
them manually as text.

Finally, you could edit your reports in your main application where the
original connections exist.