Recent content by Jtreshan

I have a report in which uses running totals of work done by certain agencies. In one week's report, because no work was done by a particular agency, the formulas for totals by that agency which are calculated by subtracting that agency's numbers from the total numbers shows a blank (because no...

I'm working on a report in which I need to select records for items which are in my facility for work. I need to establish a parameter with which I can select a range of dates and then calculate how many days an item has been in the facility, without counting non-work days (weekends and...

Sorry, now I think I see the problem. You have to join and sign in before you can start a new thread.

Type Seagate: Crystal Reports in the Find Forum space (just below the signin block), then click GO. Once at the forum, you can start a new thread either by clicking on New Thread at the top right of the page, or scrolling down and filling in the bottom.

Sounds like a "Set Print Area" problem in Excel. Highlight the part of the spreadsheet you want to print, then choose File, Print Area, Set Print Area. Then go back to Page Setup and try clicking on the bottom (1) by (make the second number large). Then look at Print Preview and see...

Could be a printer problem. Why not try modifying the jpg image (for example by decreasing blue and increasing red or some other obvious change), and then see how the printed image looks.

I use The Complete Reference Crystal Reports 7, written by George Peck (comes with a CD-ROM containing Seagate Analysis and Seagate Info 7. The copyright 1999 edition is available from the on-line bookstores for about $35. I took a quick look at the help on Maps from within the program, and it...

There's a chapter on maps in my Crystal Rep;orts 7 Complete Referenc book; however I have not used the function. Apparently you start with Insert\Map from the pull-down menu or click the Map icon on the Genral toolbar to access a Map Expert. Haven't looked at the Help in the program for this...

You do this by creating a parameter field (name it report dates or something else appropriate).  For the prompt, put something like "Enter Date Range".  After creating the parameter field, insert it into the report, and then when the report runs, you will be...

I downloaded the latest version of Seagate<br>Analysis to see if I could fix a problem I <br>have with a Crystal 7 Report.&nbsp;&nbsp;My report <br>selects many records, but then limits those<br>which appear in the report by a formula I<br>have inserted in the Format Section (details), which...

My apologies is this sounds like a simplistic answer, but it sounds as if you do not have<br>any printers installed.&nbsp;&nbsp;Go to Start, Settings, Printers, and see what is in that box.&nbsp;&nbsp;If<br>there is nothing but an Add Printer icon, that's the problem.&nbsp;&nbsp;Double click on...

If I modify the formula so that Previous {fieldname} is not equal to ({fieldname}), I get all the duplicates, which is the opposite of what you would expect.

Last post was incorrect.&nbsp;&nbsp;The formula I'm using is<br>If Previous ({fieldname}) = {fieldname} Then True

I understand that I need a formula to exclude duplicates, and I thought that's what I <br>put into the selection formula, which now reads If (field name) = field name, Then True<br>I think I need help creating a better formula than that (the field name I'm using is<br>the one name in the report...

Sorry Cody, I was a bit premature.&nbsp;&nbsp;The report now selects the correct records; however, the subtotals and grand totals of number of items in each area, and hours in each area are too high (I presume because even though using your formula I can prevent the records from showing in the...