Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Report designer

Report design issues and solutions.
Post Reply
ahodge03067
User
User
Posts: 4
Joined: 25 Nov 2011, 15:36
Sage Version: v2008 14 UK/Europe/Africa

Report designer

Post by ahodge03067 » 25 Nov 2011, 15:39

HI there,

I am trying to design a report and I am having a problem with the headers. I have a report header and footer however the report footer is on every single page of the report when previewed but only printed on the last page. How do I stop this.

Any ideas?

Thanks,

Alex

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4237
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Report designer

Post by brucedenney » 27 Nov 2011, 12:11

Could you upload the report and an attachment?
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

ahodge03067
User
User
Posts: 4
Joined: 25 Nov 2011, 15:36
Sage Version: v2008 14 UK/Europe/Africa

Re: Report designer

Post by ahodge03067 » 27 Nov 2011, 22:56

I've uploaded the report :)
You do not have the required permissions to view the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4237
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Report designer

Post by brucedenney » 28 Nov 2011, 09:20

I have run the report to preview and, contrary to your description, the report header only appears on the first page, the report footer only appears on the last page, the page header appears on every page and the page footer appears on every page.

The system I used was running version 1.3.2011.25 of the report designer. What version are you running?
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

ahodge03067
User
User
Posts: 4
Joined: 25 Nov 2011, 15:36
Sage Version: v2008 14 UK/Europe/Africa

Re: Report designer

Post by ahodge03067 » 28 Nov 2011, 09:58

The version I'm using it v.1.0.0.5

The problem I am having is the report footer is being printed on the last page however it is leaving a space on every other page where it should be. I have attached a print screen of how it is being displayed.

Does it look like this on your version?
You do not have the required permissions to view the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4237
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Report designer

Post by brucedenney » 28 Nov 2011, 11:19

This is how it looks to me...
yyudfj34.JPG
Perhaps you should upgrade your report designer to the latest version and see if that improves things.

However, it does trigger a thought that perhaps the designer thinks you are using Letter sized paper for the body and A4 for the footer.
I am wondering what the paper size is set to in the report and in the printer driver. Are you printing an A4 report to a printer that thinks it is loaded with Letter sized paper for example, could this be causing the report designer to use different sizes in different places?
You do not have the required permissions to view the files attached to this post.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

ahodge03067
User
User
Posts: 4
Joined: 25 Nov 2011, 15:36
Sage Version: v2008 14 UK/Europe/Africa

Re: Report designer

Post by ahodge03067 » 06 Dec 2011, 10:25

Thanks for your help with this. It turned out to be my version of Sage, tried it on another machine with an update version and it displayed fine.

Just one question do you know to display commas with costs e.g £40,000,000 as mine just displays £40000000.

Many thanks,

Alex

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4237
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Report designer

Post by brucedenney » 06 Dec 2011, 12:25

It is set by the "formatting" property of the field on the report.
reportthousands.JPG
You do not have the required permissions to view the files attached to this post.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests