Is there a way to remove the Auction ID column heading and the auction ID number from a Customized Invoice (using Reports > Printed Invoices > Standard Reports > Invoices > Customize)? All I want to do is keep that one column from printing.

By the way, did I mention that the Report Designer is beyond my comprehension, and that only on days when I've squirted WD-40 in through that little hole in my head am I able to make it do a single thing I want?

Thanks, Sue (on a day when my synapses need lubrication)

Sue,

You are hilarious Now that I have wiped the tears from my eyes------ Yes you can remove the Auction id field from the report.

Let me work on it for a bit and I will get back to you shortly.

Judy/blue

Sue,

When you choose the Customize option, look along the bottom of the report. You will see two different sections displayed.
One is "Main Invoice"
The second right next to it is "Sub-Report:Invoice Items"

click the "Sub-report:Invoice Items" little tab on the bottom. That opens up the portion of the report which is displaying the Auction id you want to remove.

click on the
Auction Id label so it ihas arrows on all four sides, you can then delete that label.

You will also want to click on the field that displays the actual Auction id number so it is also outlined with arrows. Then delete it. You should Preview the results in the Preview pane to be sure it is how you want it. You can re-arrange each little label or database calculation field by dragging them where you want and dropping them anywhere within the report band.

Does that help? Should I send more WD-40???

Judy/blue

I never even saw those tabs at the bottom. Typical, huh?

Ok, perfect instructions, and I got rid of the unwanted fields and then rearranged them like I needed, but......

I have yet to figure out how to do a SAVE AS. I don't want to open a new Report and start from scratch. How do I save my changes as a new Printed Invoice with a new file name?

I've read and reread the AW Help Files on this topic, but I'm still just lost. This Report Designer must be based on some program that's available separate from AW (yes?), so maybe there are guides written for old, gummed-up brains like mine. Does anyone know? And if not, I nominate Judy to write one and start selling it on eBay.

Thanks, Sue

sue,

In order to customize any report, the report is automatically saved as "copy of" in the "Custom Reports" tab right next to the "Standard Reports" tab. There is a "Rename" option.

click on the copy of x report in the Custom Report, then Rename it whatever you want.

Does that make sense?

Judy/blue

Not ignoring you. Just busy. Hope to fiddle with this tonight. Thank you Judy.

Sue

Sue,

I didn't think you were ignoring me at all. I am busy as well.

Judy/blue

Finally got a moment to try this.

Judy wrote: "the report is automatically saved as "copy of" in the "Custom Reports" tab"

I made the changes I wanted, closed the custom report (it's my regular package insert; Report Types: Printed Invoices), said YES to save changes, but found it had saved the changes to the original, one-and-only report. There was no "copy of" on the list. Luckily, before making the changes, I had saved a copy as an ARD file, so I was able to open that and undo the changes. After re-editing and resaving that one, both the customized invoices appeared in the Reports list, and I was able to rename the one I use every day. Maybe I misunderstood what was happening, but it sure looks like if you edit a customized Report and say YES to saving it, it saves the changes to the original, not to a copy (while the Report is open, its name at the top of the window isn't "copy of"). To test this, I reopened my new customized report (the one NOT saved as an ARD file), removed one letter from the title block, clicked File > Close, and got the box "Confirm Save changes to report?" I clicked Yes, got returned to the Reports list, and saw there was no "copy of" in the list on the Custom Reports tab. When I re-open it now, that letter is, of course, still missing. Do these custom Reports open as "copy of" only if they've been saved as ARD files first?

Anyway, now I need to know how to select an invoice for printing. Is it just a matter of moving them up and down in the Reports list --whichever one is on top is the default? Actually, I just tested this theory, and that's not it. And now, I apparently have my "missing-letter" invoice as the default. Help!

Thanks, Sue

P.S. It occurs to me it would be a LOT easier to just use some correction tape to cover up the eBay auction ID number when I need a non-eBay printed invoice. That would take about 3 seconds, whereas I've spent about two hours trying to figure out how to make the invoice print with just that one, little change. What lengths we will go to to make our programs do our bidding!

Sue:
I'm sure Judy will have a better way to select the invoice but here is what I do:

BEFORE printing the invoice (obviously) and while on the invoice tab click on

TOOLS/ Customize Printed Invoices

you get a box with all of your custom invoices. Click on the one you want to use and click on OK

The very next invoice you print will use that custom template. And every invoice after that will also use the same form. So if you use this method don't forget to go back and make the change to your ususal invoice after printing the one "different" one.

Hope this helps

Garry

Sue,

I'm sorry if I have to ask a few questions to clarify the problem.

Did you go to Tools | Reports | Printed Invoices?
Enter in the Invoice for which you are going to print an Invoice for.
Use the Customize button.
AW2000 will tell you you cannot customize a Standard report and will make a copy. Do you want to proceed? And you click OK.
The report that opens in the Designer Window should be the "Copy Of" whatever report you are attempting to customize. The changes you save when in the "Copy Of" are saved to that particular copy.

Am I on the right scenario? That you used

Judy/blue

This is what I was looking for (had thought it was in File:Program Options). I think it might be the way, as in the only way to select which invoice to use. Thanks Garry.

Sue

Sue:
You're welcome Glad I was able to help. I remember the first time I had to do that - I too went to Program Options and searched it until the letters wore off the screen.

Garry

Don't apologize. I expected to need to clarify some things. It's not easy to communicate this way. Chatting in the same room while both peering at the same screen would be a whole lot easier, wouldn't it? :)

I went to Tools | Reports | Printed Invoices | Custom Reports tab.

I selected the Invoice I wanted to edit and clicked the Customize button.

AW2000 does not tell me I cannot customize it because it's already a Custom Report.

The report that opens in the Designer Window isn't "copy of" -- it's named as I named it. I think the "copy of" editing is available only in Standard Reports. I think you assumed I was starting there, but I already had a Customized Report that I wanted to tweak just a bit. I can't see a way to do that without first doing a Save To File, or starting "from scratch" with a Standard Report and trying to duplicate all your previous customizations.

Sue

Sue,

Got it. Yes I presumed you were starting from a new Standard report and not an existing customized report.

You can further change your report if you want. I edit and save mine all of the time. However, I do often make another copy just in case I really screw up something I have messed up the new "copy of" instead of the actual one we use all of the time. After I am sure I like the changes, I will re-do the original customized report.

Looks like Garry got you going in the right direction.

You should be good to go????

Judy/blue

Garry wrote: "...until the letters wore off the screen."

I like that! I can picture you sitting there and getting bleary-eye while the letters start stretching and sliding off your monitor. I know that feeling -- like if you just open your eyes bigger and blink a few times, some button or drop-down box will appear from out of that field of gray fog.

Sue

Sue/Judy

I think that "copy of" only works with one of the original templates that come with AW2K. If you edit one of your customized reports it does not do copy of. I may be wrong but that's the way I've see it work in the past. Not only in AW2K but in other programs I make it a standard practice that before editing anything I save as the same file name with an X at the end. That way when (notice I didn't say if) I mess up I still have the original. Then when I'm done and happy I delete the "x" file - umm no pun intended. Or I delete the x and type original if I wish to keep it. Long and involved huh?

Garry

Not so fast, missy!

Judy wrote: "I edit and save mine all of the time. However, I do often make another copy just in case I really screw up something I have messed up the new "copy of" instead of the actual one we use all of the time."

HOW?? From this window:

http://members.dslextreme.com/users/emailshere/AWReportsWindow.jpg

...how do you make a just-in-case copy? How do you make a copy of one of your already-customized Reports?

Sue

Sue,

Okay, okay, okay. so I won't slide outta of here

First, I will create another customized copy by Saving the original to a file, then reloading it back from the same file. That makes another exact copy so I can mess with it. After I have edited the exact copy that I saved to a file and then Load from file, I can do one of two things.

I can elect to Save the copy I was just messing around with and edited to a File and then Load to file again and rename it the same name, delete the old one.

Or I can go into the original report and make the same changes.

From the window you sent the link to, IF you are wanting to use the "Save to File" as the method to make another exact copy, then use "Save to File". Then load from file will make a copy of "non-eBay Invoice (1)" So you can edit that one. You have to highlight the "non-ebay Invoice (1) and click "Customize" in order to access the Report Designer Window. Make the changes you want and save the changes.

Does that make sense?

Judy/blue

That's it! I did the Save to File, then reloaded that one, and it shows on the list with a (1) next to its name. Perfect!

Thanks a bunch, Judy.

Sue

Sue,

Cool! You'll love being able to do that. Works like a charm.

Judy/blue