Search results for query: *

I'm using Crystal Reports XI and connecting to an Oracle MDB. The database stores dates/times as a number and I've gotten a formula to convert those numbers into dates. However, when my users want to use a date as a search parameter, it really slows the report down. I've been trying to...

I'm currently using Crystal Reports XI R2 / Crystal Reports Server XI R2 on a Windows 2003 server. The majority of my reports connect to a SQL Server database running on Windows 2000 via an OLE DB connection. The application is called Connect-Rx and is a McKesson Automation product for the...

Is it possible to install Crystal Reports Server XI R1 on a virtual server, most likely MS Virtual Server 2005? We currently have CRS XI R1 installed on a Windows 2000 box but need to upgrade the server software due to an incompatability with newer printer drivers. Going to a virtual server is...

I am using Crystal Reports XI (release 1) on a Windows XP box. This morning my Crystal Reports started acting a bit buggy. I have a report whose datasource is a SQL Server stored procedure. I can open the report and run it successfully in Crystal Reports. I can also print it to a printer or...

It seems as though my Crystal Reports program and the Crystal Reports Server software are having difficulty. The first issue is that after I upload a Crystal Report XI report to the Crystal Reports Server, it is only a hit or miss situation whether the scheduled report prints. When I first...

I have a formula field which converts a datetime value to text. I have used the fomatting to have the day without any leading zeros, which works, except it leaves a blank space instead. Is there any way to get rid of that extra space so that it will match the other datetime fields in the...

Hi, I'm using Crystal Report Server XI on a NT machine. I don't have very much experience using ODBC connections so this may be a simple fix but I certainly haven't figured it out. The problem: I was recently giving a user id and password so that I could create a report connecting to our...

The IT guys in our organization have written two views for me to use in a Crystal Report. They are not familiar with Crystal and I'm not familiar with the AS400 iSeries in any way shape or form. I have access to the views through the iSeries Navigator: My Connections -> Databases -> Schemas...

I'm using Crystal Reports Server XI with CR XI and a SQL MDB. I've managed to figure out how to create an alert within the report and then based on the alert's result, conditionally email a link. I am wondering if anything exists to conditionally PRINT the report based on the alert? We have...

I'm using Crystal XI with SQL MDB and no ability to create views or stored procedures. I've not had much experience with Crystal Reports and/or crosstabs. I've had a look at other posts regarding similar issues but so far none of the techniques have worked as they do not seem to address...

I'm using Crystal XI with a SQL MDB. Does anyone have any suggestions on how to get a bunch of data parsed out of a very long string? I've gotten the easy stuff figured out but I am having difficulty getting items 3-6 since the starting point varies based on the length of the patient name...

Hi, I'm using Crystal XI with a SQL Server MDB. I have read only privileges so can't create views or stored procedures. I have a main report (grouped by Patient Account) and subreport and I need to pass a value from the main report detail section to the appropriate record in the subreport...

I'm using Crystal Reports XI and connecting to a SQL Server database via OLE DB (ADO). I have a table which contains lab results. The field, ValueText, has the datatype of ntext with a precision of 16. Sample data: <0.3 73 9.2 NO INTERPRETATION Pending 138 4.4 87 40 15...

Hi, I'm using XI and connecting to a SQL Server 2000 database. I'm not sure if I'm using the most efficient method to get my answers and I'm stumped as to how to make this work. Problem: In the sample data below, the Count field is a running total which resets on the change of a group. The...

I hope someone is able to make sense of this as I've been completely stumped. I'm using Access 2003 database, Windows XP. I have a form called Switchboard and it has a tab control on it. One of the tabs is called Search and another is called Browse. On the Browse tab, the user enters in...

My company has bought Crystal Reports Server XI and we're looking to install (temporarily) on a server which has another application loaded. Does anyone know of any obvious conflicts that might occur? Or have done this before and have some suggestions? The other application is called ASCEND...

I'm using MS Access 2003 on an XP machine with forms and tables. The forms have modules associated with them. When I'm in the VBA window and writing code, it seems to be exhibiting some very weird behavior. If it's the first time I'm in the module after opening the database or compacting...

I'm having trouble getting the results I want from a Crystal Report. I'm using v10 and connecting to a SQL Server mdb. I have a table, "administrations", which contains patient info, medications they've taken, etc. I need to create a report which lists the patients who have had two particular...

Hi, I'm using Crystal Reports v10. On my report, one of the parameters allows multiple selections (string). I want to be able to display these multiple selections in a columnar format in the header. Any suggestions on how I might do that? I've successfully used the following formula to...

I just had my version of Visio 2000 upgraded to Visio 2003 Standard version and I can't seem to find the appropriate place to start a reverse engineer of a SQL database. Is this no longer a feature or would I need to have the professional version? All of the online help I've seen says that I...