Search results for query: *

Crystal 8.5 (can't upgrade until next year) SQL Server database connection through Pivotal dll. The Invoice has multiple serial numbers listed for the order. I want to concatenate these serial numbers into one field, but I am running into the >254 characters limit. From what I've read in the...

CR 8.5, SQL db, Pivotal (CRM) front end. I have a Sales Opportunity report that I'm working on now that is driving me bonkers. My goal is to give the user the choice to sort either by Account Manager (String) or Date (Date). If AM is chosen group by AM and sort by Date Descending. If Date is...

Using CR8.5 I have a ID field that I am summarizing using Count grouped by Date Recorded (every month). I want to be able to find the numbers for the Maximum and the Minimum Count by month and eventually use them for a subreport. I'm pretty sure I can't do a formula or a running total to get...

I've done the whole rigamarole with the duplicated report and shared variable just to get my blank subreports to suppress. Now what I'd like to is get each subreport to start on a new page IF it is not blank. All my subreports are in the report footer. There must be a way to do this. I think...

In the Customer table there is a string field called Schedule of length 26. Each of the 26 places is either "N" or "Y". For example: {Customer.Schedule} = NNYNNNNYNNNNNYNNNNNNNNNNNN Each element of the array corresponds with the alphabet, so {Customer.Schedule}[3] would be...

Using Crystal 7.0 I have a report printing on a preprinted form that is grouped by transaction type (Sales and Credits). Right now my details section is holding all the item info for the invoice. Here's what I need to accomplish: I want all the Sales to print at a fixed starting point on the...

I've read some previous information in a thread of similar nature concerning the Running Totals are not the right values when running through Crystal, but when exported, the numbers are correct. But suggestions from there did not help. Let me explain further. The report has running totals in...

I have an offsite client that is using an Okidata 390 turbo tractor-feed printer to print statements. The statements are a Crystal Report that worked on this same printer prior to converting to Citrix. They have Citrix installed locally and everything is administered on their site. From the...

This is a mystery to me, but hopefully, someone might know what's going on! Several Crystal reports were created for a customer and have worked for a long time. They have recently installed Citrix and are accessing the programs, reports, etc via Citrix Metaframe. The reports are running, but...

Help! In need of ideas!! I've searched through some past threads and have only found info on passing the database location through a front end. Is it possible to indicate different ODBC DSN's through an INI file? Maybe you might have other ideas if you see the scenario. We are converting our...

First of all, I am VERY new to Citrix and how it works, so I may have some terminology or concepts wrong. (Sorry!) I have a client that has distributed Crystal Reports that run locally, but when trying to access through MetaFrame or Term Server only the initial dialog box comes up. Trying to...

I never really cared much about this before, until I started working at a company that uses a flat database and all the tables I want to link, just don't. So, lately, I've been adding a lot of subreports to get fields to show up on my reports. All that to ask: Is there any way to get the...

Can this be done???? I have successfully passed parameters that are "Multiple" and "Discrete" to the subreport. But I have 3 more parameters that the customer can select multiple ranges. I can get the values to pass to the subreport using the counts of the parameter and...

I'm afraid to see what the answer is, but I wanted to check with everyone here to see if there might be a way around this!! The subreport is based on the container report so it is using the exact same parameters. I don't want the customer to have to input the same information twice (plus...

We are about to deploy to a few beta sites to upgrade our software to use Crystal Reports 8.5 on Pervasive.SQL 2000i database. (Connecting through ODBC) There is a table that contains invoice history which may hold anywhere from 2 months to 2 years of data depending on the customer. On...

Or something like it? We have a table that contains customer history which, depending on the customer, may contain data from 3 months to 3 years. Is there some way to break this data down (possibly in views) without compromising the Crystal Reports that are looking at this table? Or at least...

I have little knowledge of SQL especially Pervasive, but this is what I'm trying to do: I'm trying to create a view where the "DeliveryDate" is >= Current Year. Unfortunately, the "DeliveryDate" data type is an Integer Float in this format: "YYYYMMDD". Does...