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).
Tuesday, April 17, 2012
Clouds this morning on the drive to work
camera phone again. Seriously I love Iowa. the weather here this time of year is awesome
Thursday, April 05, 2012
This mornings sunrise from the camera phone
Wednesday, March 28, 2012
Possible Cross winds on bridge? you think so?
This is my view each evening on my way home from work. Always always look at the windsock to make sure my SUV won't be blown off the bridge.
Friday, March 23, 2012
Jessica Wrote this.
Personally I think this is awesome and it gives me alot of hope for the future generations. That she has taken the time to be introspective enough to see how awesome these people are. She loves going to see Charlie(my dad's best friend) and I never really understood why until I heard this story from her. Pretty awesome I think.
Bored? Don’t deny it, we both know you are. All that social networking has left you a bit- well, antisocial-hasn’t it? Or maybe, you’re just bored of that screen, because let’s face it, the reality contained there is entirely superficial. Maybe a good old-fashioned book would do you well. Allow me to suggest a solution? A less.... well, boring one?Well, here it is: go to bed early tonight. Then, in the morning, wake early and find the place where the older gentlemen meet. You know where it is. Maybe you usually avoid it at all costs. It could be a gas station, a nearby family-owned cafe, or even a McDonald’s. They’ll be wherever the coffee refills are free and the food is decent. Extra points if one of the gentlemen is a relative or friend of your family.Once you get there, it is imperative that you do not speak unless spoken to: not because they look down on this, but because there’s so much to learn. If they ask for your opinion on something, answer honestly. Even if it conflicts with their opinion. In fact, almost better if it conflicts- they love to argue about anything and everything: from politics to current events- even the weather is debatable! Is it sleeting or snowing? Raining or sprinkling? They’ll pick your argument apart though, so you had better be well-examined morally. Their logic is (usually) reasonable, and if you don’t have logic behind your argument, you should better be prepared to get shot down. However, this makes for some interesting contemplation. In addition to arguing, these men know how to tell stories. Stories of laughter- weddings gone right (or wrong), births, those- darned-kids, and they might ask you what the heck does this button do to my computer anyways? They’ll tell you stories of young foolishness: their first time with a woman, running away from home, enlisting too young, and drunk Friday nights (yes, they did that too.). Should you heed the advice of those older and wiser than you or pursue you own path- which may or may not be exactly the same as theirs turned out to be?
But there will also be stories of pain.War.Death- of children, lovers, spouses. You might cry with-or for-them.And these are the things from which they never fully recover. These people know that. They know that all they can do is soldier on, and try to find hope again. They just have to live with it- have to live with the pain of missing that person. Have to deal with what they’ve seen, and cannot unsee. Have to deal with losing a part of themselves along with each experience along the road.They will teach you, if you listen. They will tell you that life is worth living. They will tell you that your story is important- no matter who you are or what you’ve done.And how do they know that? Because they are confident that they are important. They’re confident that somewhere out there, they’ve changed someone’s life. And they’re proud of it.Go visit them. Hear their stories. And when you’re old enough, contribute your own.
Wednesday, March 07, 2012
Doing and Inner Join on a SharePoint list with SSRS.
Yes you can do this. It takes but a moment and you have to work around the limitation of SSRS and SharePoint Lists.
Normally in SQL you have two tables. Parents and Children and you have an ID field that joins them together. In this instance you have Parent ID. So each Child will be assigned a parent ID and your SQL would look something like the following.
Select ParentName, ParentID, ChildName, ChildID from Parents inner join Children on Parents.ID = Children.ParentID
And that works great in SQL but not so much in SharePoint and SSRS. And yes you “should” be able to use XML selects to do this. Unfortunately in SSRS 2008 this option does not exist. You cannot do this. You can only do straight selects against one list at a time per SharePoint list. IE something like the following. (replace square backet with less than)
[RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
[ListName>Parents
[ViewFields>
[FieldRef Name="Title" />
[FieldRef Name="ID" />
[/ViewFields>
[/RSSharePointList>
UGH! Yeah it is ugly but it works for easy selects. You just have two datasets and put one inside the table of the others either with a subreport or with another table within the other. You then link the subreport to the master report with the Parent ID. It works and works pretty well.
See
This is just a Children Subreport embedded within the Parent Listing report. Ok so that is slightly complicated but not impossible.
But. There always is one isn’t there. The next thing the Upper Bee is going to ask for. Is I want to only see the Parents Who have Children who are Seniors or some such selection. Or even worse I want to see the Families who have a current Senior. I want to know potentially how many seats I am going to need setup in the families only section for graduation.
UGH! Major ugh. In a SharePoint list with SSRS you really cannot do this straight forward. Unless? IDEA Bulb. You add in another dataset to the Main Report that includes the Children selection then filter the parents based upon that selection.
So here it goes
My query Designer
My filter setup
Then setup a parameter based upon this new dataset
Fill out General, Available and default as you see here
Now go back to your Primary Dataset. Go to the Filter Properities and add in a Filter for PArentID in the Children.PArentID parameter.
And it should just work
As you can see the variety of applications for this is impressive. You can now fairly easily do an inner join between to tables and heck even a left outer join. With the inner join just pass the parameter for 12 all the way thru to the subreport and there you go. If you setup everything as parameters all your lookup lists are now valuable again and you are getting to the point where SharePoint List reporting is actually fairly easily accomplished. Without Microsoft Access.
Tuesday, March 06, 2012
The snow broke this one
What little snow there was this year broke this tree down to size. Just look at the hole it created in that grove. I wonder if anyone heard the break since it is at least 1/2 mile from any house. That if a tree falls in the forest does it make a sound discussion.
Friday, February 24, 2012
morning glory sunrise
Before the snow the sunrise
More
pictures are here.
From Ariea
Other stuff of interest to people possibly.
Trip to Tahiti.
Belize
is nice as well
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.kruegerankeny.com/
http://www.hotwireds.com/
http://www.totalqualityinc.com/
www.npcitizensforprogress.com
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).
| Tuesday, April 17, 2012 Clouds this morning on the drive to work 
|
| Thursday, April 05, 2012 This mornings sunrise from the camera phone 
|
| Wednesday, March 28, 2012 Possible Cross winds on bridge? you think so?  This is my view each evening on my way home from work. Always always look at the windsock to make sure my SUV won't be blown off the bridge.
|
| Friday, March 23, 2012 Jessica Wrote this. Personally I think this is awesome and it gives me alot of hope for the future generations. That she has taken the time to be introspective enough to see how awesome these people are. She loves going to see Charlie(my dad's best friend) and I never really understood why until I heard this story from her. Pretty awesome I think. Bored? Don’t deny it, we both know you are. All that social networking has left you a bit- well, antisocial-hasn’t it? Or maybe, you’re just bored of that screen, because let’s face it, the reality contained there is entirely superficial. Maybe a good old-fashioned book would do you well. Allow me to suggest a solution? A less.... well, boring one? Well, here it is: go to bed early tonight. Then, in the morning, wake early and find the place where the older gentlemen meet. You know where it is. Maybe you usually avoid it at all costs. It could be a gas station, a nearby family-owned cafe, or even a McDonald’s. They’ll be wherever the coffee refills are free and the food is decent. Extra points if one of the gentlemen is a relative or friend of your family. Once you get there, it is imperative that you do not speak unless spoken to: not because they look down on this, but because there’s so much to learn. If they ask for your opinion on something, answer honestly. Even if it conflicts with their opinion. In fact, almost better if it conflicts- they love to argue about anything and everything: from politics to current events- even the weather is debatable! Is it sleeting or snowing? Raining or sprinkling? They’ll pick your argument apart though, so you had better be well-examined morally. Their logic is (usually) reasonable, and if you don’t have logic behind your argument, you should better be prepared to get shot down. However, this makes for some interesting contemplation. In addition to arguing, these men know how to tell stories. Stories of laughter- weddings gone right (or wrong), births, those- darned-kids, and they might ask you what the heck does this button do to my computer anyways? They’ll tell you stories of young foolishness: their first time with a woman, running away from home, enlisting too young, and drunk Friday nights (yes, they did that too.). Should you heed the advice of those older and wiser than you or pursue you own path- which may or may not be exactly the same as theirs turned out to be? But there will also be stories of pain. War. Death- of children, lovers, spouses. You might cry with-or for-them. And these are the things from which they never fully recover. These people know that. They know that all they can do is soldier on, and try to find hope again. They just have to live with it- have to live with the pain of missing that person. Have to deal with what they’ve seen, and cannot unsee. Have to deal with losing a part of themselves along with each experience along the road. They will teach you, if you listen. They will tell you that life is worth living. They will tell you that your story is important- no matter who you are or what you’ve done. And how do they know that? Because they are confident that they are important. They’re confident that somewhere out there, they’ve changed someone’s life. And they’re proud of it. Go visit them. Hear their stories. And when you’re old enough, contribute your own.
|
| Wednesday, March 07, 2012 Doing and Inner Join on a SharePoint list with SSRS. Yes you can do this. It takes but a moment and you have to work around the limitation of SSRS and SharePoint Lists. Normally in SQL you have two tables. Parents and Children and you have an ID field that joins them together. In this instance you have Parent ID. So each Child will be assigned a parent ID and your SQL would look something like the following. Select ParentName, ParentID, ChildName, ChildID from Parents inner join Children on Parents.ID = Children.ParentID And that works great in SQL but not so much in SharePoint and SSRS. And yes you “should” be able to use XML selects to do this. Unfortunately in SSRS 2008 this option does not exist. You cannot do this. You can only do straight selects against one list at a time per SharePoint list. IE something like the following. (replace square backet with less than) [RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> UGH! Yeah it is ugly but it works for easy selects. You just have two datasets and put one inside the table of the others either with a subreport or with another table within the other. You then link the subreport to the master report with the Parent ID. It works and works pretty well. See This is just a Children Subreport embedded within the Parent Listing report. Ok so that is slightly complicated but not impossible. But. There always is one isn’t there. The next thing the Upper Bee is going to ask for. Is I want to only see the Parents Who have Children who are Seniors or some such selection. Or even worse I want to see the Families who have a current Senior. I want to know potentially how many seats I am going to need setup in the families only section for graduation. UGH! Major ugh. In a SharePoint list with SSRS you really cannot do this straight forward. Unless? IDEA Bulb. You add in another dataset to the Main Report that includes the Children selection then filter the parents based upon that selection. So here it goes My query Designer My filter setup Then setup a parameter based upon this new dataset Fill out General, Available and default as you see here Now go back to your Primary Dataset. Go to the Filter Properities and add in a Filter for PArentID in the Children.PArentID parameter. And it should just work As you can see the variety of applications for this is impressive. You can now fairly easily do an inner join between to tables and heck even a left outer join. With the inner join just pass the parameter for 12 all the way thru to the subreport and there you go. If you setup everything as parameters all your lookup lists are now valuable again and you are getting to the point where SharePoint List reporting is actually fairly easily accomplished. Without Microsoft Access.
|
| Tuesday, March 06, 2012 The snow broke this one  What little snow there was this year broke this tree down to size. Just look at the hole it created in that grove. I wonder if anyone heard the break since it is at least 1/2 mile from any house. That if a tree falls in the forest does it make a sound discussion.
|
| Friday, February 24, 2012 morning glory sunrise  Before the snow the sunrise
|
More pictures are here.
|
| |
| From Ariea |
Other stuff of interest to people possibly.
Trip to Tahiti.
Belize is nice as well