Links: Sites Created: Sites I like:
Excellence - http://excellence.bergren.net
Pics - http://picasaweb.google.com/rnbergren
Bibles - www.ilikebibles.com
Polk City - www.polkcity.org
Church - www.ridgelife.org
FCStone -
www.fcstone.com
http://www.efcpolkcity.com/
http://www.kruegerankeny.com/
http://www.hotwireds.com/
http://www.totalqualityinc.com/
www.npcitizensforprogress.com
DMACC - wwww.dmacc.edu
http://rnbergren.stumbleupon.com/
http://my.yahoo.com
www.geekbrieftv.com

Having fun being a father and a web geek.

Hello, my name is Rod Bergren

Who am Who am I?  I am a geek/programmer/webmaster/manager for the bestest company.  I write applications for Web Services and Windows.  I also do on the side contract programming as my time allows (which is not very much).

 

Monday, April 21, 2014

Keep together doesn't work in SSRS from 2005, 2008 and 2012
Referencing this known issue (feature) from Microsoft.  
https://connect.microsoft.com/SQLServer/feedback/details/428595/keep-together-property-not-working-in-ssrs-2008#tabs 

so I had a report with 4 detail lines,  One with a subreport and 3 that were basically header information for it to be formatted for the end user (consumer) of the data.  

It was breaking wherever it felt like in the report data lines.   Any which way.  and We had to leave it set up so they could enter as much text in their discussion points as they might want to enter.   So there was no way to force the issue for the users.  

Fun fun.  Right?  No so much.  

And Microsoft has known about this for like 5 years and has still not addressed the issue.  

So anyway.  I put a "hidden" group header on one of the fields.  It didn't really matter which one.  Then I set the group header to "keep together" and had it be white text on a white background and wow it worked.   Set the height down to 1pixel and the width to 1 pixel and set can grow to false.  Works like a charm.  kind of hokey though.  

Your welcome.

Friday, April 04, 2014

SSRS - Get the quarter from a Date String.
kind of really really easy.  But sometimes you get the easy ones.  It is almost like SSRS or Microsoft needs a return quarter of date in the date object.  But I cannot seem to find one.  Anyhoo,  I needed to return the current Quarter of the date.  Fairly easy to write actually.
    Function GetQuarterStr(ByVal theDate As String) As String
        Dim theNow As Date
        Dim astr As String
        theNow = CDate(theDate)
        Select Case Month(theNow)
            Case 1, 2, 3
                astr = "Q1"
            Case 4, 5, 6
                astr = "Q2"
            Case 7, 8, 9
                astr = "Q3"
            Case Else
                astr = "Q4"
        End Select
        Return astr
    End Function

Call it with.  Code.GetQuarterStr(thestringdate) 

Works wonderfully.
Wednesday, April 02, 2014

House in Western Iowa sunset.
just  gorgeous sunset.  out driving around with Daphne and having a great day.  It was a wonderful day for a drive.  warm and sunny all day.  Cannot beat Iowa.

Wednesday, March 19, 2014

High Wire Lines
always intriguing. Always slightly ugly.  They dot the landscape and they do denote progress. But there seriously get in the way of the view.  So.  I made this one the view.


Saturday, February 22, 2014

urbandale water tower looks like it is made of paper
yes it does.  the urbandale water tower looked like it was made out of paper.  just a big sign in the sky.  not made of metal.  it was really a pretty morning. 

winter in iowa.  always cold.  always interesting.  
Friday, February 14, 2014

Moon rise.

fantastic moon rises evening wonderful to watch.  I need to remember to watch this more often and take more pictures of it.

Friday, January 31, 2014

Time is Short
I often think about this.  I know that I do spend way too much time watching TV and doing things that really do not benefit myself or anyone.  Perhaps refocusing on those that are of benefit.  

From my morning ritual this morning.  From Billy Graham's devotions.

. Scripture says that God allows us 70 years and some beyond. The first 15 are spent in childhood and early adolescence. Twenty years are spent in bed; and in the last five, physical limitations start to curtail our activities. That gives us about 30 years in which to live as adults. We take time out for eating, and for figuring our taxes, and we are down to perhaps 15 years. Now suppose we spend seven of those years watching television. That cuts us down to seven or eight years. 

so we get to spend about 10% of our lives actually doing something.  Unless you cut out those things like TV.  Which means you can actually double your time accomplishing things.  

Something to think about while you watch the Super Bowl this weekend.
 

 


The Crew

  More pictures are here.

 
From Ariea

Papa's concert.


     

Other stuff of interest to people possibly.

Trip to Tahiti.

Belize is nice as well