1. Trevor Campbell
  2. Valentina Reports ADK
  3. Thursday, November 16 2017, 04:27 AM
  4.  Subscribe via email
I have created a number of reports and I'm trying to merge them all into one document. I am using Xojo Webapp.

This works ok if I print directly to PDF Creator. It asks if you want to merge documents. But this only works if you are on the server.

Is there a way to merge a number of reports into a single document on a client machine?
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hi Trevor,

Yes, it is possible using the subreports with property "independent" turned on.
You can create a container report and add all necessary subreports and set queries for them.
Subreports are printed on separate pages using the page setup of the inserted report, they may have their own page format and orientation.

For example:
- the query of the main report returns something like SELECT 1 to avoid error messages
- for the first subreport the property independent is turned off - otherwise, an empty page will be inserted at the beginning
- for other subreports the property independent is on.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 1
Trevor Campbell Accepted Answer
Thanks for the reply. Is there a way to do this in Xojo? Cause I have to send dynamically generated queries to the different reports.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 2
Sergey Pashkov Accepted Answer
No, not exactly.
Are generated queries differ significantly?
If it is possible to use parameters in it (to modify the source queries) - then the subreports way will work.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 3
Trevor Campbell Accepted Answer
Yes, each report has a different query and different parameters. I also need to print the same report multiple times, each with different parameters.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 4
Jay Madren Accepted Answer
I wonder if you could use a parameter to pass in the entire query to a subreport (or most of it)?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 5
Sergey Pashkov Accepted Answer
Hello,
No, currently it is not possible.
If the datasource is able to return a recordset from the stored procedure it could be a workaround, but very indirect.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.