Two big problems with Crystal Reports ...

yihuagong

1.Use the code to take the picture data from the database and display it on the crystal report.



2.How to make the sub-report's title also display when pagination ... because there is no pageHeader item in the sub-report,
The subreport is placed in the ReportFooter of the main report. This causes the table title to not be displayed repeatedly when the subreport is paginated ... not very nice.

qjd2346316

As for the second question, my suggestion is. Put the title of the subreport in the ReportFooter of the main report

yihuagong

It ’s useless to put it in the main report. I mean there are multiple pages in the sub-report. The second and third pages also show the header.

qjd2346316

This is easy to handle. . I just tried it.
You close the pop-up page of the click subreport, and all the content is displayed in the main report. How many pages are there in your subreport, you can see the title in front of each page

yihuagong

Where did the pop-up page come from .. I might think I clicked to display the subreport. Not like that.
My main report is bound to the main table. Because it is a picture field, it cannot be passed by value.
Then display a subreport (detail) in the report footer.

yihuagong

The second one has been resolved, you need to add a group, and then set it in the group: display the header for each page.

znj9531

I am also stuck on the first question

legend03iy

I think a report consists of two parts, format and data.
First, the format: Every person in each company and every department has different requirements for the format at different times. Don't say that the customer is abnormal, the demand is reasonable, and the customer is always God. So I think the format of the report should be based on EXCEL as a template, so , Users can change it at will, and people all over the country will use EXCEL. So developers do not have to consider the format of the report.

Second, data: There are many databases, small ACCESS and FOXBASE, large SQL SERVER\DB2\ORACEL\INFOMIX\SYBASE, etc., which have nothing to do with the database platform. The relationship is the SQL statement. This is the key to data analysis and the focus of customer report requirements. Report designers (including: Software supports\software implementation\development) Only when you fully understand the core of customer reporting requirements, can you write qualified SQL statements.

julylucky

good idea!
Add a group to the subreport at random, and then choose to repeat the header. I use this method to solve the second problem.