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!

  • Congratulations Chris 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. Jeremy1216

    To display a field not on the table

    Sorry guys as I didn't make it clear on my first post and thanks for the quick reply ;-) It's a report to extract staff info with their first, last name, manager first and last name. Each entry carries the mgr's ID which is the same as the entry ID (login name). F.N. L.N. MgrFN MgrLN with...
  2. Jeremy1216

    To display a field not on the table

    I am using CR10 on a MSSQL 2000 server. Sorry I am only a casual CR user and I have the following question on creating a report. I have a report to extract staff information with the manager's first and last name. However, we only record the manager's ID on the form. How could I query the...
  3. Jeremy1216

    Cross-tab chart on monthly input with different status history

    I am using CR 10 on a MS SQL 2000 database. I have a report request to show the count of different status history on a monthly basis. That is the chart should show the total of entries being created and how many being cancelled or being implemented etc. Each entry could carried multiple...
  4. Jeremy1216

    Group by Status on montly basis

    I am still having problem to present those data in the chart [sadeyes]. Data were extracted correctly from the table with checking whether the time entries were null or not. I couldn't even create the formula as suggested to work. The main hurdle is how to present it on a chart on a monthly...
  5. Jeremy1216

    Group by Status on montly basis

    Dell, Thanks for the idea and I will try it out. FYI I am using the CR 10.
  6. Jeremy1216

    Group by Status on montly basis

    I need to create a report on a form to show the number of entries on different status. Each status come with a date time field to track the change like create time, resolved time. What I have to do is to create a chart for the calendar year to show the entries for different status on a monthly...

Part and Inventory Search

Back
Top