Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CARLEENHOP

    Using Value passed from sub report to main report in select expert

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

    Summary of Avg v's Running Total Summary of Average

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

    Select Most Recent date grouped by Each week

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

    Formula to sum transactions

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

    String Formula help needed

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

    String Formula help needed

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

    String Formula help needed

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

    Select statement pass paramter to a get statement

    ...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 table stores the blobidx, so I just want to pass it directly from the supplier...
  9. CARLEENHOP

    Distinct Record only wanted in formula

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

    Date passed to sub report

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

    Date passed to sub report

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

    Date passed to sub 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 -...
  13. CARLEENHOP

    Display data in one record

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

    Display data in one record

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

    Finding Most recent record

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

    Finding Most recent record

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

    Finding Most recent record

    1:M
  18. CARLEENHOP

    Finding Most recent record

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

    Finding Most recent record

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

    Finding Most recent record

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

Part and Inventory Search

Back
Top