Recent content by paddydog

Hi Sheco, thanks for your post but that doesn't work for me.

I have a report that lists customers' transactions over 90 days, grouping and sub-totalling by customer to give balances over 90 days. Some of the balances / group totals are credits, i.e., 'negative' and I want to exclude these from my report. I have used a filter at the group level to do...

I've got my CR 8.5 disc, but not the install key. Does anyone know how to recover it from a PC it is installed on already?

For dates I've found that you have to set the properties of the text box as follows... Select custom & enter format "dd/MM/yyyy" I guess it is similar for currency. I found the best way to see what you will get is to test it in Excel: Select format -> cells and format it the way you want to...

I have a report which I need to send to a customer every weekday using a subscription, but without having to re-set report parameters each day. The report contains satellite 'phone call records; we receive and process the data daily and pass the information on to the end-user. The data has...

Follow-up: I've created a new, basic version of my original report and can now see the SQL statement it creates. Now I'm stuck again. I don't know what to do next. Should I be replacing the full statement with the following? And what should the 'Add' Type and 'Remove' Type bit do? create...

Mr vampire, I would like to try your suggestion - sounds promising - but for some reason the 'Show SQL Query' option is greyed out on my menu. Any idea why that might be? For info., CR version is Full Professional, would this make a difference. Re. you comment, the DB is SQL Server, my...

hilfy - thanks for trying, but that doesn't work either. I still get a detail section that has only one instance of the contract reference with the start- and end-dates (where applicable). Obviously I need a list of start- and end-dates with reference numbers attached. Are there any of the link...

I posted this in the formulas forum, but didn't get much joy. Thought maybe it was the wrong place to post it, so here goes... Using CR 8.5 and SQL database. My data is laid out as follows, e.g.: Reference No. Date Added Date Removed 00001 31/12/2002 15/05/2004 00002...

Madawc, Thanks for your reply, sorry if I wasn't clear. My point is that the way the data is laid out is preventing me from using groups. The references are contracts and the dates refer to start- and end-dates. There is no quantity field as such. If I group on start-date and count the number...

Using CR 8.5 and SQL database. My data is laid out as follows, e.g.: Reference No. Date Added Date Removed 00001 31/12/2002 15/05/2004 00002 01/03/2003 01/07/2004 00003 01/04/2004 00004 01/06/2004 01/09/2004 I'm...

BOB: Where do I find this HotFix?

We have recently implemented the "free" 5-user version of Enterprise that came with CR8.5 for evaluation purposes, etc. Seem to be doing OK for the most part, but one thing is confusing me: if you log on as a "guest" to run a report and then shut down the browser window, the system doesn't...

I don't know much about modems, please be gentle with me! At some point, my home PC seems to have become "infected" with one of these automatic expensive dialler-thingies, I don't know how or where from. All I noticed was the modem disconnecting and re-dialling. When I looked at the settings a...

I'm trying to write an aged debt report. I have two important tables: the INVOICE HEADER table and the TRANSACTION DETAILS table. The HEADER table contains the unallocated / unpaid amount of the invoice and DETAILS contains the sales analysis information. The is a many-to-one relationship...