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 Rhinorhino 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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
  3. 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...
  4. 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...
  5. 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...
  6. LT2

    Sub-report Parameters

    Using CRXIr2 w/SQL 2005 I have two reports created with a SQL command with the parameters as part of the command: {?StartDate}, {?EndDate} & {?ClientID}. I've linked on all three parms. If I populate with a ClientID both reports display results for that ClientID. But, if I don't populate...
  7. LT2

    Syntax help

    SQL Svr 2000 I have the following select statement: Select ac.Client, ag.Name, t.TxDate, v.PdAmt, p.Payor, v.CoPay, b.BillNum, b.AjDate, v.RPaySeq From Payments v inner join AClient ac on v.ClientNum = ac.ClientNum inner join Provider ag on ac.ProvNum = ag.ProvNum left join FundingSource...
  8. LT2

    Sum of Sum and TOP (n)

    Using SQL Svr 2005 How do I get a sum of a sum and then, Top 2? Client Provider Date Code Units PdAmt Charlie A&W 3/7/2009 123 1 4.00 Charlie A&W 3/8/2009 123 1 4.00 Charlie A&W 3/9/2009 246 1 5.00 Charlie A&W 3/10/2009 555 1 7.50 Woodie B&R 4/1/2009 123 1 4.00 Woodie B&R 4/2/2009 246 1 5.00...
  9. LT2

    Chart results for parm on sub-report

    Using CRXIr2 w/SQL Svr I wrote a SQL script as the command for a Client Treatment History report that includes: clientid, treatment date, service code, units, cost, payor & invoice num. I have a chart I created through Advanced Chart Expert to change on group2 clientID (desc), (Top 10) and...
  10. LT2

    Cross-tab % of Total for Units Used

    Hello, Using CRXIr2 w/SQL Svr. I had a similar thread posted, (thread767-1468549)that dealt with a count for a percentage but I'm unsure how to apply to this situation. What I want is the percentage of units used just like a pivot table. Cross-tab: Treatment Codes Authorized and Used by...
  11. LT2

    Parameter not required, how to handle NULL

    Hello, Using CRXI r2 w/SQL Svr. I've got a report that displays auths, tx codes, begindate, enddate and clients with a parms for dates created through a sql command. On the front end, I've got additional parms for Report Content, Sort by (uses @GroupName) and AgencyName with the Record...
  12. LT2

    Sub-report formatting

    Using CRXI and SQL Svr I have a report grouped by LOC that includes 5 sub-reports each placed in a report footer. In the main report just like the sub-reports, I use a flag to end the printing of the page header beginning with RFa where @True - is placed. whileprintingrecords; booleanvar...
  13. LT2

    Highlight cross-tab of True displays

    Hello, Using CRXI w/SQL Svr. I've got a cross-tab using the following: Rows: @Over50 = ({Command.Age})>50 @Co-Occurring = {Command.MH}= 'Yes' CommandPrimSA Summarized Fields: DistinctCount of Command.ClientID I only have 1 highlight using the Highlight Expert, the first row: Value...
  14. LT2

    Chart to display only true results

    Hello, Using CRXI w/SQL Svr and have a cross-tab comprised of: Rows: @Adolescents = ({Command.Age}) in 0 to 17 Command.PrimSA Summarized Fields: Distinct Count of Command.ClientID I used the cross-tab to create a bar chart which does a Change on @Adolescents, Subdivided by...
  15. LT2

    Chart display of formula

    Hello, Using CRXI w/SQL Svr and have a cross-tab comprised of: Rows: @Adolescents = ({Command.Age}) in 0 to 17 Command.PrimSA Summarized Fields: Distinct Count of Command.ClientID I used the cross-tab to create a bar chart which does a Change on @Adolescents, Subdivided by...
  16. LT2

    Loop required?

    Hello, Using SQL Svr 2005. I've got results from a basic query that if certain criteria are met, I'd like another query to run to give me specific results and I'm unsure of the proper syntax to get what I want. Can you help me? Basic query: Select c.client, p.name, a.admitdate, d.dischdate...
  17. LT2

    Extract Path from FileName

    Using CRXI w/SQL Svr Hi, I would like to know how to display just the path portion of the filename. I changed the Syntax to Basic in the Formula Editor, but CRXI doesn't like the formula. It doesn't seem to recognize 'GetFilePath': @ReportPath 'Retrieve a file's path without the trailing...
  18. LT2

    Sort by formula

    Hello, Using CRXI w/SQL Svr 2005 Report is populated by SQL command and displays client, admitdate, @LOS, auth, authexp, @AuthRenew & Agency in the details. @AuthRenew (whileprintingrecords; CurrentDate - {Command.AuthExp}) I'd like to sort in desc order by the results of @AuthRenew but it...
  19. LT2

    Joining Parameter to itself

    Using CRXI w/SQL Svr Hello, I've got a report basically designed by a SQL Command, however I added {?AgencyName} in Crystal as a static string and imported a list with a default -Any Value- for multiple or discreet values. @Agencies - Placed in the Report Header If {?AgencyName} = '-Any...
  20. LT2

    Sum and Total of Variable

    Hello, Using CRXI w/SQL Svr. I have a report grouped by Client. Group Header contains: @UntimelyReset //Reset group untimely count whileprintingrecords; numbervar cnt; IF not inrepeatedgroupheader THEN cnt:=0; @UntimelyReset2 //Reset group untimely...

Part and Inventory Search

Back
Top