Search results for query: *

Hi, Thank you all for your help, but the results only bring back the selected items and not the items that were purchased alongside them. Do you have any other solutions? Dannyb

Hi, Thanks but this only brings back that particular record. If the transaction containing one of the specified products and contains other items i also need to show the additional products, but only if the transaction contains products from my original list. 1 transaction can contain many...

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 Skip, Thanks for you quick response. There is no promo table, which is why i am trying to create my own promo groups manually. Painful process :( thanks D

Hi SkipVought I am currently working with 6 different promotions, but as you rightly asked, this could increase as the months go by. Also yes I would like to count the transactions if there are more than two items as well and group that as a separate group so that would increase the number of...

Hi, Yes there are multiple records for each transaction. Here is a data sample: TransactionID: Product code: Product description: Qty: Staff ID 101 20500 KitKat 1 5021 101 20501 Crisps 2 5021 TransactionID...

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

Hi, I am trying to count the number of times the 'sum of the quantity sold' occurs So if over a period of time there were 6 occasions out of 10 which we sold 50 coffees, the crosstab would show 10 20 30 40 50....qty sold # of times we sold 'x' coffees...

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

MCuthill - The datediff() only calculates the dfferents in dates rather than time. Lbass - I am not familiar with subreports, but I think I have followed your instructions correctly. I have got to point where I add the code to the: section expert-> details ->supress(no drill down)-> x2 but it...

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

Dohh..School boy error! Thank you so much!

Sorry, its this set of code: SELECT "AVBTransactionLog"."ActionDateTime", "AVBTransactionLog"."RecordType", "AVBTransactionLog"."SuccessFlag", "AVBTransactionLog"."OriginatingTxnId", "AVBTransactionLog"."AVBUserId", "AVBTransactionLog"."AVBMachineCode", "AVBTransactionLog"."PVN"...

Sorry I forgot to add the first part, but it is still throwing up errors. SELECT " AVBTransactionLog"."ActionDateTime", " AVBTransactionLog"."RecordType", " AVBTransactionLog".."SuccessFlag", " AVBTransactionLog".."OriginatingTxnId", " AVBTransactionLog"."AVBUserId", "...

Thank you very much for that. I have tried writing a piece of code and it is throwing up errors. Am I missing something? Here is my code. SELECT FROM [OCMPhase2_Report].[dbo].[AVBTransactionLog] FULL OUTER JOIN [OCMPhase2_Report].[dbo].[AVBTransactionLogDetails] ON...

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, The column would be date, and the summarised fields would be Total Cost and Total Retail Price. This total would be dependant on the latest/maximum time. Dannyb

Hi Ibass, The SQL query is as follows: SELECT "AVBRecordTypes"."Description", "ProductsSoldPd"."ActionDateTime", "ProductsSoldPd"."ProductCode", "ProductsSoldPd"."ShortDescription", "ProductsSoldPd"."Quantity", "ApplicableTrainDates"."DiagramId", "ProductsSoldPd"."CostPrice"...

( Select max(B."ActionDateTime") from "ApplicableTrainDates" A, "ProductsSoldPd" B where A."Date"=B."ActionDate" and A."RetailServiceId"=B."RetailServiceID" and A."Headcode"=B."Headcode" and A."DiagramId"="ApplicableTrainDates"."DiagramId" )