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

    Summary on non-recurring field error

    I have a report that is summarizing employee hours. It groups by Firm, Employee, Funding code and Practice Group. One of the funding codes is call Leave and the group specifies that Leave be listed first. I now need to split two employees Leave hours by 70/30. There is a running total called...
  2. trwebster

    Force Display of Group Name when summary value is null

    All of my selection criteria is from the cases table, which is the main table. The problem table is just the table that translates the code for "problem" into an understandable label; it doesn't host any of the actual case data. You did give me an idea that worked though. I moved my record...
  3. trwebster

    Force Display of Group Name when summary value is null

    I'm using Crystal XI and I need to have all the names in a menu table display even if there is no match in another table. This is what I have: Menu_Problem table left joined to Cases table on menu_problem.value=cases.problem I'm grouping on the field menu_problem.label and have running totals...
  4. trwebster

    Main Report and Unlinked Subreport parameter the same

    I liked that idea and used it in my YTD report, but when I inserted it as a subreport and linked using the {?enddate} the YTD subreport only pulls records for that end date. So, I went back to the YTD report and modified the date parameter to be {cases.close_date} in Date(2007,01,01) to...
  5. trwebster

    Main Report and Unlinked Subreport parameter the same

    Thanks for trying. It's kind of weird that it doesn't work. Since the begin date of the subreport is 1/1/2007 and won't change until 2008 I decided to just keep the end date parameter and hard code the begin date in the subreport.
  6. trwebster

    Main Report and Unlinked Subreport parameter the same

    There are no links set up. This is what I have in the subreport>report>selection formula>record: {cases.office} = "Le" and {cases.close_date} in {?First Date} to {?End Date} and not ({cases.disposition_status} in ["020", "017"])
  7. trwebster

    Main Report and Unlinked Subreport parameter the same

    I inserted an unlinked subreport into a main report in Crystal XI. For some reason my subreport takes on the same date parameter prompts as my main report even though it is not linked. I tried changing the name of the subreport parameters so they weren't the same, but that doesn't help...
  8. trwebster

    I need to calculate the average days open based upon user and problem

    I have a query that creates a list of cases and how many days it took to close the case. I need to calculate the average number of days it took to close a case based upon the user and the problem type. Here's a sample of the data...
  9. trwebster

    IF...THEN...ELSE & successive rows

    Thanks. It seems to work fine, but now I have another question. What would I need to use if instead of returning the actual hours worked on days that also have Leave time I wanted instead to return 7.0 minus the Leave time? After I ran your query I found that several of the staff put in 7...
  10. trwebster

    IF...THEN...ELSE & successive rows

    I have a query that sums the daily hours for each employee based upon 2 categories (Normal and Leave). Since most of these employees are salary-exempt, I need to report 7 hours total for each date unless they took leave time, which if they did I need to report how many total hours of leave time...
  11. trwebster

    Grouping by Year in Column Chart

    I went through Insert|Chart again and it seems to be working after choosing the correct Master/Child link.
  12. trwebster

    Grouping by Year in Column Chart

    I have a query that shows: YearOpen County Countofnumber The data is sorted by year and I created a report that shows the list of counties grouped by year (one year on each page). I inserted a chart into the YearOpen footer, but I only want the chart to show one year on each page; right...
  13. trwebster

    Sum Data with multiple criteria in Reports

    It's on a query and does not need to be updateable. If you can help, that'd be great. If not, thanks for the other help. Tina
  14. trwebster

    Sum Data with multiple criteria in Reports

    I don't think I have the access to do that. It's not my database; I just use it. If I changed anything, the IT Manager and her supervisor would probably have kittens. :-) If you have the time, I have another issue. I work in legal services and my queries almost always include the client...
  15. trwebster

    Sum Data with multiple criteria in Reports

    I think my query is too broad for that. The database does have an offices table, but my query is pulling anything that had to do with a tax case for the first half of the year. Then, in my report, I was summing the different activities: cases opened, closed, denied, etc. by the date criteria...
  16. trwebster

    Sum Data with multiple criteria in Reports

    Duane, Thanks a bunch. It appears to be working; and you have given me another expression string to explore. I took a few of those adult ed Access classes, but they just don't get very deep, so I'm still more self-taught than anything. I appreciate all the help I can get.
  17. trwebster

    Sum Data with multiple criteria in Reports

    I'm trying to count how many offices opened cases between 1/1 and 6/30. My query is set up with these fields: office, disposition_status, and open_date. In my report, for 1 organization I used: =Sum(abs([office]="As" and [disposition_status] Between "001" and "002" and [open_date] Between...
  18. trwebster

    Summing Multiple Data

    I have a query that pulls client data between a certain time period. I'm trying to total the following in a report: Ethnicity Under 18 18-59 60+ Total White African American Hispanic I'm using this as my control: =Sum(Abs([ethnicity]="W" and [client_age] >="60" or...

Part and Inventory Search

Back
Top