Search results for query: *

I am trying to automate a report that I have previously been running manually. When running manually, I am able to enter the Year and the period of the data that I would like to select. I have come up with the selection criteria below that seems to work properly. My concern is in January...

We have several jobs with the same operations; we would like to average the lowest (3) Act Times. I'm not sure how to select the lowest (3) numbers. Any advice would be greatly appreciated. - Jill Product Operation Est Time Act Time Handwheel 50 4.50 5.25 Handwheel 50 4.50 2.25 Handwheel...

We have a report where users would like to SEE all groups listed regardless of if there are details records within the group. I have not been able to find a solution to display a group 'title' if there are not records in the group. Would anyone have suggestions? Thanks for any advice! Jill...

We have 30 groups of machines. Within each group we have 3 status types, Frozen, Planned and Available. When printing this report we double side to printer and so only want to print a total of 2 pages per group. Since each group has a varied number of orders in each status group as well as 4...

Hello, I have a report that I am trying to recreate from a form created many years ago by an ERP company. The ERP company used a temporary subset of the original data that resides locally. I would like to share a similar report outside of the ERP system via our intranet and so I am connecting...

Hello, *Our company plans to share crystal reports via a crystal runtime client that connects through an ODBC connection to a SQL server. *Our current solution is web based and does not rely on an ODBC connection. *When we develop the report each developer has a local ODBC connection...

I have run into a problem that I've been unable to solve. I have passed several date variables from a sub report to the main report. Many of the Date Variables are blank. I have a fairly complex conditional format to highlight pastdue's based on these fields. My problem is that the null...

I am trying to pass info from a subreport to the main report. I am creating shared variables in the sub (to store data) & main reports (to retrieve data). I have followed the BO "c2007600" article to a 'T'. It seems straight forward. Often the variable is blank, this works fine until the...

I was surprised to find that Symantec doesn't support it's software, even new purchases. I have a DLO Agent running on my desktop. The backup starts @ 9:00 p.m. Sometimes the agent will appear to hang up on the desktop, with a status of "Network Pending". The server shows that the backup is...

I am a macro novice, and use the macro recorder, but sometimes do small edits in the editor. I have used the Macro recorder to format a report that we run weekly from a database. My problem is each week the # of rows will be different. How can I tell my macro to go to the last row? TIA for...

I have SAP article 1211133 describing how to select one, some or all values with a parameter field. I have added a parameter field with(3) choices, MSM, MSMW, and ALL. The article says that ALL will select all companies but my result is 0 companies. When selecting MSM or MSMW the results are...

We have (2) sites with (1) connected via VPN to our primary plant. Cisco 1800 series routers on each side. Sometimes -- randomly we loose the VPN connection, sometimes for 10 seconds sometimes for 10 minutes. When I ping from the primary plant I am seeing some really unusual ping times...

When my user accessed his files this morning he found several new file folders. They are #'d similar to: ae8e0ee8c67f733ce10d15f7cf44f3. Inside this folder is a folder entitled "update" and inside that folder is a log file. The log file reads; "CoSetup: Entering CoSetup: Leaving". Since it...

We have a memo field that contains a variety of information. For instance; Job Released No-->Yes, Date01: 01/01/01 --> 02/01/01, Req. Date: 03/01/01 --> 04/01/01, Req. Date: 04/01/01 --> 05/01/01 We need to find all instances of "Req. Date". How can I do a loop or next? So far I have...

I need to have user select Company1, Company2, or Both. I have set up a parameter that asks user to type 1, 2, or B. I cannot figure out how to get Both to work in the select expert. I'm sure this is easy -- I just haven't thought of it yet. :) Thanks, Jill

My record selection is quite long. I would like to print it on the report so my users are able to see how we gathered the information. My problem is the Record Seletion Formula in the Special Fields section truncates after some # of characters. I have inserted it into a formula and expanded...

Hello, I am a novice access report writer. We have a report that allows us to select an EMPID and between date ranges. What we would like to do is select several EMPID within this date range. I need the report to ask the user to enter these EMPID's. I tried adding 'in' to the field...

I've made a simple report w/4 tables Vendor, POHeader, POLine, POReleaseLine -- links are straight forward. When I look at all open POREleaselines, 2700 records. Made group on Buyer - still 2700 records, 10 buyer groups. Create a ?BuyerID parameter, put it in my Select Expert. Preview the...

I am considering a training session with CrystalUser.com. Has anyone used them in the past? Are their sessions worth while? Mainly are they reputable? Thanks, JillP

I have checked out all the questions and answers available for this subject and still don't find a solution that will help me. Maybe someone has some thoughts on the following problem: When using Winnt 4.0 with Crystal 8.0 I have often used the SQL statement work around, typing in a blob field...