Search results for query: *

I'm using CR XI. I have a report listing machine parts used on a single job. Sometimes it's one, sometimes it's more than one. When there's two parts used, I've been able to work with max/min to create variables for each part, but I'm having trouble figuring out a way to create a variable for...

I've mostly got what I need but I'm having trouble translating a formula from crystal syntax to basic syntax. The code below gives me a string like 180403 which is a YYMMDD format for the current day and uses if statements to include a 0 when the month or day number is a single digit. shared...

I'm using CR XI. I have a main report showing a list of Jobs with two identical subreports in it, both linked on Job. When I run the report, the single parameter from both subreports combine and shows only one parameter selection screen for both at once. What I need to do is be able to select...

Using all of my years of Crystal knowledge, I'm fairly certain this isn't possible but I thought I'd ask for ideas. I have two subreports that I need to sort by date together, essentially intermingling the data. The only way I can imagine doing this is creating potentially 100s of variables to...

The software that users use to run the crystal reports that I create limits the number of records that can be shown to around 1000 and I have 1600+. After contacting the software company, this is a known bug and doesn't have a resolution currently. I'm hoping to find a workaround. Is there a way...

The software users use to run the crystal reports that I create limits the number of records that can be shown to around 1000 and I have 1600+. After contacting the software company, this is a known bug and doesn't have a resolution currently. I'm hoping to find a workaround. Is there a way for...

This is a strange issue that I feel like there is a solution to but I can't figure out how to do it. In my main report, I have 4 different sub reports, each of them with a variable to hold some piece of information. In the main report, I have a formula that essentially creates one string by...

This is a bit of a unique issue and I'm not sure if it's possible but I'm hoping for a solution or other ideas to try. I'm using crystal XI. I have a report (an invoice report) that has a text box in the page header underlayed to show in the middle of the page to act similar to a watermark. It...

I have a report that is grouping a quantity by date and by machine, for example 100000 quantity produced on 8/28/14 on machine abc. What I'm looking for is a way to only show the largest summed quantity for each machine using something like maximum(sum(qty, date), machine) but I get the error...

I'm creating a barcode sticker that will be printed with two stickers side by side on a roll. I've created the report to work for a single barcode sticker for whatever number I type in. What I can't do is get this do increment by 1 for a count of stickers. For example, I want to print out 2000...

I'm editing a form that normally is only printed with only one sales order. The PF section shows "footer" information and is on the first page only then hidden on the other pages. This report, as is, only works for one sales order but I'm trying to make it work for multiple. I've created a sales...

I'm trying to use an if statement to create a calculated field to use in a pivot table. The pivot table is grouped by a salesperson, customer, month, and product type then I have a sales and a year field to create a calculated field. I'm attempting to create a calculated field using...

On my report, I have a picture in the Report Footer section that takes up the entire page. Then I have a Page Footer with text that displays on the front page being conditionally suppressed with PageNumber <> 1. For some reason, on the pages that the Page Footer is supposed to be suppressed, the...

Hi, I've been using Dim x as String variables and I've been playing around with Public instead and I'm having a problem making one work. In my testing, I've gotten this to work starting from a brand new book with two brand new modules: Module1: Public testVar As String Sub testone()...

I'm using CR XI. I have a report that lists the inks used on a job for printing labels. Currently it is grouped by ink and has a distinct count of the jobs for each ink. The end user has requested that this report lists the count in order of highest to lowest in order to determine which inks we...

Below is my code that doesn't work but this is the idea that I'm trying to work out. The way my whole macro works, it takes .xls files and if there is more than one sheet, I need it to save as a .xlsx, close, and reopen the new file. Based on the number of sheets, the macro will continue in...

The basic idea is this... I have a blank spreadsheet with a macro that pulls variance information from other spreadsheets, copies it to the blank spreadsheet all on their own tab, makes pivot tables, etc etc. I have 4 tabs, one for the current variance as of the time I run the report to find it...

I'm using CR XI. I have a report that I want to have duplicated X (X being a parameter) times. Is this possible? -DJWW

Hi, I'm new to sql and its syntax/functions but here goes. Basically, I have a query that is returning duplicate values because of the tables I've linked. When I do =Sum(Fields!estimatedvalue.Value), it sums for every value including the duplicating ones on the detail level. What I want it to...

I'm looking for some software that can automatically run reports and export them either to a folder or send them by email. For example, I have a report that is run daily and takes about 30 mins to run and export. Instead of the user logging into Crystal and doing this all themselves, I'd like it...