1. Trevor Campbell
  2. Valentina Reports ADK
  3. Четверг, Ноябрь 16 2017, 04:27 AM
  4.  Подписаться через 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?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Вложения
Комментарий
There are no comments made yet.
Trevor Campbell Ответ принят
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.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
Trevor Campbell Ответ принят
Yes, each report has a different query and different parameters. I also need to print the same report multiple times, each with different parameters.
Комментарий
There are no comments made yet.
Jay Madren Ответ принят
I wonder if you could use a parameter to pass in the entire query to a subreport (or most of it)?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
  • Страница :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories