Customer Report - Custom

Hello, I am hoping someone might assist me with a problem. I am trying to customize a customer report to show the Notes from the customer file. It has been suggested to me to run a query on this to pull the info I want. This is great, but not ideally what I am looking for. I want anyone in the office to be able to run the report and filter it to their specifications. For example: we have an anual catalogue and we do not send it to everyone on our mailing list. We want to send it to local customers who have spent money with us or who specifically request a catalogue. We have used up all of the custom text feilds for other info, so if we place a "note" in the customer file, "please mail catalogue" then run a report on customer notes feild and filter it to contain catalogue then we would have our list.

I know the Notes feild exists in the Customer Table, but when I try to add the feild to the report I get only an error message.

Any help would be appreciated. Thanks

Reply to
Evie
Loading thread data ...

Evie,

What sort of error are you getting? I was able to add the column to my .QRP file, than add that field to the list of report fields to display, and was even able to filter based on the contents of the field.

Bill Yater The Worth Collecti> Hello, I am hoping someone might assist me with a problem. I am trying to

Reply to
Bill Yater

Thanks for your response.

The error message I get when trying to run the report is:

Error reading report file C:\Programs ... \Memorized-Detailed Customer List.qrp at line# 728 FeildName = "Customer.Notes"

Any ideas?

Reply to
Evie

Evie,

Is this the real message you're getting? If so, the word FieldName is spelled wrong.

Otherwise, here is the column you need to add to your report;

Begin Column FieldName = "Customer.Notes" DrillDownFieldName = "" DrillDownReportName = "" Title = "Notes" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 2500 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Reply to
cptsoft

That's exactly what my column definition looks like. If you need to (don't know how long your notes are), you may need to convert this field to a fixed length. In that case, the following lines apply: FieldName = "CustomerFixedLengthNotes" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Notes" VBDataType = vbString Formula = "CAST(customer.notes as nvarchar(50))" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1395 GroupMethod = groupmethodNone ColFormat = ""

Jeff is right; check your spelling of the word "field".

Bill Yater The Worth Collection snipped-for-privacy@worthltd.com

"Jeff @ Check Po> Evie,

Reply to
Bill Yater

Thanks Jeff and Bill for your replies.

In my response to Bill, I typed 'field' wrong. I wrote it correctly in the report and the error message indicates the correct spelling too. I tried both of your solutions and they both returned the same error message I originally received (only with different field names in quotes, of course).

I know that it should work and it is very frustrating that it does not. Perhaps the problem is not the field name but something else?

Any ideas would be appreciated. Again thanks for your time!

Reply to
Evie

Why don't you just post you file? Follow the instrucions in Jeff's footer to connect to the group using outlook Express and add the file as an attachment...

You probably either have a syntax error just above the specified line, or you may have exceeded the maximum number of columns - I think you can have up to 40...

Glenn Adams Tiber Creek C> Thanks Jeff and Bill for your replies.

Reply to
Glenn Adams [MVP - Retail Mgmt]

Thank you Glenn,

You are brilliant!!! There were too many columns in the report. Once I removed one, it worked just fine!

Thanks again!

Reply to
Evie

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.