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 am getting a message stating that "string length is less than 0 or not an integar" Should I have mentioned that to get my comments data I am using SQL expression field rather than just displaying a field? SQL is "get_blob(supplier.blobidx)" where you mentioned {your field} i used this SQL...

Thx, I will give it a go and let you know.

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

Sorry - based on the report currently it couldnt be displayed as the report is grouping by a higher level so showing the date wouldnt be possible. The format of the date direct from the db is date/time, however if was to display it I would just re format to dd/mm/yyyy. I am not sure if this...

thanks both for response. Ian - dont really understand this. I will have a play and see how I go. LB - the date isnt actually displayed, its only used to determine what data is displayed on the report.

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

Thanks so much. I have done this. Is there any way I can make the multiple services (that come from the sub report) appear beside each other, rather than under each other? Thanks again

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 am trying to get this code working in another query and not having much luck. I tried to embed within existing query. I think I just need help with the structure. select so.ofrom, o.sord_sordidx, o.sord_num, o.cust_code, s.style_stylecode, o.style_ref1_c as Brand, o.style_ref2_c...

Thanks it worked. Now I just need to get it working in my bigger query. Really appreciate your help.

1:M

Hi Dagon Thanks, but I removed what you mentioned and still get the same results (3 records instead of 2). Any other ideas? See code below: select s.num, al.AUD_DATE as changedate, al.new_value as newdate, al.old_value as olddate, m.memfull as whochanged from sord s, ap21log a...

Hi LKBrwnDBA, I did what you said but still get the same results as posted above. select s.num, max(al.AUD_DATE) as changedate, al.new_value as newdate, al.old_value as olddate, m.memfull as whochanged from sord s, ap21log a, ap21log_audit al, member m , refcode r where s.num in...

Hi taupirho, thx for your response. I am conncecting to an oracle db using golden 32 if that helps. Not sure how to do what you need and only have acces to query. Here are the results from that script, if that helps NUM CHANGEDATE NEWDATE OLDDATE WHOCHANGED 29895 09/03/2010 2010-06-07...