Search results for query: *

This one I thought was easy and self explanatory however I cant seem to get this to go. In my report, I have a GroupBy ({aaVisitStatus;1.GroupBy1}). I want to suppress a specific group header and a group footer when this field = '(none)' So I inserted the following suppress statement on both...

In my SQL query, I have a field named 'pv.visit'. It pulls a patients visit date and displays in this manner: '2007-10-26 14:54:00.000' I took this and added in another field that displayed this date as 'October 2007'. This was named [VisitDate](sql code below): SQL Code DateName(Month...

I would like to add in another field based off the pv.Visit Example: Currently, the query is reporting a date as such: '2007-10-25 10:15:00.000' I would like a Field that converts this into one field 'October 2007'. This would allow me to do easier work in Crystal. Any help is appreciated...

Using Crystal 10. I currently have a Employee List Report that groups employees by their postion.The majority of the information from the report is coming from the employee and postion tables. Ex. Coordinator Status Smith PB Gonzalez FB Jones...

I have a client using Peachtree 2007 along with Crystal Reports 9.2.3. I've created many reports testing for zeros and other information but in an older version of Crystal and Best Software. What we want to do is supress zero information based off of testing on one field. If field <> 0 then...

I want to Add in a Case Statement to my Stored Procedure to Identify 5 classifications: A: Birth to 6 yrs old B: Female 7 yrs to 18 yrs C: Male 7 yrs to 18 yrs D: Female over 18 yrs old E: Male over 18 yrs old Any help is appreciated! Declare @ApptDate datetime Select @ApptDate = a.ApptStart...

Using Crystal 9. Would anyone happen to know a better way to get an Average Payments formula? Please let me know if you need any additional info. @DocAvg_Payments Sum ({data.Payments}, {data.Doctor})/Count ({data.Payments}, {data.Doctor})

I am using Ken Hamady's Age Formula (http://www.kenhamady.com/form06.shtml): WhileReadingRecords; DateVar Birth:= date({SB1001_main.PatientBirthdate}); // Replace this with your field for Date Of Birth DateVar Ann := date({SB1001_main.ApptStart}); // Replace this with CurrentDate to get...

Using Crystal 10. I was referenced to use Ken Hamady's Age formula. http://www.kenhamady.com/form06.shtml When I use this, I get an error on {SB1001_main.PatientBirthdate}. It keeps telling me "A date is required here". This is a DateTime field so I guess Im stumped. WhileReadingRecords...

Hi, I have an Excel file that have already attached with the certificate. I have managed installed this certificate to most of the computers running Excel 2007. However there is one computer when I open this Excel file, it opens with a MS Office Security Options window. But it has only one...

I have a table, productTable, that contains a ProductID column, a bunch of attribute columns like manufacturer etc, and a GroupID. Many different productIDs can share the same GroupID which means that they are basically the same product with one different attribute such as color. What I'm trying...

I have 4 text form fields (and other form fields that don't matter) that I want spellchecked after leaving the field. The document is protected, so I know i have to unprotect it in my leave macro, although I don't know how to call the spellcheck function for the specific control I am leaving...

I am using the following Shared Variables, but getting 0's in the calculation field in the Main Report Main Report - Header Name: Decl_Vars WhilePrintingRecords; Shared NumberVar NumErrors1:=0; SubReport Name: CalNumErrors1 WhilePrintingRecords; Shared NumberVar NumErrors1; NumErrors1...

Crystal Reports 8.5 I have a inventory which includes hundreds of items. I have cards which display only the items from the inventory needed for a particular card. I am trying to diplay the cards which do not have a particular item from the inventory listed on it.

I have a database that I have changed the spelling of a field in all of the tables of a database. I also need to change the field name referenced in all of my stored procedures also. Considering I have about 50 stored procedures to deal with.... Can I somehow check ALL stored procedures in my...

I am attempting the following code in Crystal Reports XI I get a boolean return value. local CurrencyVar Budget; Select GroupName ({qry_Admin_Financials.PostingDate}, "annually") Case '2005': Budget = 38000000 Case "2006": Budget = 42000000 Case "2007": Budget = 50000000

I have some texts in three formula fields since the text depends on some conditions hence i am using formulas for the three texts. I want to display these text together hence i am using another formula for combining these text formulas...it is as below {text1} & {text2} & {text3} ...it displays...

Where do I place the bin dirctory of Crystal Reports 10 in Crystal Reports 12. The current location in cr10 is:C:\Program Files\Crystal Decisions\10.0\Analysis\Olap\Bin I need to know this so that I can get my reports to run in 12.

I have a parameter that is not working. My report pulls patients based on their doctor. I want to give the report users the flexiblity to report any patient using _ALL. Patients that have a doctor at EastsideClinic and also be able to pick specific doctors to get a patient list. The parameter...

I am trying to suppress the page headers on my subreports. Setting shared variables in the report header, group header and below the subreports. I have two subreports listed in seperate report footers. the problem is the page keeps printing on the first subreport. I can move the formulas...