Search results for query: *

Hi, I'm hoping someone can help, because my knowledge of commands is severely limited! I have the following command, and all I want to do is remove the two parameter fields, datefrom and datetill, and replace them with the current date, the datetill parameter, and the current date -7 days, the...

Hi, I have the following formula: =SUMPRODUCT(--('DISPUTE DETAIL'!$J$5:$J$4999=SUMMARY!$CU1)*('DISPUTE DETAIL'!$X$5:$X$4999<>"S01")*('DISPUTE DETAIL'!$H$5:$H$4999<>"T702"))+SUMPRODUCT(--('DISPUTE DETAIL'!$J$5:$J$4999=SUMMARY!$CV1)*('DISPUTE DETAIL'!$X$5:$X$4999<>"S01"))+SUMPRODUCT(--('DISPUTE...

Hi, I've had a good rummage round the other posts, but don't seem to be able to find any help on this one! I have a cross tab that shows how long various queries, in days, have been in the database. Column heading: Query Status Desc (various status's) Row Headings: Dispute Type...

Hi, I have a cross tab report set up like so: QueryStatusDesc Total Dispute Status Sum@Days Sum@Days CountQuery.id CountQuery.ID Under the CountQuery.id total I want to add my own calculation, the average. Basically the figure for...

Hi, I'm currently using the following formula to work out the number of days between query status changes, here's the formula: datediff('d', previous({query_status_changes.date_changed}), {query_status_changes.date_changed}) The problem being is that this is apparently a summarized field...

Hi, I'm hoping someone can help me here, as I can't seem to get my head round what I should do! First off, I'm using SAP CR XI. I have to following fields and results: QueryID ChangeID QueryDate OldQueryGrp NewQueryGrp DateChanged 189 220 23/11/12 7...

Hi All, Have a question to ask, and I know its possible to export something out into something else, but I want to try and avoid that. Let me explain!!! I'm using SAP CR XI, and we don't have a crystal server, or anything else, just the reporting package. Is its possible to create a datasheet...

Hi All, I'm hoping someone might be able to point me in the right direction! I've done a cross-tab to show figures for various depts, similar to this below: Dept Total 0-30 31-60 A1 31000 7000 24000 B2 25000 2000 23000 GT 56000 9000 47000 Crosstab...

Hi All, I'm wondering if anybody can shed some light on this problem for me? I've created a crystal report using SAP crystal, and it runs fine with no problems when I use it in crystal reports, the problem occurs when I try and use it into another program, (OnGuard),so it can be used company...

Hi, I need to group on a sumarised field basically. Now I know this isn't possible as such, but is there a way round it?! I'm using SAP crystal, and have various fields, invoice, invoice number, dept, client number, invoice amount, and a few others. I want to basically sum the total of the...

Hi, I have a formula that I'm using in a group header, (customer number) to basically get the correct sum of a group of invoices. This is formula: if Count ({invoices.invoice_number}, {invoices.invoice_number}) >= 2 then Sum ({invoices.amount_open}, {@Customer}) / Count...

Hi All, Quick question! Apart from the conditional formatting, does CRXI for SAP have any traffic light system, or anything like it? I'm creating a dashboard and just want it to look a bit different rather than 'blocks' of colours, or coloured text! Any 'snaffly' ideas to make it look better...

Hi, Have a report that shows turnover by various groups. The groups are are follows: Overall - Company Group 1 - Branches Group 2 - Dept Group 3 - Customer I want to insert a graph into GF1 that shows a pie chart with the turnover by branch. When drilling down to the next level, GF2, by Dept...

Hi, I don't know if I'm going to explain this right, but I'll give it a go! I have a report that is based on invoice number, and has various other fields such as invoice total, days outstanding, query amounts etc. The problem being is that for each query / formula / different info in a field...

Hi all, I have a report that is currently driving me a bit potty! I have a formula field that SHOULD give an invoice amount if certain criteria are met, or not. Here's the formula: if isnull({query_status.id}) then {invoices.amount_open} else if {@DaysOutstanding} >= 90 and...

Hi, I know I'm missing something here, but don't appear to be able to see the wood from the trees!! I have a dead basic report that shows, ff4 (dept), invoice number, invoice amount, amount_open, standard_queries.code and a formula called TrueAmount. The formula field is a thus: if...

Hi, I need to rank a summarized running total, similar to how excel would use the 'rank' function. Here's my table, briefly: Area Volume of Invoices Value D44 8 6592 D02 12 75182 20 81774 The total column for the volume of invoice is a summarized field, this being the formula if...

Hi, Trying to write a query that will give me the number of days between the query date of an invoice, and the end of the current month. I'm stuck on the last part of the query: datediff("d", invoice.query_date, last day of month) Is there a piece of code in Crystal XI that will do this for...

Hi, General question really. I've looked through the posts on here about Crystal writing to an access database, but I can really find anything current. Is it possible for crystal to write the information from a report to an access database? I'm using SAP Crystal reports, the full version, if...

HI, I am trying create just a basic datasheet with invoice amounts, amounts paid, amounts outstanding etc. I've got the info how I want it, but the moment I introduce my query code field, the number of records drop, and only show those with a query field. How do I get them to show all the...