Search results for query: *

Hi, I think this is a simple one, but my brain is dead this morning. I have a date/time field called {DIAGNOSI.END_DATE} I need an IF statment to say is the date is = 01/01/1900 then "" else {DIAGNOSI.END_DATE}. The rougue date needs stripping out...to give a blank field. I can't even get...

Hi, I've written Crystal Reports using XI edition to report from my sql database. These reports were written on another PC pointing to a sql server datasource. Using SQL server 2000. I've transfered the reports to my laptop as I have a local copy of a database which has exactly the same...

Hi all, I'm trying to extract the strength of a drug from a string. The string {xdailyissues.drug_strength} can be any one of the following formats: 125 mg 2 g 1.2 mega unit 200 mg in 5 ml 100mg in 5ml I want the formula to output the result in milligrams. For those of you who dont know...

Hi there, I'm stumped with this one, any help gratefully recieved I have an upgrade copy of XP PRO, but as its an upgrade copy I cannot install it as a full copy, an instance of XP has to exist already. Thats no bother as I have another internal drive H: which I installed it on. As this...

Hi all, I've spent a fair amount on time on this already, so I dont post something with an obvious answer... I have a time start field called {PATDRUG.TIME_ARRV} and time finished field called {PATDRUG.TIME_FIN}. They are both string fields and the time is recorded on the same day. Somtimes...

Hi, I have a email display name database field which I need to extract the email address from... They all end with the email address as shown below: John Smith (5JA) Hinckley & Bosworth PCT(john.smith@lnds.nhs.uk) I need to extract backwards from the right removing the brackets.. I'm a bit...

Hi all, I've created a report which I want to show all records from a database between 7pm last night, and 9am this morning. My date/time field is such {14/03/2005 19.00.00} as an example. Furthermore I planning to run the report automcatically every day at 9.30am using some scheduling software...

Hi, I'm looking for the following solution..... A friend of mine wants to add a Crystal reporting section to his new webb application (written in ASP) He cant use Crystal and wants me to write it, which I'm happy to do....... The web app will be distributed to other organisations... Is there...

Hi, I've got the Active X vewier supplied with CR10 developer to work with .asp web pages. The report displays fine and the buttons all work...(the files and samplecode found within the aspxmps10.exe downloaded from BO..) However my question is this... I'm now using it with my reports however...

Hi, I have a report which has generated 500,000+ records. These records are sorted by a group then against this group is a summary value. When I use the standard top N function "group sort expert" to give me the top 30 values for that group, the report takes ages to recompile... When I mean...

Hi, I have a db which has a table called xdailyissues. I create various reports using this table but find when I try to run a query using the patients hospital number it can be very slow (as its not a link field). However there is a link field within the xdailyissues table called lnkpid which...

Hi, I'm stuck on something I thought was simple but I'm having a few probs.... I have a list of transactions from our db. Some of these transactions will have been returned. I know which ones they are and I've added a formula to display them in RED. All I want to do now is supress the red...

Hi all, I have a database field which I want to extract some text from. Below is the string which appears evertime in the database in the same structure. RTS{KINGS MILL HOSPITAL{RTS0603398{ONLY RECEIVED 30 PACKS{ For every record I want to extract the following text "{ONLY RECEIVED 30 PACKS{"...

Hi, When I export to Word and send my reports off to people... They complain when they try to print as it gives an error message "The margins of Section 1 are set outside the printable area of the page , Do you want to continue ?" This message appears for every page of the report and it will...

Hi, I've got a formula which looks at a string and displays some text based on this. i.e IF "rebif 22" in (dbfield) then "please prescribe the dose of rebif as etc etc etc " else (dbfield) I want to space out the "please prescribe etc etc" in 3 lines of text NOT...

Hi, I've just written a very basic NT command script to copy a file from a share over the network from a Win 2K server to a Win 2k client machine. I use Task Scheduler to run the script at a specific time of the month (i know its pretty basic stuff!) and it works fine on my network/domain...

Hi, I've got the Web component manager working on a web server. For those who haven't seen or heard of this it came with Version 8 of Crystal Pro. You set up a website with hyperlinks to your reports and when a user clicks the link it uses an Active X plug in to display in the web browser. It...

Hi all, I think this is an easy one but I've confused myself... All I want to do is run the report for the last month only using the month field NOT a date field as the report will run quicker by this method. The month field is a link field called lnkmon and is a number basing on financial year...

Hi, Does Anyone out there use InterSystems Cache DB Version 4? If so do experience any rowset errors with large queries ? I think it maybe the driver, if anyone has details of an updated one anywhere ? Why do I get the feeling I wont get any response from this ?!! :) grom

Hi all, Can anyone recommend a decent book (preferbly paperback not electronic) which I could get my hands on which will teach me how to write formulas ? I'm no programmer but I really need to start learning more ! Grom