Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: LT2
  • Order by date
  1. LT2

    First Instance

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

    First Instance

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

    First Instance

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

    First Instance

    Yes George, this worked! Please explain. Lynn
  5. LT2

    First Instance

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

    Win 7 64bit and Crystal Viewer v10

    Great, thank you Bruce.
  7. LT2

    Win 7 64bit and Crystal Viewer v10

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

    Name of Month in Cross-tab to display in certain order

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

    Name of Month in Cross-tab to display in certain order

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

    Name of Month in Cross-tab to display in certain order

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

    Name of Month in Cross-tab to display in certain order

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

    Name of Month in Cross-tab to display in certain order

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

    Conditional formatting of crosstab CRXI

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

    Conditional formatting of crosstab CRXI

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

    Nested query to get add'l data afterward

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

    Sub-report Parameters

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

    Sub-report Parameters

    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?
  18. LT2

    Sub-report Parameters

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

    Sub-report Parameters

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

    Sub-report Parameters

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

Part and Inventory Search

Back
Top