Search results for query: *

Good Afternoon. I hope all is well. I am using Cystal 2008. How do i bring back all transaction details which include product code: 5001, 5005, 5010, 5015 for example transaction 1 5001 (kit kat) 5503 (mars bar) transaction 2 5005 (m&m) 5001 (kit kat) 2015 (coff8e) So all transactions that...

Hi Guys, I hope you are well. I am trying to create my own groups within Crystal based on a set of sales trasactions. My aim is to count the occurances my employee sells a promotion. For example: If a customer buys 1 or more kit kat and 1 or more salt and vinegar crisps, i need to count...

Good Day, I am attempting to create a cross tab that shows me the number of times a product is sold each day. I have been trying to achieve this via a two step process. Firstly I create a simple cross tab by showing the follwoing 01/01/13 02/01/13 03/01/13...

Hi All, I am using Crystal 2008 and am trying to use a running total which groups the number of items sold each hour. Currently it shows dates down the sides and hourly slots across the top. 0400 0500 0600 0700 0800 .... Total 20/04/2012 2 3 2 5...

Hi All, Is there a way of calculating the difference in time between each transaction and displaying it in the detail of the report and then working out an aveage and display it in the group header. Dannyb

Hi All, I am using Crystal Reports 2008 and I was wondering whether there is a function that enables you to join tables using raw SQl. As far as I can see, I can only use the Database Expert which is quite limiting in some ways. Can anyone shed any light? Dannyb

Hi all, I am in the process of trying to create a crosstab showing tht total cost and retail values the latest transaction (this is distinguished by time) I have grouped the information to show you what data I am working with and the results I need to capture in my crosstab Esaxmple one...

Good Afternoon Everyone. I am trying to create a formula which is based on a group on my report. The formula doesn't generate any errors, but it is not working as it it should. Could you help me and advise me where I am going wrong? IF{ProductGroups.Name}="RCP" then Sum...

Hi All, When creating a crosstab, is there any way of ignoring the grouping so that each record albeit the same information appears on every line? For example Date User Product #QTY Sold 10/10 1541 1000 1 10/10 1541 1000 2 10/10 1541 1010...

Good Afternoon all. Would you be able to help me with what should be a simple formula. I am trying to divide the results of two fomulas to calculate an average to then place in a crosstab. Formula 1 - This is a DstinctCount in the crosstab if {AVBRecordTypes.Description}= "Delivery Acceptance...

Is there a way of displaying each record in a row even if the results are the same within a crosstab? At the moment it only changes at the change of each record. For example curently the crosstab shows: Birmingham 03/10 04/10 05/10 Bristol 03/10 04/10...

Hi All, I hope you are well. I am having difficulty in expanding on the formula below. I need to include a distinct count within the formula. Can anyone help? I need to distinct count the Order ID if the description ="Confirmed on train" if{OrderStatus.Description}= "Confirmed On Train"...

Hi All, I am trying to work out how you distinct count the number of days between a date range. For example: 10/08/2011 00:00:00 to 12/08/2011 23:59:59 = 3 days. Thanks x dannyb

Hi All, Is there a formula that I can distinct sum a value in a record. For example: Group 1: TransId 1010 Sales Value 2.00 TrnxId Product Product Price Sales Value 1010 biscuit 0.50 2.00 1010 coke 1.00 2.00 1010 orange 0.50...

Hi All, I am compiling a report that highlights how staff complete line checks. I need to highlight any line check that are all equal to the same quantities. The psuedo code in my head would read something like this: If{ProductsSold.Quantity} all = 0 highlight{ProductsSold.TxnId} in RED or if...

Hi there! Would someone be able to help me with a formula that will enable me to group days of the week for use in a sales crosstab report. The column display also needs to be the word, "Monday,Tuesday..>" The date field is as follows: {ProductsSold.ActionDateTime} Many Thanks in advance

Hi Guys, Can you help please. Crystal is having problems dividing by 0. Is there anything I can do? I have 3 formulas: First one: @null This formula is blank Second One: @Del Received if {AVBRecordTypes.Description}= "Delivery Acceptance from PDA" then {AVBTransactionLog.TxnId} else {@null}...

Hi All, Is there a formula i can use to change the format of a product code (number) Example From: 2,100.00 To: 2100 For some reason who ever created the database did not do this from the out set. Many Thanks

Hi All, This should be so simple but i cannot for the life of me get this Crystal formual to work. DistinctCount ({AVBTransactionLog.TxnId},{Users.LoginName}) where {AVBRecordTypes.Description}= "End of Shift" Please help if you can x

Good Afternoon, Can anyone help me with a formula to convert a date field. From 15/01/2011 12:00:01 To 110115 Thank you!x