Search results for query: *

Charts happen before subreports so you can't really chart on a formula that involves shared variables coming from subreports. There is a workaround that works in some cases. You do the calculation and chart in the subreport: 1) Go into the subreport that currently calculates the shared...

1) Crystal will only print the repeated GH when there is at least one detail to print on the subsequent page. If the page just has the GF then the GH won't repeat to that page. 2) Make sure you have this option checked in the subreport, and in the correct group. 3) Make sure there is no...

True, and that might allows the user to skip some parameters, but Marco should note that the optional prompts will still appear in the parameter list. Ken Hamady, On-site Custom Crystal Reports Training & Consulting Public classes and individual training. Guides to Formulas, Parameters...

>> 4.Placed the myString inside the textbox (inserted on the Detail) Glad you found it. I never put these formulas into text objects. If the formula is the correct length then there is no need to do that, and it adds another layer of complexity. But, I never argue with success. Ken Hamady...

>> A padspace is created for header and detail What does this mean? >> used a formula to combine all fields. Can you post the formula? Ken Hamady, On-site Custom Crystal Reports Training & Consulting Public classes and individual training. Guides to Formulas, Parameters, Subreports...

Make sure that: 1) Every other section has the 'suppress' check mark 2) the object is at position 0,0 in the section (use size and position) 3) There is no space in the section below the object Any chance you are using a subreport? Ken Hamady, On-site Custom Crystal Reports Training &...

You do it in two steps in Crystal. First write a formula like this: if [Criteria] then 1 else 0 You create your ranges by grouping the records into the groups to match your ranges. Then you do a Sum grand total and/or a Sum group total of this formula. Yes, you do a SUM even though you want a...

Try this. Make the text object exactly 22.5 inches wide. You may need to use a different printer driver to allow an object that wide on the page. Then export using 16 CPI and 0 for pagination. If that doesn't work I would need to know what version of the dll you are using. Go into Help >...

Unfortunately, there is no conditional control over whether or not parameters appear. Any parameter that exists will appear every time (unless you want to program your own custom front end in .net or something else). Ken Hamady, On-site Custom Crystal Reports Training & Consulting Public...

Maybe I wasn't clear. I think each combination will need another report. You could reuse this report for any combination of 2 records. Just change the filter. Add another instance if you need a report that find a combination of 3 different records and change the filter to include three...

I think so. Filter each instance for one of the comment strings. You could even have 3 or 4 instances if you needed more complex combinations. Ken Hamady, On-site Custom Crystal Reports Training & Consulting Public classes and individual training. Guides to Formulas, Parameters, Subreports...

You will need an inflation table to generate the number of labels you want, and a parameter to tell the report the number to print. See these links for some info on using/creating inflation tables: https://kenhamady.com/cru/archives/73 https://kenhamady.com/cru/archives/2806...

To solve this you need to add the sales order table to the report two times. The second time Crystal will give the table a slightly different name (alias) usually by adding _1 to the end of the table name. Then you treat these as if they were two separate tables. You link them based on the...

One way to do this is with a self referencing join. Take the invoice details table and add it a second time. Link this to the original table using the invoice number. Then in the select expert add a rule that records from this new instance have to be one of your driver records. What should...

Here is a blog post that provides several helpful links for solving Excel Export problems. http://kenhamady.com/cru/archives/2712 Ken Hamady, On-site Custom Crystal Reports Training & Consulting Public classes and individual training. Guides to Formulas, Parameters, Subreports, Cross-tabs, VB...

I know I am a bit late here, but his question was actually "the best way to determine if the current date is the last day of the month?" Which is slightly different from asking "what is the last date of the current month?" So I would do it like this: Month(CurrentDate+1) > Month(CurrentDate)...

What you are really trying to do is turn one record into several records. I have found that the cleanest way to do that is with an "inflation table": http://kenhamady.com/cru/archives/2806 http://kenhamady.com/cru/archives/2807 If your time period can span up to x months then you will need...

That isn't CR designer error. It looks like you are running the report from within an application when that error occurs. So, you need to know what version of the runtime is being used by that application. My guess is that it is an older version that doesn't support optional parameters, so the...

You are missing the word AND between the criteria. Try something like this: "{Booking.SrNo} = " & Sr_No & " and {Booking.Class} = " & class &" and {Booking.ShowName} = " & show &"" Ken Hamady, On-site Custom Crystal Reports Training & Consulting Public classes and individual training. Guides...

1) That error may be due to a recent Microsoft update I wrote about here: http://kenhamady.com/cru/archives/2841 2) There are several ways to add an "inflation table" to a report. See these links for examples and explanations: http://kenhamady.com/cru/archives/2806...