In my office, we often use Microsoft SQL Server Reporting Service to produce any forms or report to within our system to support our office business. The same thing when we need to export some data into Excel or PDF, my team normally would setup a report base on  specific query and deploy it into a SQL Reporting Service Report, publish this report to user and so on. Problem is, for some reason, our user want the output directly goes to MS Excel, because they loveeeee soooo much with this spreadsheet.  So, it is my team task to generate report and instead make this show on report viewer it should goes directly to MS Excel.

After some page of SQL Server Manual, I finally found that there is a simple query string parm that we could pass into SQL Server Reporting Service URI and it will define how report would be produce. The query string parm is rs:format=Excel|PDF|HTML

So if we want to generate a report, and normally we will assign user to this kind of URI http://servername/reportserver?reportname&rs:Command=Render, we just need to add magical rs:Format parameter to that URI so it should looks like http://servername/reportserver?reportname&rs:Command=Render&rs:Format=Excel, and all are set to have a report launch directly to MS Excel.

Is not that difficult isn’t ?

When we talk about social life, then friend is everything. Because of them then our social is being built. So a little gift to impress them is always worth. And best time to have it is giving a favors on our event, having a baby birth, wedding or baptism. Thank to Bellissimofavors who provide their store online, so we always can have an option to find our party theme with affordable discount baby shower favors.

Navigate your site to this Bellissimofavors’s online store, and they will welcome you with tons of favors for baby shower, wedding, baptism and any event you could have. All are amazing and definitely will always make your name be remembered by your friend. Their online search and catalog category management are also set up to make any user visiting their web easy to find any favors they need. What we need to do is just browse, select our favors into cart and do checkout, have a good days ahead and Bellissimo will handle delivery for us. 

Read full story

Wow … it has been so long since my last post well, I have been very busy since few weeks back, me and wife are currently in progress of developing a new product to be sold in Internet, so wish me luck Okay for this post I would like to share my experience on supporting my very long distance client with a very free to used software, TeamViever.

So what is this TeamViewer all about, here is what this product official said about their product:

TeamViewer establishes connections to any PC or server all around the world within just a few seconds. You can remote control your partner’s PC as if you were sitting right in front of it

Read full story