Search results for query: *

gentlemen/ladies, Running on MSSQL Server 2000. If somebody can tell me what is wrong with this code. Thanks very much. Code: ____________________________________ UPDATE MM_Refer SET Ref_Stat_Cd = 'D', Upd_User_Name = 'JOHN D NIED', Upd_Date_Time = GETDATE() FROM MM_Refer R...

Good morning to all, I have a portion of a text field that I need to include on a letter but its a little tricky(at least on my part). Heres the narrative: Our claim Dept enters an explanation of why they are denying a claim on a field that was initially intended for another use; they enter a...

I'm trying to create a temporary table needed for another query. This table has multiple records per group as shown. I want to insert a new field (SeqNo) that basically is the seq# of the records within the group. It starts with 1 and increment by 1 for each same MemNum. Select MemNum, SeqNo...

I have a problem setting up my testing server. I have two web apps already running on 2 sites. Nothing fancy, just a search function (master/detail). When I developed them 2 years ago, I had no problems setting up my test server. Actually I’m using the same connection string for this new...

I'm ready to install the CR XI on my PC with CR 8.5 and CR 10 in co-existence. Can CR11 co-exist with my 2 older versions? I'm keeping them for backward compatibility with a viewer program installed on my users but will eventually convert them to XI if/when all of over a hundred reports will...

CR 10/SQL Server 2000 I'm using the 3 formula method I came accross from one the thread here. But i got this error "A number is required here" on my detail formula. MyFormula is {tabname.Svc_Chg} * {tabname.Svc_Unit} and they are both numeric Thank you ----------------- Pls see below: group...

I posted a while back question regarding exporting text to DW. This is a spinoff of that. So okay, I can slice then export a text by selecting HTML as type but how can I do this: 1. retain the original content and text attributes i.e. font, size, color of my text in FW. 2. retain the...

I just got an email offer from BO for their latest ver XI. I'm already running on ver 10 and I'm just wondering whats in it for me to upgrade to the latest. Actually, I'm developing both on 8.5 and 10.0 as my CR viewer installed on users is for the 8.5. I'm continually converting to 10 and...

I just started with VB 6.0 couple of weeks ago. I have this problem of creating a text file based on a raw data from one of our vendors. My input is a text file with duplicate cert#. How can I create a new text file with only the unique cert#? Thank you very much for all your help.

Pls help!. I have a VB6.0 program that prints a report using Crystal Report. (Actually, I initially developed the report in CR10)My back-end is an MS SQL server 2000. It works on my development PC but when I run the Package and Deployment Wizard I have this error: "Unexpected error number...

I'm a programmer from a forgotten era. (you know, COBOL, RPG in AS400...) Started with VB 6.0 like 2 weeks ago and man, do i have tons of questions! Anyway, here's my scenario: I'm trying to access an MS SQL 2000 using ADO. I use the property windows and was able to display records from my...

I have a parameter on the main report that a user fill up at runtime. How can I pass the same value of the parm to a subreport so I can use it to filter records. The main and the sub are not link by a common field. Thank you in advance.

Hello All, How can I conditionally calculate the Standard Deviation of a series of values, i.e. include in the calculation of StdDev if less than 50. My existing formula is shown: StdDev ({@ERVisitsPer1K}) Thank you

Hi all, I have an unusual report request. Theres a table that contains the number of ER visits. So it has the doctor's name and ER count. Say I have 50 doctors in the Internal Medicine group. I want to print the report 50 times showing one doctor's name at a time but show everybody else ER...

I'm on CR10, SQL2000. I'm trying to add 12 fields with data type 'float' (thought to be numeric...) from a table imported from an Access DB. For some reason, there are NULL values which mess up my calculation. How can I convert NULL to zero without creating a formula for each 12-month bucket...

Okay, so I finally upgraded to CR10. It comes with CE 10 Embedded and CE 10 Professional. Questions: 1. Can CR 8.5 and 10 co-exits in my development PC? 2. Whats the difference between the CE Embedded and Professional. 3. Can I install the CE10(whatever is the better flavor) in my development...

I've been using CR8.5 Developer Edition for couple of years now and although it meets our needs, there are some feature I like/wish to have. Is upgrading to CR10 worth a try?. I have an offer from Business Objects mentioning all the neat features of the new version. Any comment/experience on...

Hello All, I have 2 AS400 in my network but we moved to a Wintel platform last year. We used one 9406 720e as a web server for over a year. As per request, I unplugged it couple of months ago. How best to get rid of it? Anybody knows a company buying-back AS400's? Thanks VA

Any comment/experience with IntelliVIEW? Here's the site: http://www.intelliview.com I came accross this when somebody in my company mentioned about web-anabling our reports. Since CR charges huge$$$$$ on this functionality, I started researching on options that might involve lessER $$...

Hello everybody: My scenario: DWMX2004, MSSQL Server, ASP. I'm trying to get a feedback/comment from our doctors. I have a prov_comment.asp where they can enter their comment and I also have a table that contains User_id, Comment and the current date/time. I like to let them enter just their...