Recent content by petejigsaw

Thanks lbass - that works a treat! I was on the right lines, but was trying to do it via group supression, rather than as group selection.

Hi I have been struggling for several weeks on a report that I need to get finished, yet just can't get to work as it should. Essentially, I am trying to work out how to suppress a group based on the presence of BOTH specified values in the details section. Here is some example data, showing...

Hi lbass Brilliant!!!! They all work as expected. One final question though - how do I do a report total (i.e. all branches)? Many thanks :-)

Hi lbass Yes, there is only one salesperson per order. The report groups are: Group 1 - Branch Group 2 - Salesperson Group 3 - Order Hope that helps. Many thanks

Thanks lbass However, while that works at {order} level, I still need to be able to SUM or COUNT the 'maximum({@protector},{Table.order})' across all the salesperson's orders, so I can calculate a conversion rate per salesperson, as well as per order. Any ideas? Thanks

Sorry Kray4660 The data didn't look like that when I entered it! See below hopefully a better layout. This shows the details set-out in the initial post. The essence of my issue is that for orders such as 303066752, I need to be able to show a COUNT or SUM for the order that equals 1 for...

I am preparing a report to test add-on sales. The report pulls all qualifying product lines of the base product, plus all associated add-on sales where there were any. The report is grouped by pa_order_no and then has a summary for each sales rep. I have a DISTINCTCOUNT for pa_order_no for...

I am revising an often used report for marketing purposes, but have an issue with the address fields. Our database stores addresses based on the following fields, with: {cusmast.cm_address_1} {cusmast.cm_address_2} {cusmast.cm_address_3} {cusmast.cm_address_4} {cusmast.cm_address_5} When...

Thanks Pete That works a treat! Is there a simple was to use another parameter to allow the user to enter the number of earlier years to show on the report and use this somehow in the formula? I've tried a few ideas, but without success..... :-/ Thanks in anticipation. Peter

I have a simple report which pulls back sales and associated data for two user specified periods. It is currently set-up with 4 date parameters - a start date and end date for each period: {daily_summary.summary_date} in {?Start Date} to {?End Date} or {daily_summary.summary_date} in {?Start...

I am working on a report that uses two tables from within the same SQL 2005 database. The database is set to CI (case insensitive), but when I add two of the tables to the report, link them on fields I know should work, I get this error: Failed to retrieve data from the database. Details...

Thanks Madawc Since I posted the original query, I've now successfully created an additional field in the two relevant tables, so that I can link them directly without needing to use a subreport. This means that every product code at every store now has a detail value for colour. However, my...

I have a report which lists stock on display within a group of retail stores. I have grouped the items based on their product code, so that there is one line for each product code, and used a if/then formula to put either 1 or 0 into the respective columns across the page for each store, to...

And just to clarify, {peranal.pa_date} is a DATE field, rather than a DATETIME field, which I think may be the issue?????

Thanks pmsawyer I've created all the formulas you outlined, and understand how they all link together. However, I'm stuck at the stage of how to use @CurrentDateRange and @PriorDateRange in record selection. If I try to pull records where {peranal.pa_date} is equal to @CurrentDateRange or...