Hot Topic (More than 10 Replies) report formatting (Read 1148 times)
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
report formatting
Nov 17th, 2011 at 10:38pm
Print Post Print Post  
My report prints perfect..........providing I do a page set up of landscape and set scale to 60%........I am willing to do that but the other 20 people in the office won't!   Even when I set up landscape in my command button (I use @printareport - html) it doesn't revert to landscape  I am frustrated!  HATE Sesame report function vs Q&A
  
Back to top
 
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: report formatting
Reply #1 - Nov 18th, 2011 at 2:47am
Print Post Print Post  
Hopefully someone with report knowledge will respond to you. In the meantime, be sure to check out QuickReports from the left hand command menu.

It's so simple to run reports this way, I haven't bothered taking the time to learn how to run 'full' reports.
  
Back to top
IP Logged
 
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Re: report formatting
Reply #2 - Nov 18th, 2011 at 3:23pm
Print Post Print Post  
Unfortunately my report is huge (140 pages) and is run by approx. 10 people every Monday morning!
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: report formatting
Reply #3 - Nov 18th, 2011 at 5:23pm
Print Post Print Post  
debmckee wrote on Nov 18th, 2011 at 3:23pm:
Unfortunately my report is huge (140 pages) and is run by approx. 10 people every Monday morning!

10 people each print out 140 pages every Monday? Do they really need to print it out? One of the nice things about HTML reports is that they show up in your browser and aren't limited by the size of paper.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Re: report formatting
Reply #4 - Nov 18th, 2011 at 6:00pm
Print Post Print Post  
yes they do, it is an inventory report and the sales dept use it to see what is available, etc. who bought from what lot in the past, etc.  Its a lot of trees but we have a lot of product!  If you are on the phone with someone you dont have time to set up a retrieve (we have over hundred items) and check availablility of just one item.  But you can read it in a report without missing a beat.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: report formatting
Reply #5 - Nov 18th, 2011 at 6:08pm
Print Post Print Post  
debmckee wrote on Nov 18th, 2011 at 6:00pm:
But you can read it in a report without missing a beat.

Yes, but can't you read it from the screen instead of from a piece of paper?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Re: report formatting
Reply #6 - Nov 18th, 2011 at 7:22pm
Print Post Print Post  
no
  
Back to top
 
IP Logged
 
Rick_R
Full Member
***
Offline



Posts: 243
Joined: Jan 29th, 2010
Re: report formatting
Reply #7 - Nov 18th, 2011 at 9:55pm
Print Post Print Post  
Any reason you can't set up a free PDF printer using something like DoPDF and print the report to that?

By the way, in Adobe Acrobat ver 9, Menu -> Advanced -> Document Processing -> Manage Embedded Index -> click Embed Index ... fully indexes a document with a high-speed index (works great on Sesame's User and Programming Guides btw).

In Acrobat or Adobe Reader Shift+Ctrl+F will display a list of all occurrences of the search term (versus Ctrl+F that just shows the next one).
  
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: report formatting
Reply #8 - Nov 25th, 2011 at 5:09am
Print Post Print Post  
If you really need it on paper, you could do a page set up of landscape and set scale to 60%, then "print" it to a PDF printer. Which will actually create a PDF file that you can give to the others, to print out on paper.

PDF995 is an economical choice for creating PDF files, but I'm sure some of the other users here will have many other good suggestions, too.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Re: report formatting
Reply #9 - Nov 28th, 2011 at 5:02pm
Print Post Print Post  
Sounds good Carl, however.......how do you set scale to 60% in a command??
  
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: report formatting
Reply #10 - Nov 30th, 2011 at 3:02am
Print Post Print Post  
debmckee wrote on Nov 28th, 2011 at 5:02pm:
Sounds good Carl, however.......how do you set scale to 60% in a command??

You wouldn't. You would do everything the same as you have been, except that you would print to the PDF995 printer, rather than to a physical printer. It will be listed as another printer along side your regular ones.

When you select PDF995 as your printer, you will be prompted for a filename, and the result is sent to that file instead of a real printer and paper.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged