Links: Sites Created: Sites I like:
Excellence -
Pics -
Bibles -
Polk City -
Church -
FCStone -

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


Friday, October 30, 2015

SSRS BI Deployment Error. Works fine in IDE. Error rsProcessingError : There is an error on line ## of custom code: [BC30203] Identifier expected.

Weird error.  Error rsProcessingError : There is an error on line ## of custom code: [BC30203] Identifier expected.

The full error is more like the following

Error rsProcessingError : There is an error on line 93 of custom code: [BC30203] Identifier expected.
Deploy complete -- 1 errors, 0 warnings

And this only happens when deploying to the SSRS server.  Otherwise inside the IDE the report renders perfectly fine and all is happy with the world. 

And of course line ## 93 in my case has no meaning at all for me.  In fact if I take the code from the Report properties window and copy it into Notepad and go to line 93.  Want to guess where I am in the code base?

    End Function
    ''' Function should return

Right between those two lines where the yellow is highlighted.

Yes this makes so much sense. 

And the error?  The error is nowhere near where line 93 is. 

Fortunately I had only just changed a function to add some parameters.  I needed to make some fairly extensive changes to this procedure and I thought for readability I would wrap it into two lines.  That works in Visual Studio for VB code.  Does it work for the report.  Works fine in the IDE.  – YAY.  So my function instead of running off the box to the right.  It shows everything fairly well.

      Function StageCoachReturn(ByVal strLaunch As String,
ByVal dteLaunch As Date, ByVal tripStartDate As Date,
            ByVal strCurStatus As String, ByVal strStage As String,
ByVal iSNGID As Integer)

Guess what doesn’t like this?  You guessed it.  SSRS server.  Its pre-processor is not as forgiving as the IDE and throws the error.  I think it is only guessing at the line number. 

Take out the carriage return in the function call and deployment works just fine.

      Function StageCoachReturn(ByVal strLaunch As String, ByVal dteLaunch As Date, ByVal prjStartDate As Date, ByVal strCurStatus As String, ByVal strStage As String, ByVal strSNGID As Integer)

Oyi. There are days. 
Sunday, September 27, 2015

Moon rise over Saylorville

This is gorgeous moon rise of the saylorville. Fun to be out fishing with my son. Wonderful, evening

Wednesday, September 02, 2015

The rain is over for today
Sunday, August 23, 2015

Lawsuits, Opinion Polls and Common Sense oh my!

so on whotv's website today.  Headline says.  Bedbug problem still exists despite lawsuit.  hmmm, I didn't know lawsuits solved problems.  So people remember this. 

Lawsuits do not solve problems.  They only point out where problems might exist.  You will notice I said might.  I didn't say does exist.   Think about that for abit. 

Opinion Polls do not mean anything except for in the actual vote.  So when people are asked if they believe global warming exists.  How they answer has absolutely no impact on whether global warming is happening or not

Asking hollywood for their opinion is actually worse than either of the above.

The truth is out there.  But you must search for it.  Guess what.  CNN, FOX, AP etc… have no idea what the truth is.  And they won't have any idea what the truth is when it hits them upside the head.  It is like the newspapers 15+ years ago denying that the Internet was NOT going to impact their business.  Hmmmmm lots of newspapers are out of business.

IT is like blockbuster ignoring the trend of streaming video.  Guess what?  Netflix won that one.

This country is in some serious need of some common sense.  And some communication.  I have a friend that says we really just need to have people with some sense to them being listened too.  Guess what.  You should probably listen. 

Me too. 

PS not sure where I got this cartoon from.  If someone knows.  I will certainly give credit where it is due.  

Friday, July 31, 2015

When the Moon in the Sky looks like a big pizza pie
Shooting the moon can be challenging and getting it to look like you think it look takes a bit of photoshop.  But this was the moon last night and yes it was gorgeous.

Have a great weekend everyone.

Thursday, June 18, 2015

Keep a Daily Journal.
I have been doing this life lesson thing now every Thursday for at least a year.  These thoughts are from some emails over the years and thoughts that I have written down as well.  

Today's Thursday Life Lesson is keep a daily journal.  

I do, I have, and I will continue to do so.

I cannot recommend this one highly enough.  Unless you do not care to improve who you are.  If you don't want to help your family grow as people.  If you do not want to remember the good things you do each day.  Especially those days that are awesome many years later.  

Seriously do this one thing.  Write down each day what was good.  Who you helped.

Not all of us have the same experiences and at the end of our lives the only thing we have to take back to God is our experiences in this life.  Yes I have done some very major sins.  Yes I have.  but I have also had some absolutely awesome joys.  My children being born, Celebrating aniversaries, Watching my Oldest do awesome at Speech, Listening to my Middle one fill a very large room with her awesome voice,  Having my son just grow and talking with him about stuff.  Walks with my wife.  These are items I need to write down.  I need to record these in my memory banks so that I can take them with me.  Only the memories can you take with you.  

How did this start?  Basically it started out as a diary.  It was in reaction to a injury a boss inflicted upon my work ethic.  Details on this do not matter.  But what came out of this was an introspection daily of who I am and where am I headed.  I started just putting in the diary my start times, my lunch periods, my ending time and small notes of what I accomplished.  Pretty soon I was putting goals of where I wanted to be.

Eventually this grew into a journal.  It has been going on now for 17 years or so.  I have a loads of old journals at home.  The kids can read them when I am gone.  If they care.  If they don't.  I really don't care.  

Where is this now?  
I still record what I accomplished each day.  But I also have goals, and my goals are specific for me.  But they are aimed at others.  Did I help my spouse today.  did I encourage her.  (Sometimes sadly this is no),  did I remember to take my blood pressure medicine?  Did I build up each of my children each day.  Sometimes this is as simple as just being in prayer over them and their lives.  My children don't even know how much that happens.  Not until they have children will they know.  Did I work towards my goals?  And lastly how was the day?  honestly?  I have some seriously horrible days.  horrible thoughts and actions.  I am honest with myself about these.  I record these and then I ask for forgiveness and try not to do that one again and just move on.

Journal.  Do it.  Seriously 

Monday, June 15, 2015

Pretty evening on the lake

Gorgeous evening on the lake hanging out with the kids and the wife taking pictures



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