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...
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...
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...
Addition to my last post: when I re-read what I just posted I realised the second ageing formula was in fact different. I've changed it taking out the sum/array bit and it is now available for use in record selection (although I don't need it). I've tried browsing on the Division field data and...
Re. the field types: they are formulae. The one I want to use in particular pulls a shared variable from a sub-report and looks like this...
WHILEPRINTINGRECORDS;
SHARED STRINGVAR DIVISIONCODE;
DIVISIONCODE
and returns a string which looks like this: "R10-","R30-", etc...
I want to use one my the report fields in record selection, but when I open the record selection formula editor, the field is not there. Some fields are and others have disappeared. This seems to have happened following my machine crashing. Is there any way I can retrieve / refresh what is...
Oh, and for clarity, the SOURCE / RESERVED / INVOICED items are not part of the actual data - they are the results of 'if' formulae based on various bit of each record...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.