Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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