Search results for query: *

Has anyone done a mailing label report that lets you specify the start position for the labels? I have a report that will typically print only one or two labels, and I'd like to be able to reuse the sheet and tell the report to start printing at Row 2 Column 2 (or whatever).

Just had my computer replaced and the one thing I forgot to get off the old one was my connection to an Access 2010 database. I'm using Crystal XI When I try to build an ODBC connection the driver is looking for mdb files, what I have is an accdb file. Same thing when I just do "new...

Crystal XI I'm doing a report with a lot of conditional formatting. I have threshold values and want my fields to change color based on where they fall. Is there some way to do a formatting formula that does not need the field name? I want to do something like: IF <THIS FIELD> < {@LO...

We're looking into having a "Status Board" which would basically be a large video screen with a report that is constantly updated. Will any of the schedulers do something like this? We'd need the report to refresh every minute (or something close to that) and redisplay.

Crystal XI I have a report the works correctly, but when I export it to PDF one formula disappears (unless it's a negative value). I have two subreports that use the formuls, with different versions for group 1, group 2, and total. The formula is basically: ({#beds} - {#census}) + {#leave} All...

I should know this but I'm brain dead this morning. I want a pie chart that breaks out the data by day of week, and I want it to show the name of the day (Sun, Mon, etc.) while staying in the correct order. I have formulas for the numberic day of week and the alpha day of week. I was hoping...

One of the facilities I work with has an Access application that the other facilities want to use. I got a copy of it, and it's an .mdb file from an older version of Access. When I open it with Access 2010 it behaves like an executable versijon - I'm at the main menu of the application and...

Just starting to use Access - had a couple classes, but we only worked with existing databases. Now I'm building from scratch and have a very basic question: When I created the new database, there was no prompt for where to put it or what to name it. How do I tell Access to give a new...

Crystal 11 Seems like this should be easy, but I don't see an option anywhere. I have a line graph showing two data elements over time. Everything is fine except the legend which label the two lines as: Sum of @ctfall and Su of @ctinj I want it to say Falls and Injuries. Should be some nice...

Crystal 11 My data looks like this: PATID: 300 EPISODE: 3 GUAR_ORDER: 1 GUAR_ID: 103 PATID: 300 EPISODE: 3 GUAR_ORDER: 2 GUAR_ID: 1101 PATID: 401 EPISODE: 5 GUAR_ORDER: 1 GUAR_ID: 103 PATID: 455 EPISODE: 2 GUAR_ORDER: 1 GUAR_ID: 32 PATID: 455 EPISODE: 2 GUAR_ORDER: 2 GUAR_ID: 103 I need...

I'm currently using Crsytal XI which does not allow the use of ISNULL within a custom function. Do later versions allow this? My rather awkward workaround is the following ungainly formula to call the function: artest({I10TST.CODE},(if isnull({I10TST.DX2}) then ' ' else {I10TST.DX2}), (if...

Crystal 11 I'm looking for something that will let me schedule a report, then run it several times with different parameters, export the results as a PDF, and email the PDF to different addresses. So basically it needs to have a table with the parameters and the corresponding email address...

Crystal 11 I have a report that has two page footers (English or Spanish) that will print depending on a parameter selection. That works fine, but both print about an inch too high. Each page footer is about an inch tall, contains a box with text and a jpg image - the image is cropped very...

They just gave me a new computer at work with Windows 7. Crystal XI installed with no issues, but now I need it to intall additional DLL's (for xbase file access and some export options). In the past wih new XP computers I would just try the option and Crystal would ask for the CD and install...

Using Crystal XI I'm trying to do some benchmarking. I want to put the time the Report starts in the header and the time it finished in the footer. I've tried creating a formula that's beforereadingrecords; currenttime in the header and them putting currenttime in the footer, and they come...

Onoe of my users needs Bar coding. I've found the "Free 3 of 9" font in Crystal 11, but coding anythinig in 3 of 9 requires Start and Stop characters at the beginning and end of the string. What characters do I need to append to my fields to get the Start and Stop?