Search results for query: *

Is it possible to Schedule a report to run at a given time and write to a specified file in CR 8.5 or is that only a feature of newer versions????? [ponder]

Using Ms Project 2002 I set up a custom formula in Number format, it all seems to work fine but I just need it to go deeper than 2 decimal places. Can anyone suggest a way to add decimal places? My formula looks like this (an "if" to avoid the annoying #Error with the Div/0 scenario) (Number 3=...

Hello All, I am trying to do an INSTR (unless someone has a better suggestion) The reference field combines several values that I need to isolate SELECT MS.IDENTITY, MS.INVOICE_NO, MS.CODE_A, MS.REFERENCE FROM IFSAPP.MAN_SUPP_INVOICE_POSTINGS MS WHERE MS.CODE_A IN ('5050','5051')...

I have a field that contains date/time info but I need to convert it to a legible date time format. It is formatted like '20051206135428' and I would like for it to read 12-06-2005 01:54.28 pm (mm-dd-yyyy hh:mi:ss) or I could even drop the time and say mm-dd-yyyy. Whichever is simpler. Any...

CR Verson 8.5 I am struggling with the Drill Down Headers. When I get to the 2nd Drill down i can't get the headers to work like I would hope. I am trying to get the title info over the detail section of drill down (2nd drill) without having it show over every result Maybe someone can help I...

I am trying to 'extract' if that is the correct word, a portion of a description for a field, please see example. here's my simple statement: select hla.LOG_ID, to_char(hl.TIME_STAMP,'mm-dd-yy')Chg_Date, history_log_api.Get_Description(hla.log_id)Part_Desc, hla.OLD_VALUE...

This is a newby question, but can anyone tell me how to get the current year? There are simple ones like CURRENTDATE which shows today's date, but how do I isolate the year from the current date?[roll2]

I am working on a report that is tricky for me. I am sure there are many of you out there that could help. I am trying to identify the Minimum number of a given part number and not the min of the whole column Parent_Part Jr_Part_Number Qty Min 20-000 20-111S...

I am working on a report that allows the user to define the information they receive. Normally that is not a problem when I use "like", "between","=","<",">" etc... but I am trying to use "in" so they can enter multiple items separated by a comma and also enter a nvl if the space if blank. I...

I am working on a report that allows the user to define the information they receive. Normally that is not a problem when I use "like", "between","=","<",">" etc... but I am trying to use "in" so they can enter multiple items separated by a comma and also enter a nvl if the space if blank. I...

I might be dreaming on this one but I have to ask. Is there a way to make comments or something for the fields in my report. Or some way to make a legend for the report data fields. for example my report has fields like Open PO Open CO Open SO Last Q1 This Q1 and be able to explain further...

I know this is the formula forum but you all are Champions and think someone out there can help. I am trying to print a string of Labels Using CR 8.5. The labels are on a roll so there is no page separation between labels. When I try to print the labels it will print 1 page worth on the labels...

I am trying to print a string of Labels Using CR 8.5. The labels are on a roll so there is no page separation between labels. When I try to print the labels it will print 1 page worth on the labels, then a page off, and then back on. I would guess it has to do with page setup or something. Does...

I am trying to create Barcode labels with Crystal Reports 8.5. I am about to purchase a barcode font program but I am trying to make sure everything will work first. They are receiving labels to go on our cartons. If I enter a PO#, it will print a label for each of the items on that PO. I have...