Search results for query: *

The data field is not null. There is data there. I am trying to identify whether the data says "M", "F", or "U" so that I can count up all the males, females, and unknown genders. I need to get rid of the zeros in my report so that the distinctcount does not count...

I am trying to count distinct clients by gender. In my details section, I have these 3 formula in a fields: Field "MaleCount" If {vDistinctClientPostalCode.GenderGlobalCode} = "M" Then {vDistinctClientPostalCode.ClientID} Field "FemaleCount" If...

I am having the same problem. The distinct count doesn't work because the report puts in a zero for a false if statement so when the distinct count is done, it is counting the zeros once. What we need is to have the zeros show as null so the distinct count doesn't count them. If I find a...

I need to create a formula that adds up all the DosageAmounts for a PatientID by DrugName. My report is grouped by DrugName. I want the report to look like: GROUP: DrugName GROUP: DailyDosageGrouping (0 mg - 10 mg, >20 mg) DETAIL: PatientID#43 DosageAmount 10 mg (supressed)...

Thanks! Your tips worked great. TiggerMom is purrin'

When I use the following formula, only the first "if" is displayed in my report while the remaining 3 if pieces are not displaying anything. I am using this formula to create a grouping level in my report. When I change the order of the 4 if sections, only the first if section displays...

I have a report that has two groups in it. The data is grouped by Agency then by StaffLastName. My problem is that the order of the staff is coming out wrong when I have two or more staff with the same last name. For example the group output comes in the order of: Smith, Sandra L...

I ran into the same problem. To fix I reinstalled SQL and the service pack then after that everything worked fine. I think that sometimes this happens if you have installed software programs after installing SQL and its patch. TiggerMom

You bet there is a way. You need to create a local variable of string type and then assign a concatenated select statement to it then execute the string. Here is an example for you: CREATE PROCEDURE spStoredProcName (@ParameterStr varchar(500)) AS Declare @sql varchar(8000) set @sql='SELECT...

Ken, What I did was I opened the original report and did a Save As and named my new report. Next I went into Visual Linking Expert and added some tables to the tables that already existed in the report. I added a grouping level to my report using one of the fields from my new table. I then...

What are the quirks when I copy an existing report and name it as a different report so that I don't have to start from scratch? For example, I copied an existing report then added some tables to it but when I look at the report's SQL statement only the new tables are being recognized. I've...

Solution found. Although I haven't pinpointed what the exact problem was I did find a solution. I had to delete the original subreport then create a new subreport that uses a DIFFERENT name than the original subreport. If you create a new subreport and name it the same as the one you deleted...

The report is not using saved data and all updates are being done from within the subreport within the main report. When I get thrown into the C++ debugger I see an error for a null pointer. Do you think that the subreport can't find the updated stored procedure or perhaps itself? TiggerMom

Hello. Go to the Seagate home page (www.seagatesoftware.com) and click on the 'Support' area. Search for Article ID: c2007600 titled "How to Share Subreport Data with the Main Report". This article will tell you exactly how to do what you want to do! Cheers! TiggerMom

I am running Crystal 7 with Service Pack 1. I use SQL 7 tables for my backend. I have a report with subreports in it. The primary report and the subreports use stored procedures to access the table data. After I have created the subreport, if I make changes to its stored procedure and then...