Search results for query: *

I tried to add the PatientVisitId in as a group and then tried dropping my subreport into that group footer and still did not see my results. I left the borders around it to the single line and left it as can grow so I could see if it was changing on the visits and sure enough the size of the...

The subreport is all in one details tab. I suppressed the headers and footers on it and it does not have any groupings. The main report however is very complex and detailed. I am indeed trying to drop my subreport into Group Footer #3b. It seems that is my issue based on your comment. Maybe?

In the subreport links, I have specified the "Fields to Link to:" to equal Data.PatientVisitId. Subreport parameter field to use = ?Pm-Data.PatientVisitId The select data in subreport based on field is checked and its set to "Data.PatientVisitId" I am still getting nothing when I should have...

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

lbass - I got it. THANKS!

lbass - This is the closest I've come and I changed from Lefts to Right as I read the spec's alittle wrong. Can you help me eliminate the 0 (zero) output this is creating? "10" & LEFT({Data.GL Number} & SPACE(25),25) & RIGHT(SPACE(12) & totext(tonumber({Data.Debit Amount}*100),0,""),12) &...

WhilePrintingRecords; Local StringVar D_Amount; Local StringVar C_Amount; If ({Data.Debit Amount}= 0) then D_Amount := Space(12) Else D_Amount := Mid(CStr({Data.Debit Amount}) & Space(12),2,12); If ({Data.Credit Amount}= 0) then D_Amount := Space(12) Else D_Amount :=...

When I show the field type on the Debit and Credit fields, they show up as Currency.

Turkbear, Its for a flat file report and when I tried them as RIGHT, nothing showed. Are the Debit and Credit amount fields actually strings and not numbers? - I don't know the answer to this one. How can I tell - they may be, due to how the SQL was done.

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

Thanks!

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

Markos - That seems to fix my issue in preliminary testing. Thanks a million! Cheers, Jeff

markros - I am getting the following SQL Error back: Msg 174, Level 15, State 1, Line 22 The isnull function requires 2 arguments.

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