2. PHPRunner General questions
  3. [SOLVED] Creating "one to many detailed report" output from PHPRunnner 10.6
This topic is locked
[SOLVED]

Creating "one to many detailed report" output from PHPRunnner 10.6

 		6/7/2022 4:37:04 AM
PHPRunner General questions
C
 Craig Smith author

Hi everyone,

I looking for advice. I need to collect information using PHPRunner (which I can do easily in a variety of ways / forms / phprunner applications) and create a printed/pdf form as output from a MySQL database.

In my mind I am thinking about a reporting tool, similar to Microsoft Access reporting capabilities. I really need the ability to connect to a MySQL server to create the output.

I have a lot of experience with Access, MySQL and PHPRunner, but for some reason I can't seem to figure a direction to head in to create "one to many" reports, or, report with sub-reports or reports with pictures etc etc.
I hope this makes sense. Think of a quality conformance report - a coil of stell has a certificate with details of its chemical make up, and details of the manufacturing process. I would like to create a certificate / report for one coil of steel, with a picture(s) of the coil, and a chemical details section, then a standards conformance section, etc, each one of those sections having the ability to contain any number of detailed, related records.

I would appreciate a nudge in the right direction. Especially if I have missed a feature for this kind of report within PHPRUnner (I have looked hard for this capability) - I will be embarrased if this type of report is possible with PHPRunner, but grateful for any help.

Thank you in advance for your help.

Best regards,

Craig Smith
Admin 6/7/2022

Can you posty a screenshot that explains what kind of output you are after?
C
 		Craig Smith author 6/8/2022

Thanks for the reply,

These are examples of the type of report I am looking to create. A Corrective Action Report is a good example, where detailed actions are stored in related tables and need to be inserted into the body of the report.
This is possible in Access by inserting a sub-report in to a main report and linked a key field. Then you can have one or more details in each section. I may also need to insert related database records with photos stored in them.

img alt

img alt

I hope this makes sense - please let me know if I need to clarify further.

Best regards,
Craig Smith
fhumanes 6/9/2022

Hello,

To make reports of this type of the people who have contacted me and myself, we have used the Word document generation solution (more powerful solution) and also, Excel documents.

On some occasions I have used the JasperPHP solution (because I only want to use PHP code), but it is very reduced from characteristics.

You can find examples and explanations on my fhumanes.com portal

Regards,
fernando
Admin 6/9/2022

Thank you, it makes more sense. This looks to me like a regular View page of the master table.

Create master-details relationships, choose to dispplay details on the View page of the master, then proceed to the Page Designer and rearrange objects on the View page of the master table.

You can see something similar in the Invoice template
C
 		Craig Smith author 6/10/2022

Hello Fernando and Admin (Sergey?),

Thank you for your help on this. I checked out fhumanes.com and the invoice XLinesoft invoice template as well.

It suddenly struck me how silly I had been for not investigating the View page formatting options more thoroughly.
I have tested this by inserting multiple detail tables in to a view screen, merging cells and inserting columns etc etc and it is working out just fine.

In fact it more than "just fine" - it's awesome !! It reminded of why PHPRunner is such a good product.

Thanks again - I really appreciate the push in the right direction.

Have a great day.

Best regards,

Craig
C
 		Craig Smith author 6/10/2022

THis is an example of what I am working on - it will be perfect for my needs. :)

img alt

Best regards,
Craig