1. Trevor Campbell
  2. Report Editor
  3. 火, 4月 07 2020, 05:21 AM
  4.  メールで購読
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.