Search results for query: *

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.

lbass, "keep group together" is not checked on either one.

lbass - You are correct, I want the five most recent based on category. This is what I have: Report Header Page Header Group Header #1: Category - A Group Header #2: Last - A Details Group Footer #2: Last - A Group Footer #1: Category - A Page Footer Report Footer Currently, my form is...

LBass, This is painfully close. When I created the 5 formulas, it made me create a group on Category, which in turn now prints a page for each category. Is it possible to keep it all on one page and not do this?

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

LBass, THANK YOU, THANK YOU, THANK YOU!! Would you happen to know of a good book or resource to learn these formula's? Your amazing at this and I deeply appreciate the help!