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

  • Users: mbryantuk
  • Content: Threads
  • Order by date
  1. mbryantuk

    Grouping by 1+,2+,3+ etc

    Can think of how to do this I need to count the number of times someone has acheived at least one contact for a dialler. the output needs to have columns of 1+,2+,3+ and to be dynamic in a matrix and rows of counts the dataset has a timescalled column for each record so for the value for...
  2. mbryantuk

    Vb.net app works on Vista/7 not on XP

    Hi I am a newbie at creating applications but i have created a vb.net application using the ReportViewer control, tabcontrol and a database driven treeview control. when i build the application it works fine on Vista/7 but not on XP/Server 2003, I have tried it on a xp machine with .net 3.5...
  3. mbryantuk

    Break down a persons performance by hour

    Hi I have a table containing the data a person has entered into the system e.g. Agent|StartTime|EndTime Bob|2009-01-22 09:59:59|2009-01-22 10:30:41 Bob|2009-01-22 10:44:59|2009-01-22 10:55:41 Bob|2009-01-22 11:02:59|2009-01-22 11:37:41 Bob|2009-01-22 11:42:59|2009-01-22 12:10:41 what i am...
  4. mbryantuk

    User Variables Max Values

    Hi I have a User Variable called details with a datatype of string, this is populated by a SQL Script task, the field that populates this variable is quite large and contains CR, LF and tabs, when i run the task with this field writing to the variable i get the error: "The type of the value...
  5. mbryantuk

    Reporting Services 2000 - 2005 compatibility

    hi I usually write reports for SQL Server Reporting Services 2005 but i have a requirement for 2000 if i write a report in my current instance of SQL Server Business Intelligence Development Studio will the RDL work if it gets deployed in a 2000 environment cheers
  6. mbryantuk

    Turning Seconds in DD:HH:MM:SS

    Hi Can someone help me turn the difference between a start date/time and end date/time into seconds in the format of DD:HH:MM:SS in my Reports Thanks Matt
  7. mbryantuk

    Optional Grouping with Drilldowns

    Hi I have 4 grouping levels in my table report with drilldowns i have 4 parameters which control the values of the grouping, Ideally i would like these to be optionals, i can get the visibility working correctly but i cant get the drilldowns working properly because i cant set the property to a...
  8. mbryantuk

    Changing a Time to a different timezone including DST

    Hi I have a hourly extract run by an SSIS package but the server is in the east coast of the US and the sites are in the US, UK and europe, currently i have a seperate package for each one but they do not take into account daylight savings time so when the clocks change i have to change the...
  9. mbryantuk

    2 header rows on a Matrix

    Hi I have a report where i have 8 columns of data and then it gets repeated for each month between 2 parameters, Above each group of 2 columns i would like a header above them kind of like a merged cell in excel | Column Header | | Column 1 | Column 2 | How would...
  10. mbryantuk

    Calculating percentages inside of same matrix group

    Hi I have a report containing a matrix, this matrix has a month column across the top and two groups Market and Response, so the report ends up looking like Oct-07 GRAND TOTAL 100% England 10% Accept 7% Reject 4% US 5%...
  11. mbryantuk

    Converting Ticks to seconds in SQL

    Hi Is it possible to convert Ticks stored in a table field to seconds using sql? Thanks Matt
  12. mbryantuk

    Defaulting the date parameter to be today - 7days

    Hi Is it possible to set the default value of a parameter to be a formula so i can default the date to be today minus 7 days? Thanks Matt
  13. mbryantuk

    DD:HH:MM:SS:MS??

    Hi I've managed to get a decminal value of seconds into HH:mm:ss:ms using convert(char(12), dateadd(millisecond, (sum(totalduration)-cast(sum(totalduration) as int))*100, dateadd(second, cast(sum(totalduration) as int), 0)), 114) but i have encounterd a issue where the value is too great...
  14. mbryantuk

    convertting Null to 0

    Hi I have a query with a Left Inner Join and it returns nulls from the right table which is ok, but i want to display these nulls as zeros in the my query thanks Matt
  15. mbryantuk

    counting time values

    Hi I have a long list of time values in the format hh:mm:ss:ms i need to add all of these together and return a cumulative value in the same format how can i do this in crystal? Thanks Matt
  16. mbryantuk

    convert decimal value to hh:mm:ss

    Hi I have a field storing the amount of seconds to perform an action e.g. 20.25 seconds is it possible to convert this to HH:mm:ss in crystal Thanks
  17. mbryantuk

    Converting Seconds as varchar into HH:MM:SS

    Hi I have a field storing the amount of seconds taken to perform an action and it is stored as a decimal value e.g. 100.52 seconds is it possible to convert this into a datetime so i can make it display in hh:mm:ss in my view Thanks Matt
  18. mbryantuk

    Difference between 2 times

    Hi I have 2 date fields start date and end date and i would like to get the time difference in HH:MM:SS so that i can store the data in a view for reporting, This would also need to handle going over the the next day so starting at 2300 and finishing at 0400 Thanks for your help Matt

Part and Inventory Search

Back
Top