Recent content by agorjest

There is no selection formula, the report is pulling all the data from the spreadsheet. The month parameter is being used in some period-to-date formulas, but not in this FY-to-date formula. Should it be incorporated into calculating for the fiscal YTD?

Hello, I’m Using Crystal 2013 on Windows 10 with an Access/Excel (DAO) connection to an Excel spreadsheet as the data source. (Need Excel Data as the source for this project, normally not optimal, I know). I’m having issues with a formula dependent on other formulas accurately summing $ amounts...

lbass, Thanks for your response. I Copied your formula, and got a "( missing" error. So I inserted an extra ) in line 4 of your formula, and it took the formula with no errors. However, when I tried to insert the formula field (@Sort) as a group or as a field, it takes me back to the formula...

Charliy, Thanks for your response. I copied your formula and inserted my field name, but I am getting a ") is missing" error. I've tried to insert parentheses in various places, but no luck. Can you see where one is missing?: if numerictext({equipment.location}) then...

Hello, Using CR2008. I want to display a list of groups based on a field that has combinations of strings and numbers. Most are sorted fine because they have no numbers or less than 10 numbers in sequence. Once over 10, they do not sort properly. Here are some examples: Group 1- Field...

Thanks LB for the suggestion, I will give it a try. Also, thanks for pointing out the issue in my # of characters formula, I didn't notice that.

Thanks for the response hilfy. I got through your first 3 steps and jotted down the Y and Height values. But in the Size & Position dialog box in CR2008, there is only one formula workshop link for X & Y and one formula workshop link for Width and Height. Also, the help files specifically...

CR2008. Using a Format Field/Font/Size formula for a string field in order to limit the field to a certain length while still displaying the entire sentence of text on one line (I prefer not using the "Can Grow" option). Font formatting formula goes like this: if length...

Ken, Thanks for the response. 2 follow up questions: 1. By creating a "section", do you mean using the "Insert Section Below" to create a new group section below the Site groups? Currently, my report is grouped by the "site" field in the workorder table. 2.There are 1 of 3 possible sites...

Thanks for your responses, hilfy. I have done SQL commands before, so I'd be willing to take a crack at it. However, if I'm interpreting your above SQL code correctly, your reference to the field "site.site" assumes that there is a separate table for the sites, which there is not (it is a...

The "Site" field is actually a customized field in the workorder table, so I couldn't do a join of 2 different tables. Has anyone done anything with formatting to make this work, like a text box with the group name if there are no records in that group, and conditionally suppressing it if there...

Using CR2008. Have a report listing workorders grouped under 3 different sites, WI, IA, and TX. However, the TX site is small and often does not have any workorders to display. Therefore, only the WI and IA group names appear on the report. How can I get the TX site to display it's group header...

Not sure if this would be applicable in your situation, but there is an "nthlargest" function for rankings of 100 or less: NthLargest Basic and Crystal syntax. Overloads NthLargest (N, fld) NthLargest (N, fld, condFld) NthLargest (N, fld, condFld, cond) Arguments N is any integer from 1 to...

From my experience, the CR cross tab function is very basic and does not handle most complex summaries and calculations. For these situations, I've usually had to do "manual" cross tabs, where group sections function as the rows and conditional formulas function as the columns. It's more time...

Unchecking "Show Preview Panel" worked. Thanks for the tip tweetie7.