Search results for query: *

George, This post was extremely valuable to me, so thank you!!!!

ID Client MinNum Agency AdmitDate Program DishNum DishDate 1 Mutt, Tim 173038 TomCat 11/28/2012 Detox 12345 12/1/2012 2 Pluto, Jim 172161 HawkInn 10/2/2012 Outpatient 78965 11/30/2012 3 Mouse, Mickey 172948 BeaverDen 11/19/2012 Res-ST NULL NULL 4 Duck, Donald 172711 SoupsOn 11/3/2012...

Yes! This is really AWESOME! I have been struggling with giving people admission stats without being able to segregate. Thanks so much! Now I've got another question to make this more complex and I don't know if this is doable. By left joining tSaDisch dis on adm.AdmitNum = dis.AdmitNum to...

Yes George, this worked! Please explain. Lynn

Hello, I am using SQL Svr 2005 and looking to get the first instance of an admit reqardless of how many may be out there for particular clients who meet my criteria. Below is my query. select distinct ac.ID, (dg.Last+ ' '+dg.First)as 'Client', min(adm.AdmitNum)MinNum, ag.Agency...

Great, thank you Bruce.

We have a Win7 64bit machine, user not logged in as admin, trying to view Crystal Reports from .net application using Crytal Viewer v10. Any suggestions on how to get the Active X installed and to play nicely with other applications? ~LT

Unfortunately your suggestions weren't working for me and I wasn't understanding how I was going to achieve the results I was looking for. A friend of mine did give me a solution and I'd like to share it with you in hope that I'm not offending anyone. @Month global numbervar FYMonth...

LB, I changed the @month formula and now the display shows just Oct. I have Oct, Nov and Dec data (1stQtr) that should be displaying. How do we get the rest of the months to follow? ~LT

Okay, I created @FY= "FY "+totext(year({table.date}+92),"0000") and placed in the column of the cross-tab and then placed monthname({@month},true) //"true" for 3-char monthname in the customized groupname formula but I can't save the formula because CRXI is complaining the {@Month} should be a...

I would just prefer to put in a formula for the column display in Crystal if possible.

Hello, Using CRXIr2 w/Access 2003 and have the following cross-tab: Row @Empl (If {Enter_Issues.EmployeeID}=2 then 'Abc' else '?') Column @Month(MonthName(DatePart("m"{Enter_Issues.BeginDate})) Sum Field Enter_Issues.Total I'd like to display the columns like our Fiscal Year starting with Oct...

Yes I did mean "%" as wild card. Your solution works great. Your the Best! Thanks ~LT

Using CRXI w/SQL 2000 I've got a cross tab with the following Rows: Command.Payor, Command.TxDesc, Command.Paid_As with a summarized field for Command.Payor_Amount I would like to highlight bold and in red any Command.Paid_As that is not like '%ABW%' or '%Adult%' and likewise the...

Using SQL 2000 I've got a nested query that pulls the top 25 most expensive clients by treatment date where Provider is not included because a client can be at more than one Provider during the treatment time. When Provider is included, I only get the most expensive by Provider and not most...

This report is being designed for multiple use. The data is pulled by treatment date so within a specific time, one can see treatment history and costs for clients during that time. Depending upon the dates used, clientIDs will change and this is why I'm saying they are unknown. This is...

The thing is, I don't have a picklist and can't generate one because the id's are unknown. Is there a way to generate a picklist for the sub-report based upon the container?

I did build {?ClientID} in CR interface because there is either one known value or many unknown values. So I want the end user to be able to look up a client or all of them when running the report. So, I don't know how to get the same result using SQL when many values are unknown, therefor a...

Here is the code for the sub-report: SELECT DISTINCT ac.ClientID, bda.Admit, bda.AdmitDate, ag.Agency, sc.ServCat, yn.Descrip as 'Preg', bda.Age, yn2.descrip as 'MH', dga.City, c.County, p.Payor, dga.Zip, bda.WSS, sx.Sex as 'Gender' FROM Admission as bda inner join tClient ac on...

Hi LB, Yes, I'm using a command in the sub as well. Do you want that code too? Sorry. The subreport is located in Report Footer d That is correct, {?ClientID} is not in the command of either report but is a parameter for both on the Crystal side. Should I link to something else or? Where...