Recent content by graabein

Problem solved (not really). When I export to Excel the whitespaces appear so it was just the HTML rendering that fooled me. If somebody finds a solution to this I'm still interested in knowing it. There are times you want to control screen rendering also. [elephant2] graabein

Incredible. I even tried selecting everything into a single text column from the database but SSRS still trimmed multiple whitespaces within the table cell! Somebody shoot me! LOL. [elephant2] graabein

Hi, I have to create a text file that outputs data in certain chuncks like this: Name, 10 chars [1-10] Number, 2 chars [11-12] Code1, 3 chars [13-15] Code2, 3 chars [16-18] I put all the fields from the dataset next to eachother in a single table cell and the idea is to let the user export to...

Not yet. Been busy working on another project. I've bookmarked this page for later reference. [elephant2] graabein

LOL nice coincidence! Thanks man. [elephant2] graabein

I think I did it! Check this out: select Work.Code, count(*) from ( select Code1 as Code from table1 union all select Code2 as Code from table1 ) as Work where Work.Code is not null group by Work.Code What do you think? [elephant2] graabein

Hi, I have a sort of stupid table structure on the project I inherited. It's a list of what work was performed that uses codes like this: CustomerID | Date | Code1 | Code2 | Code3 | Code4 I want to know all work that was performed for a certain period and thus need to count the distinct codes...

Thanks Joe, I'll update my code with that. Another thing, can I get the line number with Erl? error_handler: Dim errNum As Long Dim errDesc As String Dim lineNum As Long errNum = Err.Number errDesc = Err.Description lineNum = Erl [elephant2] graabein

The bug occurs in production and I can't recreate it on my development environment. [elephant2] graabein

Well I'm trying to write some tests to run on the code (not written yet). They're not registrations of the same thing, they're a series of events connected with a bigger operation so we need to know what happened when for later on. Some of these events have to be in the proper order. Thanks for...

Thanks, I have mztools installed but wasn't aware of Erl! [elephant2] graabein

Hi, I'm looking for some advice on cornering an annoying bug I cannot recreate! I'll just paste the code here: Public Sub CreateView( _ lv As ListView, _ lvTemp As ListView, _ dtFromDate As Date, _ dtToDate As Date, _ Optional sFilter As String = "" _ ) Dim rs As New...

The user registers a list of dates. I want to see if they are in order. [elephant2] graabein

Here is what I've got so far but it's probably not the best way to go about this. Suggestions are welcome! private bool IsSorted(ObservableCollection<CustomEntity> coll) { List<DateTime> unsorted = (from n in coll where n.EventDateTime > DateTime.MinValue select...

Hi, I'm pretty new to C# .Net 3.5 so go easy on me... I want to test if a list of dates is sorted. I use LINQ to extract the DateTime field from a ObservableCollection<T> with either ToArray or ToList. I do this twice, with and without orderby clause. The (simple?) problem is how do I compare...