Search results for query: *

I am having issues with a suppress statement I am trying to enter in my report on a grouping. I have placed the following suppress statement in the "Suppress (No Drill-Down)" in my Group 1 Header and Group 1 Footer: {DONOTGROUP} = TRUE In my application, the user places a check in a box that...

This is my current formula: IF {?GROUPBY2} = 'Financial Class' THEN {Data.FinancialClass} ELSE IF {?GROUPBY2} = 'Primary Insurance Carrier' THEN {Data.InsuranceCarrier} ELSE IF {?GROUPBY2} = 'Department' THEN {Data.Department} ELSE IF {?GROUPBY2} = 'Doctor' THEN...

I need some help with my below mentioned formula. Currently the {Data.Ledger} is reading (for example) as 210.00 when my field is 210. If its 215, its reading as 215.00. How can I clip the '.00' off my value? I thought the ToText would help, but its not. Any help is appreciated. IF...

I am getting the following error and unsure how to resolve it: Msg 116, Level 16, State 1, Line 1 Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. My Query: SELECT * from PatientVisit WHERE PatientVisitId NOT IN (SELECT * from...

My client would like me to build them a ID card thats two sided in Crystal. I tried the label wizzard, however I am not having much luck trying to get the back of the label on this print. The ID card dimensions are 2 X 3.5 inches. Any tips or suggestions are always appreciated.

My client has asked me to edit a report by adding in: “200% - 250%” and “250% and over”. I am uncertain how to edit this. Any suggestions? Current Formula called in the report: If RTRIM({ado.Income}) < '101' then '1. 0% - 100% of Poverty' else if RTRIM({ado.Income}) > '101' and...

I need to filter out one ImmunCode from this logic and wanted to check with the experts before I did it. I need to exclude where ImmunCode = "90715". Would I just add a line after 90698 that would read AND {cusASIISC_ImmunizationsGet.ImmunCode} <> "90715"? if (...

My client sent me a form they want immunization dates to pull onto (last 5 per Category). Earlier today, LBass helped me set up the below mentioned formula that works fantastic. I currently have 5 formula's all similiar with the exception of what pulls to {cusASIISC_ImmunizationsGet.Sequence}...

I am still new to Crystal and need help laying out the Syntax correct. Can someone help me with what I have below? IF {cusASIISC_ImmunizationsGet.Category} = "Haemophilus influenzae Type b" and {cusASIISC_ImmunizationsGet.Sequence} = 0 THEN {cusASIISC_ImmunizationsGet.ImmunDte} IF...

I am using Crystal 9. My SQL is returning my values, however my crystal report seems to be losing the data somewhere. I have the following setup on my report Report Header Page Header Group Header #1: ado.50.Department - O Details Group Footer #1: ado.50.Department - O Page Footer Report...

Hello Experts - I am new relatively new to Crystal and its causing some heartburn right about now. I have a report form my client needs and if I keep it without a gouping, I get 4 pages for the 4 dates on my form. I would love to get it all to stay on one page and not print 4 times. I...