Search results for query: *

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

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.

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

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 :)

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

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

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