Search results for query: *

Trying to resolve a formula error with a field that include both Alpha and Numeric data. There are some system generated text that I can account for but there's also user entered text that can be just about anything. I need to convert the field to a number field using the tonumber command which...

Need to find a way to highlight the items in a report that are duplicates. It's OK that they are duplicates, because they fall into separate groups based on an item type. Database records for an item are assigned a P or S depending on the datatype (Purchases / Sales). See example below of...

Have a field in a group that I would like to sort descending. The field includes formulas (see below). Basically the field is looking for the gross profit per lb for the group #2. The report is grouped by salesman then by customer. It would be great to then have the values sorted descending so...

Looking for a better way to handle updating my report. My report has 16 running totals. 4 in each, GF1, 2, 3, and report footer for current month and prior year month. I need to enter the same date in 8 of the RT's for the current month date and the same month date for the prior year in the...

I was just reading this post (http://www.tek-tips.com/faqs.cfm?fid=6524). Noticed that the author says to use Running Totals only if necessary. I use running totals in several of my reports because I need to see the sales for a current month/year vs a prior month/year. Is there another way I...

Hello... Have a weight field where the output is (example: 204.34) Want the output to be 20434. How do I remove the decimal? Would it be a formula in the format field>customize>decimal separator? Thanks, BV

Hello, Looks like a formula may be the only way to get the value I'm looking for. Have a cross tab report that lists the produced items for the past fiscal year in the rows and the average of the cost in the sum fields. However, we don't want the average, we want the "Last" produced cost...

Hello... Trying to find the right formula for running totals so I can refresh a report without needing to edit the individual running totals dates. CR2008 The report is setup as follows (12 months): GF2: Running Totals #1 - Field to summarize: 'sales' Evaluate: Formula - {date} in Date...

Hello, I created a formula to break out the hours in a workday. Then I created a group based on the formula. formula: if time({invdth.idhedt}) in time(0,0,0) to time(5,59,59) then "12am - 6am" else if time({invdth.idhedt}) in time(6,0,0) to time(6,59,59) then "6am - 7am" else Etc... When I...

Hello... Has anyone seen this problem and know of a solution? HP 4350dtn Networked and Shared Windows 2003 Server (SBS) The printing preferences option from the "right click" menu does not work. Also, I can open printer properties and all tabs work except for "device settings". When I click...

Hello... CR2008 - Have a formula ({@closed}) in the details section that returns a boolean True / False. I want to use the section expert to color the section if the formula is true. Tried entering {@closed} = "true". Program responds with "A boolean is required here" message. Tried adding ()...

Hi.. My reports in Crystal Server are not displaying. Receiving the error: Unable to retrieve Object. External component has thrown an exception Anyone seen this error and know a resolution. Historical reports can be accessed. Cannot schedule any reports without receiving this error. Any...

Hello... I need assistance with running totals not displaying the correct sum at the group level. Report has 3 groups: cust.id cust.masteracct cust.class Running totals for each group based on the following: field to summarize: invoicehist.price type: sum evaluate: {invdth.idhdat} in Date...

Using CR 2008, anyone notice that if you change the print format from Portrait to Landscape the preview screen has a line where the previous screen width was. Also, in design view you cannot make a line to the full width of the page by sliding the handle to the left or right. You CAN however...

Anyone using Crystal xcelsius and care to share thoughts? I used the demo but didn't care for the need to use Excel. This would be a great product if it worked with Crystal report data. Am I missing the point? If this should be posted elsewhere please let me know. Thanks, BV

Hello... Having a problem with duplicate records. Found a post referrencing the use of the "previous" command to verify duplicates. I added this formula: if previous ({cusmas.c_cid}) = ({cusmas.c_cid}) then "repeat" else {cusmas.c_cid} to the details section of my report along with another...

I have a very simple report based on the data from an Excel worksheet. I created the report several weeks ago and have since added a number of items to the excel worksheet. When I refresh the changes do not appear. I have a feeling that the probelm is due to the worksheet using linked fields...

I created a rather involved report that utilizes 4 subreports. 2 of the reports use an SQL query and the other 2 use the select expert. The report takes about 2 hours to complete. This seems excessively long. What are some troubleshooting steps that can be taken to possibly speed up the report...

Hello, Just created a report that's taken awhile to put together. Still not where I want it though. The report uses 4 subreports to query data on Invoiced Sales, Physical Inventory, Purchases, and Prior day Inventory. After the report is generated I export it out to Excel so I can create...

Hello, CR XI - ODBC Informix Database Here's what I'm trying to achieve. Item ID, Previous Day Inv - Current Inv = Diff (calc) - Usage = Variance (calc) The current inventory is queried from the Item Ledger table. The previous days inventory is not stored in the database. I want to store the...