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

    Dynamic Parameter

    I apologize for the vagueness. I am very new to CR. My understanding from the Help files was that if I include the Dynamic parameter it should work regardless of including the parameter in the record selection formula and that it will get passed to the query. I suppose I was wrong in my...
  2. skordis

    Dynamic Parameter

    I did use the parameter in the record selection formula but whenever I refreshed the data or chose another product, it took a while to display the results.
  3. skordis

    Dynamic Parameter

    I started using CR 11 very recently and this is my first time using a Dynamic Parameter. Aside from the fact that I need to edit the registry to display the list of all the products that I am trying to chose from; When I add the dynamic parameter and chose a couple of product names to test, it...
  4. skordis

    Sum of time

    Awesome, it worked. I was trying to do so in a Cross-Tab report. I changed my report format to a regular one and I was able to insert the field to convert the seconds to hh:mm:ss Thanks guys :)
  5. skordis

    Sum of time

    Sorry about the misuderstanding......This is my first post. Yes I spent the whole day yesterday reading most of the FAQ and I did try your solution. Here are the results that I received: User1 2:12:13 PM (Time in) 2:48:27 PM (Time Out) DateDiff = 0:36:14 User1 3:10:30 PM (Time in)...
  6. skordis

    Sum of time

    This is my query : SELECT user_info.username, user_info.first_name + ' ' + user_info.last_name AS [user_name], skordis.FINDHOURS (Sum(DateDiff("s",user_tracking.time_in,user_tracking.time_out))) AS [Time Spent in Phase], form.form_id, form.name, form.phase_id, phase.name, FROM ((form INNER...
  7. skordis

    Sum of time

    I am using a Datediff in my query to get the time spent in certain places. I want to be able to insert a sum of "Time Spent" for all the users in my report footer. When I click on summary, I don't get the option to choose Sum. It is either Max, Min, Count..... Can anyone help? Thanks

Part and Inventory Search

Back
Top