Jump to content
  • 0
Sign in to follow this  
Speedracer350

Create a certificate like report for printing

Question

I have an existing access database that sort of serves as a CRM. I have a table of students, and I print certificates when they pass a course. In access, this is a report fed with a query of the their table data with all your typical certificate jargon. It then prints nicely. I’ve been playing around with DataPages and views, but can’t seem to figure out if a similar report can be created. Any insight would be great!

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

The best current way to create a Document or Certificate-like datapage is with a list-type report page - to my knowledge. You'll need a lot of HTML and CSS to manipulate the page to look like a certificate.

You need to add one field at least to get to the Results page - just pick a random one to get you to the Configure Results page. Once there, add in a Calculated Field and just write "NULL" in it. Now you can delete that random field you added in. Make sure to have Header and Footer enabled on the Configure Results page. 

After that, add an HTML block. 

Click on 'Next' to go to the next configure screen. You will see an option for Records Per Page. Set this to 1. This will make it so only one list record will show on the screen, which helps with printing.

Then, you need to make that 1 list record full width and height of the page. Put this in the header.

<style>

div[class*="cbResultSetPanelDataContainer"]{
height: 100% !important;
width: 100% !important;
background-color: white !important;
}

</style>

After that, go into your HTML block you added. Now you can use either HTML or the WYSIWYG Editor to create how you want the certificate to look like. You can use the field picker to input fields directly from your table. It is tricky to make it look right, but after some time you might be able to get something that looks good enough.

Finally, this page will only look right if you make it a PDF and download from there. So, in that same screen where you set Records Per Page to 1, click on the Advanced Tab. Then check on PDF. Then click on the pen by the PDF checkbox a mess with the PDF Settings until it fits your liking. 

Caspio does not have a standard feature for something like this. It is pretty ridiculous. If we could use the PDF generator on Details Page like before, this would be easier, but I am still a believer that a Document type datapage should be standard.

Here are the links to the PDF on Details Idea and the Document/Letter DataPage Idea on Caspio's Ideabox if you would like to add a vote.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...