1. Trevor Campbell
  2. Report Editor
  3. Вторник, Апрель 07 2020, 05:21 AM
  4.  Подписаться через email
I have a report with a subreport. = Report 1.jpg

When I preview the report the first page works fine, but then elements of the report randomly doesn't print. Shown Report Page 1 and Report Page 2.

I'm trying to figure out what would cause this.
Вложения
Комментарий
There are no comments made yet.
Trevor Campbell Ответ принят
Hi Sergey,

Thanks for your suggestion. I tried it and I have managed to get it to work by making some tweaks.

Thanks
Trevor
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Trevor,

Looks like it is related to subreport layout.
Did you try to group by dept_name instead of adding a subreport?
It works better in my tests, however, I can't get exactly the same results.
Вложения
Комментарий
There are no comments made yet.
Trevor Campbell Ответ принят
Here is a screenshot of page 2 with Borders and Names checked.

Thanks
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
What do you see if you turn on Borders and Names options on Profile tab in preview mode for Report Page 2? What controls are placed in the first column if any?
Вложения
Комментарий
There are no comments made yet.
Trevor Campbell Ответ принят
Hi Sergey,

I have attached a project with the Report and Subreport.
The SQL for the report is :

select * from "user"."tbl_name"


The SQL for the subreport is :

select * from "user"."tbl_name" where tfi_detail_id = $P(det_id)


I have also attached a csv of the data for the table. First row is field names.

I am currently using Version 8.
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Trevor,

What version is used?
If you can send report and subreport layouts with data (SQL/CSV) for first pages - that would help a lot.
Комментарий
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