Search results for query: *

Hello, We are looking for a location to host Saberlogic's Logicity Solution Builder to run Crystal Reports (XI) at scheduled times. One suggestion has been to host LSB on one of our virtual servers and schedule these tasks outside of business hours. The questions that have come up are:What...

Hello, We currently have a blend of Crystal Reports versions in our corporate environment. CR8.5, 10, and XI. We're going to be upgrading from XP to Windows 7 in 2011 and are about to standardize the CR version to XI as it is Win7 comaptible. CR 2008 is 4 years old. Does anyone know if there...

Hello, Is anyone in our CR community aware of a barcode font that displays the barcode's alphnumeric value above the barcode instead of below? I'm currently using 3 of 9 in CRXI and the location of the barcode's numeric value is obstructed (by client process). Client does not wish to move...

Hello, Using Crystal Reports XI. Am trying to create the following format in a report. The data comes from an Oracle database table. I have a list of digital images, each its own “microfilm id” scanned in batches. The batches are reviewed and at times some images deleted and rescanned at a...

Hello, Our business uses Crystal Reports XI. I’m hoping someone here has done this already and can assist us. We require 2 barcode printing scenarios. The first one which is completed, prints barcode labels pulling a coverage number from an Oracle database and prints the coverage number as a 3...

Hello, We’re using CR8.5 with an Oracle 9.1 DB. I’m using an Oracle view to pull a dataset which lists records based on opened & closed actions. Each action has a date & time associated. 1.) I would like to determine the time interval between the open & close actions. The date will be the same...

Hello, One of our clients with a new CR XI installation (with CR 8.5 sp3 on the same machine) produces reports (in either version) and on trying to email them, receives a MS Outlook error: "Either there is no default mail client or the current mail client cannot fulfill the message request...

Hello, I have been asked to capture all employee name changes for the last 5 years and I’m a little lost with the PL_SQL required, or if this info can be retrieved using a Crystal formula. We have an Employee_Info_Journal table in our HR db which creates a before & after record every time data...

Hello, We currently are using Crystal Reports 8.5 with Oracle 9i backend. We have a mixture of CR reports, some using ODBC others Oracle native communication. This environment has existed for 4+ years without this problem until recently. As of late, when I release a new report to production...

Hello, I'm currently using CR 8.5 & have a report pulling from a Oracle 9.2 backend. The report indicates how many performance reviews are overdue in a given chosen period of time. As the formula below indicates, we've broken out the numbers being returned, into groups under 30 days overdue...

Hello, I’m a fellow TekTips member and pleased to find an Adobe InDesign user forum in the same environment. I’ve been asked to evaluate this software to see if it might assist our client department for their particular task. I hope you might advise based on your experience. Our client dept...

Hello, I have a multipage report (CR 8.5) comprising of an unused report header, page header A (report title), page header B, detail section, and report footer. The report footer has 2 subreports displaying summary data unrelated to the main report's details. Page Header B has 12 text boxes...

Hello, I've got a report based on an Oracle view. Both the view and the report (as expected), pull all 776 employee names. However, when our client goes into this report's Select Expert and wants to trim the report to a variety of staff using the "is one of..." on the "Name" field, the Browse...

Round({@SalaryX2}+499.9999999,-3) The above formula was generously provided by a Tek-Tips member. When I was troubleshooting a report for my client, she asked me how it rounds up successfully and I was not able to explain it to her. Ashamed...! Can someone please explain? Much appreciated! Q

Hello, We have Crystal Reports 8.5 installed on 5 client's PCs, all running MS XP for their operating sys. Our corporation uses MS Outlook 2000 SP-3. All but 1 of these five users can export reports in any format to another user by email. My 1 problem client PC can export a report in any...

Hello, I've been asked to review the stucture of quite a few existing MS Access applications used throughout our corporation. The purpose is to estimate the number of hours it would take to recreate these apps. That number of hours will go to our internal audit people to place a value on these...

Hello, This started out as a post asking for help or ideas. As I was typing away, the obvious came to mind. (I'm told by my team it's an age thing!) If I combine the 2 things I had tried unsucessfully, I ended up with one solution that appears to work. I hope the following is of use to someone...

Hi, I'm stumped here! Hope someone can shed some light on this. The following function retrieves the concatenated supervisor name when passed the supervisor's empid. Each of the First_Name & Last_Name fields is a Varchar2(50) so joined they should not exceed 102 characters (including comma &...

Hi, Hope someone can shed some light on this problem. I have an multiuser Access 9.0 database using a "memo" field in one of it's tables. Users employ this field much like a forum. A specific business procedure is reviewed by the group with each member adding text using a form front...

Hi, I'm looking for a way for my CR users to populate an Oracle temporary reference table with an "as-of" date. I'm aware of Crystal's inability to pass variables down to the datasource, which in this case is an Oracle backend. I've checked faqs & forums to no avail, but I've come...