Search results for query: *

Hi I have passed the value ok from sub to main report, however I then only want the main report to show where this value = 0. However it isnt an option in select expert? Can anyone help how I can achieve this? Thanks

I have created an average of a products margin using a running total and displaying it by a grouping. I have also created an average summary of a products margin on its own and displayed it by these groups. However some of the values are slightly different. Not by much, but I dont understand...

Hi I have orders that get ammended, I am trying to extract the order details for the most recent ammendment. I have been able to do this by grouping via the order # and then entering: "{AP21LOG_AUDIT.AUD_DATE} = maximum({AP21LOG_AUDIT.AUD_DATE},{SORD.NUM})" under the group selection...

Hi, I am using crystal reports 11.5. I have two tables which store similar data, however neither of them store it in a way I can extract what I need. E.g. a stock adjustment is posted, and it posts a variance, if > 1 product on stock adjustment it posts a variance to > 1 account. So if I just...

I have a comments field that i am extracting from. I have set up the structure of these comments with a name and '-' as each of them relate to specific information that I would like to extract in crystal and isolate. eg. name - xxxxxxxx size - xxxxxx colour - xxxx What can i use in crystal...

Hi Using Bethnic golden32 connecting to oracle db. I have a supplier table which as a blobidx. All i know is to get the details of this blob i run the following (specifying the blobidx: select get_blob(blobidx) from dual; **Change the blobidx to the number you are inputting My supplier...

using crystal v14 - connecting to db via orcacle db connection. Detail section record has order #, style, colour and date and qty. I have a formula which determines the date difference in todays date and the field date. I then display the information in columns based on these date differences...

Hi I have a date in my main report which is being passed by 3rd party software that interacts with crystal. This works fine. I then need to pass that date period to my sub report, but not match it to the same field. It needs to match another date field in my sub report. E.g. Main Report -...

Hi , I am using crystal v11.5 connecting to an oracle database. I have a style which has many services and 1 proudction order. I want to display one record for each style/production order and somehow concatnate the services, so I can show all the services in one cell against this record. At...

Hi, I have a few tables of which I am extracting data. It is an audit table. For each sales order I want to see the most recent change. I can currently see all changes for the order but not the most recent. I have tried to use the max function but this only works if I only select the order #...

Hi Just wondering how you do an if statment. I am using golden bethnic 32 and not sure what version of oracle database. I want to say if a field = a certain value then another field must = a certain value otherwise that other field must = another value to return the results. I hope this makes...

Hi, using crystal 11.5. I am currently gropuing a report by suppliers with a distinct count and sum of a qty. These suppliers have another table attached which defines the type of supplier. Where a type = a certain criteria I want to display this is one supplier as such, include the distince...

HI I have a few tables. I am using Golden32 to write the SQL and retrieve from oracle database. I have a table which I want all records to be displyed from irrelevant if there is data in the joined tables. I have a table that this joins to main table where I want some data only when it...

Hi Using crystal v11. I have a 3rd grouping where I display data. This shows if an order was received or delivered. Where delivered I have 3 columns to show if ontime, 1-2 days late or later. This is based on the date difference between the order date and the charge date. In the 3 columms...

Hi Using Crystal v11. I want to get a total which i need to to a distinct count on a field where another field = a certain criteria. E.g. if Sord.typ = 1 then distinct count sord.num. I am currently grouping by a couple of different levels, plus sord.num and sord.typ. I need to display my...

Hi I am setting my crystal report up in an external program where the user runs it from. I want to be able to print the report heading based on either a)the criteria the user enters or b) the name the user saves the report within the external application. Either way I am not sure how to...

Hi I have a date field (due date) which I have created a formula to turn the date into a month (firstly number) then turning that number into a name. I have done this so I can group by month on my report. However when the due date is the same month within my existing grouping but has different...

Hi I have 4 groups. I want to make sure group 2 -4 do not split across pages. I have tried all the options unders section expert but no luck. can anyone help? thx

Hi i have a report with some date and qty values (invoices). I have a sub report with some date and qty values (orders relating to invoices). i can view the order information from these invoices via the subreport. However I want to create some formulas to compare values from each report...

Hi I have a distinct count on one of my fields by a grouping and I want to sort the data from higest to lowest based on this count for my selected grouping. However it is not an option to sort by this summary? I tried creating a formula to replicate the summary and then sort by the formula...