Search results for query: *

I figured the grouping out, however, I am still running into trouble with the counts as the Payor Approvals uses a different date field than all the other types. Here is how I am grouping: if {@NewProvider} and {@CVIWithinYear} then "New Providers" else if {@NewProviderWorkItem} and...

HOw would I group things? Would I still keep a formula for type and group on that?

I am using Crystal Reports XI. I have a formula which is generating a type and the report is grouped on type. The problem I am running into is if the item has been counted in one type, it is not being counted in another type even though it is possible. Here is what is making up my types and...

Is it possible to create a custom function that would limit the parameters the user is prompted with? I have a report or an application in Crystal which prompts the user for new, Add location, or change form This is all fine until the user selects the change form. Once this is selected, I am...

Units A B C D are pre processign centers that do the setup for Unit E. These are people being set up and verified at the 4 units for different regions for unit E. These people have the same Identifier in Unit E and there pre processing unit A,B,C or D. This is how they get linked. Unit E is...

I am fairly new to Business Objects. I have a database which has all of the data I need. We have a field which indicates Buiness Unit. What I am needing in my results is any thing at units, a, b, c, and d with a status if lets say "Done" My results will display the unit name of a, b, c, or d...

Here is the code I am using. I do have the formula in the details section. stringvar array x :=...

Actually it looks like it only displaying a number for the last record in the group. I have everything placed in the details section including the counting formula.

Thank you lbass. It is coutning some of the error, but not all for every row. What do the numbervar i and j represent?

I have a report and it is working great. I have a row of data and formulas looking if the data element is correct or not. If it is not correct, it will say incorrect. What I am looking for is a way to get a total of all the incorrects in each row to display at the end of each row and am having...

Thanks . I will give it a try. lbass, I meant UHC, sorry, typo. The table is pull of providers and payors they are linked to that require medicaid to be done first before they can be worked. I just need to report those providers who have payors that can be started to be worked as the medicaid...

I have a result set from a query from a database I have been given. My task is I need to compare records in determine what to display in the report. Data Example ProviderID Payor Status 123456 FL Medicaid Participating 123456 FL UHC Pending 123456 FL AMC...

I have an audit report looking for errors. First Column is the assigned person name, then each other column is different fields of data. If the data is incorrect, it displays missing. What I am needing is a count in each row of all the errors per row. How can I accomplish this? For each...

I have been asked to provide a report which will break down the number of items based on the date. I am creating a crosstab report which is briken down by month. I am stuck as to how to have it count by month, and week. Example: Jan Feb Week1...

Thank you lbass. That worked perfectly.

I am writing a report and only want people displayed which are missing either a state license or a federal license. The people in the database can have multiple licenses. State, Federal, Drivers, CDL, CPR, Etc. How do I get it to only display a person if they are missing either a state or a...

I have a table that contain people, worksheets, and work items. I am only wanting people to show if they have an open worksheet, but all work items have been closed. I am having a hard time doing getting this. WOuld I use a whilereadingrecords function when the report open? If so, how would...

I need to supress a group footer if the total does not end in 1. What would the formula be for this?

OK, I have a and in the table is names and workitems with dates. Groupiong is by Name, then work item. One work item type is Setup. I only need the received date from this to pass through to all other work items as I need to calculate days from received on the setup work item to the complete...

I have a field called address_type. So a person in the query can have multiple results. Example: Name Address_Type John Smith Primary Location John Smith Billing Address Mary Smith Billing Address Mary Smith Mailing Address John Doe Primary Location John...