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

I forgot to add i am using vs2008 on Win7

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 have had the rdl file i created in VS2005 deployed on a 2000 reporting server and got the error The report definition is not valid. Please verify that the report definition uses the current report definition namespace (rsNotACurrentReportDefinition) Thanks Matt

Thats good news, The report i have to create is reasonably basic it is a matrix with time across the top and category fields down the left no drill downs and only date parameters, can you export to xls and use the page breaks to more data between tabs as per 2005?

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

Apologies, its the toggle item property Because i can hide the grouping level, i cant change the plus in the group above to show the detail level instead of the next group Thanks Matt

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

I only have 1 server in the US where getdate() is Pacific Time, This server runs the extracts for the UK for example and i need this to display the dates in GMT and to also include Daylight savings as currently it is hard coded to 8 hours and it displayed incorrect times at the beginning of this...

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

Ok i will give it a go, As this is a weekly report is there any way of forcing the user to only select mondays? Thanks

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

cheers that is awesome exactly what we needed :)

Sorry im being stupid i just want the hours to keep increasing and not to stop at 24, thanks Matt