Search results for query: *

...might be in other reports. I finally figured it out on my own and came up with this: {DATEFIELD} in (DateDiff("d", Date(1800,1,1),{?Start Date})*100000) to (DateDiff("d", Date(1800,1,1),{?End Date})*100000) I think this is very similar to what bdreed had offered as a solution. I end up...

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...

Thanks for your advice, synapse. Unfortunately, we're not doing the upgrade by choice as the vendor is no longer providing support for our current version and forcing us to move to the newer version. The vendor hasn't been too forthcoming with regards to technical information and being the...

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...

Other than BO not supporting the installation, why wouldn't you recommend using VM for a Production environment? This is the option that my company is leaning towards and if it is not reliable and/or there are known issues with running CRS XI virtually, I would greatly appreciate your...

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...

Hi, thanks for the information. The report was set up originally with the "Use original database logon information from the report" option. I think that we have maybe discovered the issue. I was actually misinformed and the printers are not the same make and model. Printers and drivers are...

I'm still waiting for BO tech support to contact me... Can you give me some guidance on how to "update the RPT files on the CR-XI server"?

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...

Sorry, that didn't work. I think that solution would only work to trim extra spaces off the end of the string.

OK, here's the majority of details that I know. If I am missing something specific you will need to tell me what it is. I have a report which details the times a medication is scheduled to be given as well as when the actual medication was given. Each administration has a status, which could...

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 finally got access to our server box and installed Crystal Reports XI (R1). I ran the report I had created on my local machine with a local system DSN and got the following error: Logon Failed. Details: HY000:General error: Invalid file dsn 'Crystal iSeries.dsn' [Database Vendor Code...

Yes, I am assuming so. This is what the IT guy who set up Crystal Report Server said earlier this week: Crystal was installed using the defaults and there are 4 services running: Crystal Reports Cache Server Crystal Reports Job Server Crystal Reports Page Server Destination Job Server All of...

I'll have to see if the IT guys will give me access to the server to do this. I'm pretty sure that both Crystal Reports and Crystal Reports Server are Release 1 but I will double check before I start installing and testing. An added thought, we're sharing this server box with another program...

...Do not use Secure Sockets Layer (SSL) Server Tab 1. SQL Default Library: BSERVER 2. Click Advanced a) Commit Mode: Commit Immediate (*None) Packages Tab 1. Package Library: BSERVER Translation Tab 1. Select Convert binary data CCSID 65535 to text I used this to create the...

Is there any way of accomplishing this method when your report has more than one group? Group #1 is the category of medication, Group #2 is the medication name and includes the total amount of doses administered. The detail section is completely suppressed. I've been playing with Ken's...

I was able to get administrative right and set up a File DSN. I can now connect and run a report with the views. I discovered though that I cannot schedule the report in Crystal Reports Server XI. Depending on the settings I use under Process -> Database, I get the following: 1. Unable to...

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...