Search results for query: *

Part does not exist on the main report, only in the subreport.

The three subreports are in the detail section of the report. On this report, jobs have items and items have parts. I'm linking on the item to the main report. The purpose of creating variables here is to check the job is being estimated correctly compared to what parts we're using. For example...

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...

Thanks, that worked great.

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...

Thanks everyone for the help. The problem I was having was using double quotes instead of single quotes. For anyone else that may have a similar problem, my code is below. SELECT "sfeventcds"."start-time", "sfeventcds"."kco", "sfeventcds"."PlantCode", "sfeventcds"."mach-id"...

Thanks so much for the help. Using UNION has been working out almost perfectly. The problem I'm having is that I need to include two fields, kjobcode and event-qty, but those fields only exist on one of the tables. Is there a way to create a dummy field of null values for kjobcode and 0 for the...

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...

I managed to find a way around my problem assigning a number value to each different option of each sub report variable. I'm sure there's another way to achieve the same result but this is the roundabout way I went about solving my problem. For anyone with this same problem, here's how I did it...

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...

Unfortunately I do have multiple subreports and yes, I'm locked to the software. I've done some continued Googleing and have come up empty. It doesn't sound possible so I'm going to figure something else out. Thanks.

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...

Perfect. That's exactly what I was looking for. I appreciate all the help [smile]

Thanks, that's perfect and very well explained. Any chance we could use similar logic or another other way to display the date that the largest qty sum occurred on?

Thanks for responding so quickly. Bob, I copied your formulas, substituting in my own fields, and put them in the groups you mentioned but I'm not sure what each formula is doing. Formula @1_ResetValuesForDateGroup is blank, @2_CalcValues shows a 2, and @3_DisplayMax shows all 0. Unless I'm...

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...

As I play around trying to get it to work, it seems as though you're right. Thanks for the help.