Home Creators Posts Import Register Favorites Logout

Downloads

Content

Hello Members!

In this week’s Feature, Fix, or Focus, we take last week’s One Click Report Generator training.

Here are the updates I made for this training:

· Color Sorted Columns requested by Sammy

· Right Click In Table requested by David Hughes 

· Print Report added by Randy Austin

· Save As PDF added by Randy Austin

· Set Minimum Column Width added by Randy Austin

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Files

Comments

Ritaeffio

How can I change the format to left instead of center. YOu have it center but I need for the data to display to the left not center this is when refresing the data some colums are in the center

Excel For Freelancers

Hi and thanks very much. If you format the original, source data, to where you want it,t hen the destination data will be formatted correctly as well. I hope this helps and thanks so much.

Ritaeffio

how can i take out the auto fit headers in the Customer_Report i have colums with 1 digit numbers which causing the headers to shrink when creating the report.

Excel For Freelancers

Hi and thanks. I completed this template many years ago so I do not remember all of the code, however just search inside the code for autofit and remove it, or if there is no autofit, locate the original column and make sure it is wider, so that when it is copied over the same column width is used. Please make sure to watch the full training since i go over it in the video. I hope this helps and thanks so much.

Ritaeffio

how to take the autofit it off without creating bug issues.

Ritaeffio

How can I lock the header text format it shrinks when the data width is less than header title therefore the header in the report shrinks and is not visible

Ritaeffio

I submitted to join the facebook group is pending for approval

Ron Zelaya

Thank you Randy. This is got to be in the all time top ten list. One minor suggestion: get the columns to adopt the vertical and horizontal alignment properties of the default field types in the admin sheet, so that cols in report look neater. Best regards & Happy New Year!!

Excel For Freelancers

Hi and thanks so much. So glad you enjoy it. Regarding the columns in the reports, I have already added autofit function so that the column widths will adjust automatically based on the contents. Thanks so much and Happy New Year to you too.