Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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