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


Sunday, November 23, 2014

Foggy drive

Foggy drive on the bridge, Daphne saw it, really cool I think

Friday, November 07, 2014

Another fabulous sunrise
Monday, October 27, 2014

End Zone. Where it all ends.
I guess that is why the word End is in the phrase?

Sunday, October 26, 2014

Daphne in the fog.
same Game.  Daphne in the Fog getting ready to play

Just fun to watch.

Saturday, October 25, 2014

Football in the Fog
Last night,  North Polk got to play football in the fog.   At one point the announcer said.  "I have no idea.  It might be a touchdown it might not.  The player juked left then went back right.  Then I lost him.  I have not clue."

It was a nice warm evening with no breeze and lots of fog.  Made for an interesting match.  PCM played well.  But the Comets ended up with the win.

Wednesday, October 15, 2014

Linking from into a List Item for Viewing or Editing the list. Project Server
Sometimes in Project Server (Microsoft Project server that is)  you are creating a report that shows the list items from the project site.  IE Issues, Risks, Deliverables.  

These can all be found in the reporting database and it comes contained in there.  Pretty easy stuff to find.  I will let you do the research for that.  

But once in awhile.  You have to link to the list item.  Mainly because there is just too much information that is in the item to show on a report and the end users want that drill down ability.  

I cannot say that I blame them.  

Anyhoo,  You need to know SharePoint at this point.  The linkage is pretty easy.  So lets say that I have a Risk for a Project and I want to be able to put an Edit this Item link into one of my reports.  The SQL is fairly easy.  If you know the project guid.  You just write SQL like

select r.RiskID, p.projectworkspaceinternalhref  as purl from msp_wssrisk inner join msp_epmproject_userview p on r.projectuid=p.projectuid  where projectuid = @guid

ok now you have the RiskID and the URL for the Project.  Want to create that link?

here is your formula

@purl + Lists + Risks + Editform.aspx + ?ID = @RiskID

so it should come out like the following

@purl = "http://projectserver1/projectsite1"
@RiskID = 1
full link should be

There you go.  Now you can give people that ability to edit the item

Want them to Just view
Replace Editform with DispForm
Entering a New Item?
drop the ?ID=#
use NewForm.aspx

Lots and lots of uses.  Issues, and Deliverables work the same way.  
I have not tested with Tasks especially not in 2013. 

Wednesday, October 08, 2014

Just another morning. Just another sunrise.
Just another sighting of God.  A friend the other day spoke to me about God and how I have been looking for God in nature.  He isn't far off.  But I look for God in glimpses.  glimpses of things.  a glimpse of a smile on a child's face when they see their mom,  a glimpse of a butterfly as it weirdly flies around.  the glimpse of a dog when its master enters the house.  and yes the glimpse of God as I drive across saylorville lake at 7am in the morning.  Yes there is a glimpse of God there.  He is everywhere though.  You just have to look.  God is there in your pain.  He is there in your frustration.  He is there when someone lies to you.  He is there when you get a hug.  He is there when it rains and when the sun is shining.

God is there.

And yes there is a picture.



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