Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Fadius

    Problems counting records

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

    Problems counting records

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

    Problems counting records

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

    Custom Functions to limit parameters

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

    Trouble getting the results I need

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

    Trouble getting the results I need

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

    Counting erros in a row

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

    Counting erros in a row

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

    Counting erros in a row

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

    Counting erros in a row

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

    Compare Records in the same table

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

    Compare Records in the same table

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

    Total errors per row

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

    How to break data down by Month and Week

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

    Select People missing certain licenses

    Thank you lbass. That worked perfectly.
  16. Fadius

    Select People missing certain licenses

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

    Only show certain people

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

    Supress if number does not end with a 1

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

    Days rom start to finish

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

    Display people missing an address type

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

Part and Inventory Search

Back
Top