Search results for query: *

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...

Ah, I see. I could create another table in a parallel database, with calendar details in it. So if that's going to help, please point me in the right direction. However, as this is a simple report with only one table of data in it, I'm keen to keep performance as snappy as possible. Thanks

Hi briangriffin I'm afraid not - I'm reporting against our retail system's main database, so creating additional tables isn't an option. Thanks for the suggestion though.

Hi I'm still, after almost a year, working on a simple sales report showing sales in the YTD period vs the Prior YTD (PYTD). Our year end is 31 January each year. I am using Ken Hamady's fiscal year formulas to calculate whether a date falls into the YTD or PYTD period, where the fiscal year...

I am working on a report to pull pricing data from a table. The table contains records of pricing data for each product, as follows: Prod_Code Promo_No. Effective_Date Price BERGCHSTBROW 444 299.00 BERGCHSTBROW 001 01/10/2011...

Hi Using CR2008 I am preparing a report listing invoice values, where each invoice has the total broken down into several 'detail' lines by nominal code. The report groups all 'detail' lines by 'invoice number', but I need to suppress groups based on testing the values within the group. As...