Search results for query: *

I am trying to link a subreport in Crystal and when I try to preview my results, all I get back is blank spaceholders. I have never created a sub-report before, so it may be something very simple. In my main report, I have called the PatientVisit.PatientVisitId into the report. In my...

Question: In Crystal Reports, I had a Formula '@Birth Weight < 1500' '@Birth Weight < 1500' was set up as follows: IF {@Deliveries} = 1 and {aaUDS7;1.BirthWeight} > 0 and {aaUDS7;1.BirthWeight} < 1501 then 1 else 0 The @Deliveries is set up as follows: IF {aaUDS7;1.DeliveryType} <> 'No...

"10" & LEFT({Data.GL Number} & SPACE(25),25) & LEFT({Data.Debit Amount} & SPACE(12),12) & LEFT({Data.Credit Amount} & SPACE(12),12) Right now, my {Data.Debit Amount} and {Data.Credit Amount} are formatted incorrect and I sure could use some help, as I have a difficult client needing this...

Question: I am trying to pass a Stored Procedure through an Excel worksheet with the following SQL and getting this Error - "Parameters are not allowed in queries that can't be displayed graphically". My code is this - EXEC cusExcelMTD, ?, ? I have seen that I need to use VB to alter my Excel...

My company recently decided to transition from Crystal reports over to SSRS. Needless to say, I am scrambling to catch up to speed. Just some insight, I have posted same questions on other forums. Here are the links if you need to see them so same advice and problems can be looked over (if...

My company is in the transition of changing from Crystal reports over to SQL Reporting Services and needless to say, its hectic on me. In Crystal you can create Running Totals. I have one set up as follows: Field to Summarize: PatientID Type of Summary: Distinct Count Evaluate on Use of...

It was not until I took this query off a demo db and plugged it into a live db that I found this issue. In fact, I didn't even think about it until I tried the query on a live db. Here is my issue, The [NumberOfVisits] respects visits within specific dateranges, however my Sum on the...

I need help with the following formula. If my field is NULL, I want it to print the word "NULL" else my field value. IF ISNULL({Data.FSAllowed}) THEN 'NULL' ELSE {Data.FSAllowed} This is not right obviously, because I am getting an error indicating a String is reqd. Not quite sure how to fix it.

How do I suppress a detail band if a value is NULL? I know this is wrong, but something like: {Data.TertiaryInsuranceCarrier}ISNULL

I keep getting a message indicating a date time is required here error message. How do I properly tell it a date? {Data.Type} <> 5 OR {Data.TransactionDateOfEntry} = "01/01/1900"

Please Note, the SQL is handled dynamically by the SQL server, therefore some items in my WHERE clauses will look alittle odd to you, please disregard them, as they are not an issue. What I want to accomplish is adding in YTD (year to date) figures for my Payments and Adjustments. What I hoped...

Please note, the SQL is handled dynamically by the server, therefore some items in my WHERE clause will look odd to you - please disregard this. I am getting the following error and need a hand. Msg 245, Level 16, State 1, Line 157 Conversion failed when converting the varchar value '6.2' to...

I would like to populate 'No Last Visit' if {Data.Last Visit Date} = '1900-01-01 00:00:00.000'. Below is my formula that prints a blank, but I need a way to populate this string instead. Any help is appreciated. IF {Data.Last Visit Date} = datetime(1900,1,1,0,0,0) then datetime(0,0,0,0,0,0)...

Please note, the SQL is handled dynamically by the server, therefore some of the items in my WHERE clause will look odd to you, please disregard this. I am getting the following error in my query. Any assistance is appreciated. Msg 241, Level 16, State 1, Line 132 Syntax error converting...

In its current state, my SubQuery is returning the top transaction in the database and not for the specific patient I pull. I believe I need to hook it into the outer query somehow and I am not certain how. Any help is appreciated. My SubQuery '999.LastPaymentDate' = ( SELECT...

First and foremost, I try to avoid cursors at all costs, so I am not the best SQL coder when it comes to coding them. In my code snippet below is my Stored Procedure (cusVRCSuperBillEXT). In my section below, I am taking the fields and passing AppointmentId into my report. What I need to do is...

I am not getting an error message on my formula, however the detail section I placed this on is not suppressing the details tab. I added this to my details A tab under the x-2 tab on the suppress tab. I'm not sure if I need to re-write this differently or whats broken. {?SHOWDETAIL} = False...

I am stumped on my formula and the error returned. A date-time is required here. Highlights the '1800-01-01 00:00:00.000' IF {Data.ApptDte} = '1800-01-01 00:00:00.000' then ' ' ELSE {Data.ApptDte}

I need some assistance converting or casting my money fields in SQL. My field: pva.OrigInsAllocation + pva.OrigPatAllocation AS [Total Charges] Current Results: 500.00 29125.00 662.00 Desired Output 50000 2912500 66200 I tried CAST( (pva.OrigInsAllocation + pva.OrigPatAllocation ) *...

I have 3 specific columns I am calling in a SQL Query that will be merged into one string in Crystal Reports and they have to be a total length (between the 3) = 75 characters. My specific coding on these 3 fields in SQL looks like: ISNULL(LEFT(ic.ListName, 25), 'xxxxxxxxxxxxxxxxxxxxxxxxx')...