You searched for the word(s): userid:740181

More Search Options

RSS Available

• Is there a component that can do nested subtotals in Excel?

  Does anyone know of a component that I can use to manipulate Excel files, that would allow me to add nested subtotals? (subtotalling on multiple columns at the same time). The only one I know about is Aspose Cells and 1 subtotal seems to work fine but when I do nested subtotals it just acts very screwy - expand/contract doesn't work right, there are multiple grand totals, subtotals out of order, etc. I'm waiting for the customer service department to tell me how long a fix will take but in

  Posted to Component Discussions (Forum) by tmmycat on 8/28/2009

• Simple beginner question - how to put the field value in the subtotal label?

  I have a matrix and all I want to do is put the field name in the subtotal label. For example if I'm subtotalling values for each client then I want the subtotal labels to say "Endo Pharmaceuticals Total", "Forest Total", "Merck & Co. Total" etc - instead of just "Total." I tried putting =Fields!ClientName.Value & " Total" in the subtotal textbox Expression, Value, and Label properties ... since ClientName is the name of the field I want

  Posted to SQL Server Reporting Services (Forum) by tmmycat on 7/30/2009

• Re: Simple beginner question - how to put the field value in the subtotal label?

  Sure - here's my RDL (btw I changed the field name to Client instead of ClientName so don't be alarmed that it's different below) <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <DataSources> <DataSource Name="New Millennium Tester"> <rd:DataSourceID>c621a8aa

  Posted to SQL Server Reporting Services (Forum) by tmmycat on 7/30/2009

• Re: Simple beginner question - how to put the field value in the subtotal label?

  Sorry, I don't understand... I'm doing everything in the designer ... I'm just using the toolbox and properties window. The RDL file is the only code I know of. Did you want a screen shot of the properties window? I'm accessing it with the "Preview" tab in Business Intelligence Development Studio if that helps.

  Posted to SQL Server Reporting Services (Forum) by tmmycat on 7/30/2009

• Re: Simple beginner question - how to put the field value in the subtotal label?

  How would you do what I'm trying to do if you were doing it your own way? That could probably give me a hint about what to google for.

  Posted to SQL Server Reporting Services (Forum) by tmmycat on 7/30/2009

• Re: Is it possible to "rename" properties in an inherited class? or create property aliases?

  ok, thanks! I am going with something like this: List<Rep> reps = new List<Rep>(); foreach (Consultant c in Consultants) reps.Add(c.Rep); Import(reps); (I was hoping to avoid that loop to make it faster, but in the end it's ok since it seems unavoidable!)

  Posted to Architecture (Forum) by tmmycat on 4/27/2009

• Re: Is it possible to "rename" properties in an inherited class? or create property aliases?

  I have a question though ... is it possible to set it up so that I can a function that accepts one class or the other as a parameter (without rewriting all of my rep import logic for both classes)? For example what if I want to do something like this.... public void Import(List<T> reps) where T is either Consultant or Rep... I have some complicated code in that Import function and I really don't want to overload 2 copies of it, one for each type of parameter ... if it's possible...

  Posted to Architecture (Forum) by tmmycat on 4/27/2009

• Re: Database migration practices

  I am curious about this topic too - right now I just save a copy of every T-SQL change I make (alter procedure / create procedure / adding new rows to lists / creating new tables / adding columns) and I save the files with a prefix in the file name to indicate the order I made the changes in, then when I'm ready to deploy to staging I combine these change files into one big SQL script that I can run on the staging database. (or on the production database later). This works, but it's a little

  Posted to Architecture (Forum) by tmmycat on 4/27/2009

• Re: Is it possible to "rename" properties in an inherited class? or create property aliases?

  Thanks! Hmmm, I think I get it ... that would translate into something like this right? this would work! public class Consultant { private Rep rep; public Consultant() { rep = new Rep(); } public string ConsultantCode { get { return rep.Territory; } set { rep.Territory = value ; } } public string Region { get { return rep.District; } set { rep.District = value ; } } public string Area { get { return rep.Region; } set { rep.Region = value ; } } }

  Posted to Architecture (Forum) by tmmycat on 4/27/2009

• Is it possible to "rename" properties in an inherited class? or create property aliases?

  I have a client who wants to use the following wording for one of the web service parameters...they would be really confused if it's not this wording.... public class Consultant { public string ConsultantCode; public string Region; public string Area; } This is totally different from the wording my application uses and it would really consfusing to me to use their wording everywhere I need to use this class. To my application, a ConsultantCode is a Territory, a Region is a District, and an Area

  Posted to Architecture (Forum) by tmmycat on 4/27/2009