Search results for query: *

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

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

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

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

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

thread767-1634738 In the above thread, lbass helped me get comparison reporting working so I could show comparisons of sales in a week number in Year 2010 against the same week number in 2011. However, now its 2012, the data selection formula below has stopped returning any data for the...

I have a report which is run automatically at the end of every month. The report criteria uses the date selection 'monthtodate'. However, some of the formulae in the report need to use some form of date call that references the last day of the previous month. Currently I have tested the...

Hi I'm working on a simple sales report showing sales in the YTD period vs the Prior YTD (PYTD). 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 starts February 1st each year, as follows: {@Fiscal Year} if Month...

Not sure if this is the right forum for this, but here goes: I am trying to write and SQL expression to do a server-side calculation to establish the week number from a given date in the database. In SQL, it'd be easy: {fn WEEK("peranal"."pa_date")} but I'm working against an Informix...

Hi I am working on redesigning a sales report so that in addition to the current weektodate sales, it shows alongside the same week numbers sales from last year. I'm sure I could do this by formulas, but I have experimented with the datepart function, so as to get week numbers etc, but my...

Hi All I'm no stranger to nested IF commands, but am having trouble with one that I need to test multiple values. The current simple command is below, and works fine. if {prodmast.pm_ptyp} = "10" then if {peranal.pa_prod_cd} like "GMAN*" then (tonumber("0")) else...

I am working on a sales report where I need to show all sales made which contain products by a certain supplier. As our database stores a record for each line on an order, this is straightforward, and I have grouped the order lines by order number to show a summary of lines by the supplier for...

I have two tables that I have linked together. One holds footfall data through the shop door, so there is a footfall total for every day of a given month. I have linked it to the sales data table by date, using an = non-enforced LEFT OUTER JOIN as I need to show the footfall for every day and...

I am designing a report that shows customer service callout summaries. The data is well structured into various tables that link together fine. I am now up against a problem where the text typed relevant to a given 'memo' on the customer service record is broken into lines and stored in a...

Hi I am working on a report based on a series of tables from a CRM system. My problem is how to show easily on a report the analysis of what parts of an order are faulty and why. There are 3 tables that are relevant: csc_item csc_itemfault csc_faultcode csc_item lists the singular item that...

I have been trying to use a formula to build a new string value on a report in CR2008. The formula is: if (Left ({prodmast.pm_unit_type},2 )="26") then "2'6 (76cm)" else "NA" However, while this works, I really need to add a " after the 2'6, so it reads 2'6". However, if I simply put one in...