Recent content by HookEmHorns

lbass, You amaze me. You are my savior. Thank you cant say it enough. Thank you for the explanation as well, it makes sense.

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

Thank you jdemmi, that did the trick!

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

Please disregard this post. I was able to get my solution: SELECT pv.* FROM PatientVisit pv LEFT OUTER JOIN PatientVisitResource pvr ON pvr.PatientVisitID = pv.PatientVisitId WHERE pvr.PatientVisitID IS NULL

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

Same back to it. Just a single image that has the companys name, address and phone.

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

lbass - You are a rockstar! Happy new year to you!

90715 falls into the "Diphtheria, Tetanus, Pertussis" Category. This is the only one that needs to not pull into this range, as its pulling into another one I have set up.

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

lbass, I changed my concept on some of this, put I just wanted to take a minute to say how thankful I am that you took some time out for me today. You truly save people and you educate them. Your a savior! Thank you! Thank you!

lbass - Should I move it off this group footer or does that not matter? I have triple checked the settings and confirm "keep group together" is not checked. I am stumped.