Search results for query: *

I would like some genreal direction from this from those of you who have been there/done that, or at least know a thing or two about this subject. I want people with disabilities to be able to visit a website and search for service facilities that match their criteria. For example, all...

C10 Access Interbase I am using one table in access, and multiple tables from an Interbase database. The access table is linked via inner join to an Interbase table by SSN. If I place one field from the Access table and one field from the linked Interbase tbale, the report runs quickly...

C10 I am trying to add in a table from an Access file as my data source. However, when I try to view the records in Crystal preview, it will list the 200 or so in the access table, and then many blank records after those. The same thing happens in with Excel. It seems as if Crystal is reading...

C10 Interbase I have a main report and a linking subreport by SSN. I want the subreport to process a bunch of data if a person's selection criteria is met in the main report. Each person may meet more than one of the conditions. Since I am using 'is one of' as the selection criteria, the...

C10 Interbase I have a field whose value always begins with "PROGRAM-" and I want to return everything AFTER the dash. I can't find the correct function to only reutrn characters 9 and after.

I currently use netformdd (an html form generator) and Frontpage to create forms for an intranet site. The forms are starting to look dated and I was wondering what other options I can pursue to create new forms that look better and have more versitility with either HTML or something else? Thanks.

C10 Interbase I am trying to delete a parameter, but it's somehow hidden within the report. I know there is a way to find it, but I can't remember. Can somewhere refresh my memory.

C10 Interbase I have a crosstab with only a couple of rows, but with a bunch of colums making the chart extend to several pages in width, but leaving a ton of white space below. Is there a way to have the cross tab stop before or at the right margin and contine on below, so that the data just...

C10 Interbase One of my data sources is an excel spreadsheet where the name field is "last, first". I want to create one formula in Crystal to pull just the last name and another formula to pull just the first name. What is the best way to do that? Thanks.

C10 Interbase Group Header: Name Field, Shared Value Formula Details: Subreport1 Details: Subreport2 I am trying to insert a formula that pulls a shared a value calculated in Subreport 2 so that it appears in the Group Header next to the name field (as shown above). However, I need the shared...

C10 Interbase In this report, one of the data sources is a excel spreadsheet. I am pulling data from an ID field where all values are 8 digits long, most starting with a 7 or 9. However, some of these values begin with 000 so that the value is something like "00045678". The values that start...

C10 Interbase Exporting to Excel I have two parameter fields for a start date and an end date. I want to creat a formula that will combine those with a "-" in between so that if the it would look like 20061001-20061031 When I try to combine them with a formula like this...

C10 The report in question is grouped by client ID#. The individual detail records are summed into Group Footer A, and then Group Footers B,C, and D have subreports inserted into them which contain shared values. Group Footer E is able to call those shared values and that is the only section...

C10 I am trying to write an if statement that can check a string field for a certain combination of charatcets, and then return an assigned string value if it is true, and another assigned value if not. Something like below but I can't get the proper syntax. If InStr({StringField}, "ABC") then...

C10 I have a report that links to a subreport and returns a value. I would like to use that returned value in a formula in the main report. Can I do this?

C10 I’ve created a report that is using two data sources; one of them is an Excel spread sheet, the other based on Interbase 7.1. I am linking the two needed tables from each source by SSN. I pull totals data from the Interbase source, group by SSN and then use category information from the...

I am looking for a way to convert data into an 837 formatted file. I currently use Crystal Reports to query a database and create a monthly report with the needed info, which is then handkeyed in via a web portal. However, I can also batch send this info using an 837 formatted file. Is there a...

C10 I have a report that groups be SSN and then by Date. For each day, the report will display the date, number of hours worked that day, and total hours worked for the month so far (formula field). I would like the the date group to only display the row with the highest date. For example: Jim...

I have Crystal Reports and ACT installed on my PC. I am able to use Crystal to connect to the ACT database and pull information. If I want to do the same thing on another PC that only has Crystal and not ACT intalled, can I get away with only installing a select few ACT dlls that will allow me...

C10 ACT! 2000 Perhaps this belongs in the formulas forum? I have created a subreport that pulls data from an ACT database linked by SSN to the main report. It appears that some of the SSN numbers in the ACT database are of two formats: 123-45-6789 and 123456789 The SSN fields from the main...