1. Home
  2. Point-Of-Sale Software
  3. Report Assistance

Report Assistance

I recently wrote a report that shows first time customers and the amount of their purchases. I'd like to add a COUNT of the customers to the report - ie:

54 new customers should show "New Customers - 54" at the top of the report above the details of the 54 customers. I've tried adding a "GROUPS = 1" in the ReportSummary section - no luck. I even added another column called COUNT with a formula of "0 + 1" with a GroupMethod=GroupMethodSum, but when I do I get breaks for each customer which I do not want (makes the report look like crap).

Can anyone HELP? Can anyone shed some light as to the syntax for some of the programming in the report file. The "hit or miss" method of having reports come out the way I want them to come out is growing old.

Thanks (in advance).

Reply to
Luminox
Loading thread data ...

Make sure that you drag the Count column you created all the way to the left (so that it's the first column in the report), then set your grouping to 1 column. This should give you a single header labeled "Overall" with the sum of the counts, then I believe another Header with the Count Value 1, then a line for each detail record (the customers). It sounds like you have the customer name or account as your left most column, causing you to get a group break per customer...

Glenn Adams Tiber Creek C> I recently wrote a report that shows first time customers and the amount of

Reply to
Glenn Adams [MVP - Retail Mgmt

Glenn,

That does work but now you have the first column of the report with all 1's in it. It would seem that even if my "count" column is the LAST column in the report if I add a GROUPMETHOD=GROUPMETHODSUM that it should show up at the top of the report irregardless of whether I specify GROUPS=1 in the ReportSummary.

If the report language is so similar to SQL how come there isn't a GROUPMETHODCOUNT statement?

Is there someplace online (or a BOOK) where we can learn more about writing our own reports?

Scott

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
Luminox

There's a customization guide - you've seen it mentioned before I'm sure. Microsoft has designated that a Partner resource, so it's only available to resellers.

There is a groupmethodCount. You may have some other issues that are preventing it from working for you. Remember that it is just counting the values in the column (basically anything except NULL). You can't use it in the report header like you originally wanted.

Grouping by a column that has the same value on every row results in a single group rather than a group for each value. This is preventing the group for each customer that you didn't like...

You might want to explore SQL Server 2005 Express Advanced Edition. This version of express includes SQL Server Reporting Services and there are *plenty* of online and print resources for using that...

Glenn Adams Tiber Creek C> Glenn,

Reply to
Glenn Adams [MVP - Retail Mgmt

Reply to
Luminox

It won't count anything unless you have at least 1 GROUP. If the first column is Account Number, you will have a group PER ROW as that is a unique value. None of the group methods work on string values (Account Number is a string even if it happens to be numeric). You could change the SUM to a COUNT on your added column and it should produce the same result (because all the calculated values are 1).

Glenn Adams Tiber Creek C> If I understand you correctly there IS a GroupMethodCount? If so, then I

Reply to
Glenn Adams [MVP - Retail Mgmt

Glenn,

That does work but now you have the first column of the report with all 1's in it. It would seem that even if my "count" column is the LAST column in the report if I add a GROUPMETHOD=GROUPMETHODSUM that it should show up at the top of the report irregardless of whether I specify GROUPS=1 in the ReportSummary.

If the report language is so similar to SQL how come there isn't a GROUPMETHODCOUNT statement?

Is there someplace online (or a BOOK) where we can learn more about writing our own reports?

Scott

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
CptSoft

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.