Search results for query: *

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

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

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

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

Using CR2008. Having a problem writing a formula that includes strings with quotation marks within the string. For instance: {workorder.description} like ["unit B", "unit/B", "Unit "B""] The last one has the text "B" in quotations within the string. CR interprets it as a quotation mark in...

Hello, Using CR 2008 to write report, users use CR Enterprise 9 viewer to view the report. I want to display group headers but I do not want the user to be able to drill down the details of a group in the viewer. I know you can suppress groups/sections with no drill down and hide them with drill...

Hello, I am on CR version 2008, using it to report on building maintenance workorders. Trying to pull workorder records using a combination of fields, including 3 different date fields. I'm getting the right results with the date fields. However, due to inconsistencies of various people entering...

Hello, I'm using CR2008, SQL ODBC data source with 2 data tables (workorder, materials transactions), linked by a field called wonum (workorder number). I'm trying to update a report that lists all parts & materials purchased for each workorder. Here is an example of how it displays: GH1: Site...

Hello, I'm using CR2008, ODBC. SQL Command combining labor, materials, and workorders tables as data source. User chosen parameters: {?Start Date}, {?End Date} Trying to use a conditional formula to get one field's value to equal another field's value under a certain condition. Here is the...

Hello, I'm using CR2008, with ODBC to a remote SQL server. Looking to pull service workorder records based on user chosen start and end date parameters, but depending on the status of a workorder, the "date" of the workorder can be drawn from 1 of 2 different fields: Status Date or Actual...

Hello, Using CR12. In a financial report, I'm trying to format a percentage calculation to display as a negative percentage. Here is a sample of the summary data (FYI- "Variance$" is "Budget" minus "Total Costs" & Variance% is "Total Costs" / "Budget). GL Acct# Ttl Costs Budget Variance$...

Using CR9, ODBC/SQL, with data from 3 tables: Workorder, Labor Transactions, and Materials Transactions. Primary table is the Workorder table, with full outer join links on the indexed workorder number field from the workorder table to both the Lab.Trans. and Mat.Trans. tables. I'm trying to...

I am having a data performance issue that I'm absolutely sure is related to the PC that CR is installed on. I am running CR9 with an ODBC SQL connection on Windows XP Pro with 1 GB RAM and plenty of hard drive space, and a solid T1 line internet connection. When other PCs are connected to the...

Hello, If anyone can help me with this I'd appreciate it: Using CR 9, creating a report that tracks mechanical service workorders and totals their costs in terms of labor and parts/materials. It will draw data from 3 data tables: Workorders, Labor Transactions, and Materials Transactions. All 3...