Search Results

Search found 3 results on 1 pages for 'markpirvine'.

Page 1/1 | 1 

• ListChildren SQL Reporting Service

  - by markpirvine

  Hi, I'm trying to get a list of available reports via the webservice for SQL Reporting Services 2005 express edition. Each time I try to call the ListChildren method I get an insuffient permission exception. The code is: ReportingService2005SoapClient rService = new ReportingService2005SoapClient(); CatalogItem[] cItems = null; rService.ListChildren("/", false, out cItems); I added the ASP.net (iusr) account into the local admin group on the PC and still get the exception. Is this method supported in the express edition? Mark

  Read the article

• tsql sum data and include default values for missing data

  - by markpirvine

  Hi, I would like a query that will shouw a sum of columns with a default value for missing data. For example assume I have a table as follows: type_lookup: id name 1 self 2 manager 3 peer And a table as follows data: id type_lookup_id value 1 1 1 2 1 4 3 2 9 4 2 1 5 2 9 6 1 5 7 2 6 8 1 2 9 1 1 After running a query I would like a result set as follows: type_lookup_id value 1 13 2 25 3 0 I would like all rows in type_lookup table to be included in the result set - even if they don't appear in the data table. Any help would be greatly appreciated, Mark

  Read the article

• Call Generic method using runtime type and cast return object

  - by markpirvine

  I'm using reflection to call a generic method with a type determined at runtime. My code is as follows: Type tType = Type.GetType(pLoadOut.Type); MethodInfo method = typeof(ApiSerialiseHelper).GetMethod("Deserialise", new Type[] { typeof(string) }); MethodInfo generic = method.MakeGenericMethod(tType); generic.Invoke(obj, new object[] { pLoadOut.Data }); This works ok. However the generic.Invoke method returns an object, but what I would like is the type determined at runtime. Is this possible with this approach, or is there a better option? Mark

  Read the article

1