Problems generating reports
I developped a data-entry application in D7 which is linked to a DB
through a DBModule. My problem is when I create my report. Using my
application, I can navigate through my records using filters and
locates. When I want to generate my report, I must select the
information I want to print through a different form, i.e. I must select
a company, and then, select one of its employees, through a DBGrid.
When I do this, once I print the report and want to return to my
application, I notice that all my records are displayed according to my
selections for the report, but not all the fields are synchronized. I
would like for my application and my report generator to act
independantly. I imagine that for this I cannot use the same DBModule
items (DataSources and DBTables) but I tried with IBQueries, and it
doesn't necessarily fix the problem. I don't know if this is clear
enough, but if so, I hope someone can help!
Thanks in advance,
BMACF
through a DBModule. My problem is when I create my report. Using my
application, I can navigate through my records using filters and
locates. When I want to generate my report, I must select the
information I want to print through a different form, i.e. I must select
a company, and then, select one of its employees, through a DBGrid.
When I do this, once I print the report and want to return to my
application, I notice that all my records are displayed according to my
selections for the report, but not all the fields are synchronized. I
would like for my application and my report generator to act
independantly. I imagine that for this I cannot use the same DBModule
items (DataSources and DBTables) but I tried with IBQueries, and it
doesn't necessarily fix the problem. I don't know if this is clear
enough, but if so, I hope someone can help!
Thanks in advance,
BMACF
This discussion has been closed.
Comments
If you are filtering your dataset, this means the actual data inside is
being changed. ReportBuilder only traverses the data you give it, it does
not change your data in any way. If you would like the data used by the
report to remain separate from the data used by your main application, you
will either need to find a way to restore the original data once the report
has finished using the filtered dataset or simply use two separate datasets.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com