Search results for query: *

that worked....thank you..... It's amazing how something so simple can be so frustrating when you're new to all this. Thanks again.

ok...I tried this....Replace ( [Macid1]![city] ," " ", " " ) and it says the second comma is an invalid syntax

I have a field that currently has data "123456", I'm trying to figure out how to remove the " " marks so that it's 123456. Any help would be greatly appreciated Thanks in advance.....

I have tried the manual cross tab but there are a total of 109 codes so in order to get them all to fit on the page the print is way to small.Is there a way with the manual cross tab for it to expand pages horizontally as well?

I'm using CR 9 with an SQL database. In one of the database fields we have multiple "codes" entered representing issues that need corrected ex... 001, 002, 003, 004 and so forth for various locations on each map of our network. I'm trying to set up the cross tab using the codes as rows and...

Does anyone know how to get excel to automatically import a text file. I've set the refresh option in the external data properties, but when it refreshes, I'm required to click on the import button. I want it to do this automatically. Thanks in advance for any help. Dan

that worked....thanks!!!

Using CR9 I'm using {EndDate} as a field to group by, and a parameter field to select the date range for record selection. Currently the report is displaying the first day in the week (Sunday), how do you get the report to display the date for that following friday thus being the last work day...

Bob, That worked.....Thank you!!

I forgot..... I'm using crystal reports 9

I'm using a date range parameter {?DateRange} on my report and trying to figure out how to count the number of working days within that parameter. If anyone could help, that would be great. Please include an example. Thanks in advance for any insight you may be able to provide. Dan

Thanks for the help. Didn't mean to waste time, just thought someone may be able to point out what is wrong with the formula. I have the report grouped by technicians, thus the hours worked formulas needs to go horizontally across report much like a cross tab. Thanks again, Dan

I'm working on a report where I need to find the numbers of hours worked within a specified date range. This report will be used year after year so I'm wanting to declare start and end dates, then create formulas based off those to specify date range. I've created a formula called Start date for...

I'm working on a report where I need to find the numbers of hours worked within a specified date range. This report will be used year after year so I'm wanting to declare start and end dates, then create formulas based off those to specify date range. I've created a formula called Start date for...