Search results for query: *

Using Crystal 11 & hoping I am in the right forum and this is coherent...(it's been awhile) I am trying to create a comparison using a left outer join, which is not working. What I have forgotten is whether or not I can use any selection criteria on the outer joined table at all, even if I...

Using Crystal 11 off MS-SQL Server… I am tasked with modifying an existing report that lists in a visit-based date range exceptions in a billing process, e.g. checks for missing approvals, etc. I am to note additionally other missing data, e.g. no personal residence or no primary diagnosis...

using Crystal 11 w/MS-SQL Server... I want to enable clients to choose a parameter department dynamically. The table w/departments contains expired department values, however. Without resorting to a static list, is there any way to exclude from the presented parameter value list those...

Reporting with Crystal v.10, off MS-SQL Server data... Is there a way in Crystal to determine which users are running reports in a networked folder? We want to cull reports that aren't being used. Brad Macdonald

Reporting with Crystal v.10, off MS-SQL Server data... Does anyone know of a way to update the default version for Excel among the Crystal Export options? It's still showing MS Excel 97-2000 although we have upgraded to MS Office Excel 2007. Thanks, Brad Macdonald

Reporting with Crystal v.10, off MS-SQL Server data... Our SA was asked to delete some fields from a particular table. I deleted the fields from the Crystal Report that had been using them. Following that, the report is displaying a non-fatal error: 'Field " not found.' I can find no stray...

Reporting with Crystal v.10, off MS-SQL Server data... This afternoon my boss showed me a report I've heavily modified. An error was evident, where in groups of "facility type" with only one facility, the daily average column in the "facility type" GF row did not agree with the daily average...

Reporting with Crystal v.10, off MS-SQL Server data… I have been tasked with combining several missing data reports into one. They are grouped by schools and also group rows by formula according to how long ago the client originally was admitted to school, e.g. Alpha School Missing Intake...

Reporting with Crystal v.10, off MS-SQL Server data... I have a report that for days in a prompted range prints counts of clients in our schools by funding source. Three columns on the right of the report average the daily counts, print the target per funding source and the variance between...

Reporting with Crystal v.10, off MS-SQL Server data ... I have a spreadsheet I am to duplicate that calculates for each row a dollar amount from the number of days a student is in one of our facilities w/in a prompted date range & multiplied by a dollar constant. My difficulty is I need a page...

Reporting with Crystal v.10, off MS-SQL Server data … I have an existing report that counts attendance in our facilities for each day within a parameter date range (up to a month) by funding source, facility, division (not shown) etc. and averages by day: Oct. 1 2 3 4 5 […]...

[using Crystal 10 via MS-SQL Server] I've been asked to add a formula to a report of expected student grade level. The report currently has parameter fields to select those who are in our programs w/in a certain date range. Date of Birth is an available field. Grade 1 would include any child...

Resubmitting this from a mistaken placement in Crystal Analysis: Records in our client enrollment view contain a flag field to indicate whether or not the funding source fields are the primary source of funding, RDV_foo.Funding_Primary_YN. An existing report selects records where...

Using Crystal 10 ... I've got a formula to average the daily population at our facilities by month. I want to print all months daily average throughout a year in rows and then total the averages of our facilities within facility type. I believe I can't use crosstab to average and total...

Greetings, Using Crystal 10, I am to create daily averages of students in our programs by month within fiscal year. Attendance data is available in a single view: Client ID, Admission date and Exit date. The report will be by fiscal year, but not necessarily the current one. The report model...

Greetings: I have been asked to recreate a multi-page MS-Word form in Crystal. Data will be input into our database using other means. I need to report it out using Crystal exactly as it would appear if typed into the blank MS-Word form. I wonder if anyone could give me some general...

Would anyone have any method or advice for adding an organization-wide total bar to a stacked bar chart? I have charts that are calculating subset counts within totals in groups per bar just fine. In the report itself, I alternately have used calculated formulas and running totals...

This feels like a newbie error, but ... I created two formulas to conditionally tally columns. I didn't use a Running Total or Sum as I want to later compare the formulas to create percentage. In the last detail line in the first column I am counting by formula, the condition is not met and...