Search results for query: *

Hi everybody, [Crystal Reports 2008] I have a report that connects rows in a table based on a common field, an order number. However, there's a field, called Draft/Final, that indicates whether a specific form has been completed or not. The problem is that the table is the data source for four...

Hi everybody, [Crystal Reports 8.5] I created a summary report which has a Microsoft Access 2003 database as the datasource, and have inserted a crosstab in the Report Footer. In the database, there's a table called tblCallLog and another table called tblProblem, which I've added to the...

Hi everybody, [Crystal Reports 2008] I'm attempting to write a report that will show patients that have readmitted within 30 days of their previous discharge date. I found a similar post that addresses the same question and is almost identical to my situation except for the fact that I have...

Hi everybody, [Crystal Report 2008] [Crystal SQL Designer] Many months ago I posted a similar question, but I had to abandon it for a while due to other work priorities. Now that the dust has settled I'm tackling this once again. Here's the link from the original thread...

Hi everybody, I found the following thread and the third post in the thread is what prompted my question: http://www.tek-tips.com/viewthread.cfm?qid=1596381. I typically don't put anything in the report header...my personal preference is to use the page header and have it repeat for every...

Hi, [Crystal Reports 2008] I'm writing a report and only want to return those groups that have more than two records in the details section. My groups are: - PatientID - PatientName - DataEntryDate (sorted by each day) I've got two sets of record counting formulas (one is running...

Hi everybody, [Crystal Reports 2008] I'm going to start with the background first and then I'll get into my question. I work at a hospital and the patients here have to have certain assessments completed annually compared to the date they were admitted to the facility. We use an electronic...

Hi everybody, [Crystal Reports 2008] Right off the bat, let me mention that I didn't create the database I'm having to work with and don't have access to modify the tables, create views, etc. That being said, here's goes nothing. I'm working with a table that is the back-end for four forms...

Hi, [Crystal Reports 2008] There's a field in the database I'm writing my report against that has multiple values in a single string that are separated by a semi-colon (;). This field is populated by a list box that has check boxes in it. When the values are added to the table, the full...

Hi everybody, I work for a hospital and Crystal Reports 8.5 and 2008 to write reports against an Oracle database, but the database is managed by a different group and because of potential confidentiality issues I don't have direct access to the database to create views, stored procedures, etc...

Hi everybody, I'm using Excel 2003 and I'm trying to modify a spreadsheet for work to make it easier to use. The spreadsheet is basically a project task list where the first row contains the headers and the subsequent rows list the tasks, then the headers are repeated again. This repetition...

Hi everybody, I'm using Excel 2003 and I'm trying to modify a spreadsheet for work to make it easier to use. The spreadsheet is basically a project task list where the first row contains the headers and the subsequent rows list the tasks, then the headers are repeated again. This repetition...

Hi everybody, [Access 2003] I've got a large database that I'm using to track timeliness for a particular set of forms (that aren't static and will indeed change in the future) in a patient's chart. The forms I'm looking at are a selection indicated be yes/no field on the forms table...

Hi everybody, I want to use the first record in the detail section and the last record in the detail section for each page in the page header. I'm trying to create a dictionary of options that are available in a database application we use and want to place guidewords in the page header to help...

Hi everybody, Version: [Crystal Reports 8.5] I'm still fairly new to Crystal Reports, so please be thorough in your explanation. I'm working with a back-end database that has a list of people's names in it. I know I need to group the people by department and I think I'm probably going to need...

Hi everybody, Here's the stats: Access 2003 Split database Linked tables All subdatasheets on the back-end set to [None] I'm in a jam that I'm hoping I can get resolved by Wednesday. In my current application, I have used 4 select queries in order to get the results for one crosstab query, and...

Hi everybody, I'm using Crystal Reports 8.5 against an Access database. My issue is that I'm trying to find a summary for all records in a date range and then compare that number with a second (group) parameter. The summary is the only part that I'm having trouble with. My report has a...

Hi everybody, [Specs: Crystal Reports 8.5] I've seen similar posts that deal with the question I have, but the situations in the other posts were just a little different, were slightly vague, or the users had access to components of their system that I don't have. On my report, I pass in a...

[Crystal Reports 8.5] Hi everybody, I posted this on another site, but haven't gotten a response and really need some help. I decided to copy the post instead of putting a link to it. I'm working on a report that will ask the user for a parameter, then select the appropriate records based on...