1. Trevor Campbell
  2. Report Editor
  3. Dienstag, April 07 2020, 05:21 AM
  4.  Abonnieren via E-Mail
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.
Anhänge
Kommentar
There are no comments made yet.
Trevor Campbell Akzeptierte Antwort
Hi Sergey,

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

Thanks
Trevor
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Anhänge
Kommentar
There are no comments made yet.
Trevor Campbell Akzeptierte Antwort
Here is a screenshot of page 2 with Borders and Names checked.

Thanks
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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?
Anhänge
Kommentar
There are no comments made yet.
Trevor Campbell Akzeptierte Antwort
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.
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  • Seite :
  • 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