Data Extensions - Through Business Logic

I have a multi-tier application that does a lot of business processing of
data. I am looking for a way to use SQL Report Server to render reports
based upon this data. I have looked at several examples of extensions and
built one using a serialized XML file. What I am looking for though is to be
able to create an extension that uses data that has been processed from the
business logic in real time without creating a serialized XML file. Any help
would be appreciatedHave you check my DPE? It serializes the dataset and passes it as a
parameter to the report.
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
As a side node, the new controls in RS 2005 will support standalone mode
where you could bind your report to a dataset.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mkola" <mkola@.discussions.microsoft.com> wrote in message
news:C3E61BE8-D8E8-4330-8C0E-BD0221BC3BD4@.microsoft.com...
> I have a multi-tier application that does a lot of business processing of
> data. I am looking for a way to use SQL Report Server to render reports
> based upon this data. I have looked at several examples of extensions and
> built one using a serialized XML file. What I am looking for though is to
be
> able to create an extension that uses data that has been processed from
the
> business logic in real time without creating a serialized XML file. Any
help
> would be appreciated|||THanks for the Sample Teo. I will look into it today...
Mark
"Teo Lachev [MVP]" wrote:
> Have you check my DPE? It serializes the dataset and passes it as a
> parameter to the report.
> http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
> As a side node, the new controls in RS 2005 will support standalone mode
> where you could bind your report to a dataset.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "mkola" <mkola@.discussions.microsoft.com> wrote in message
> news:C3E61BE8-D8E8-4330-8C0E-BD0221BC3BD4@.microsoft.com...
> > I have a multi-tier application that does a lot of business processing of
> > data. I am looking for a way to use SQL Report Server to render reports
> > based upon this data. I have looked at several examples of extensions and
> > built one using a serialized XML file. What I am looking for though is to
> be
> > able to create an extension that uses data that has been processed from
> the
> > business logic in real time without creating a serialized XML file. Any
> help
> > would be appreciated
>
>

Data driven subscriptions and scale-out?

Say I have a scheduled data-driven reports that will product pdf files (a lot). Will this benefit
from scale-out?

I.e., having one SQL Server with the reporting services databases and several
servers with the reporting services windows service and web services.

I have this feeling that when the Agent job starts, it will do this in a matter so that all the
reports for this job will be processes on only one RS server? Or perhaps I can partition this
myself, where I somehow have several jobs, each job connecting to a different server generating a
subset of the reports?

No replies so I tested it myself. After lots of hassle to get scale-out installed, but I finally got it working. And the answer is Yes.

I processed a data-driven subscription to generate bunch of pdf files and CPU went up on both RS machines. Also looking in the RS log files I can see that each RS machine processed different PDF files.

Data driven subscriptions and scale-out?

Say I have a scheduled data-driven reports that will product pdf files (a lot). Will this benefit
from scale-out?

I.e., having one SQL Server with the reporting services databases and several
servers with the reporting services windows service and web services.

I have this feeling that when the Agent job starts, it will do this in a matter so that all the
reports for this job will be processes on only one RS server? Or perhaps I can partition this
myself, where I somehow have several jobs, each job connecting to a different server generating a
subset of the reports?

No replies so I tested it myself. After lots of hassle to get scale-out installed, but I finally got it working. And the answer is Yes.

I processed a data-driven subscription to generate bunch of pdf files and CPU went up on both RS machines. Also looking in the RS log files I can see that each RS machine processed different PDF files.

Data Driven Subscriptions

Hello,
I have an installation of Reporting Services with SQL
Server 7.0 SP3. One of my reports is a data driven
subscription and it worked wonderfully.
Then, I applied Reporting Services Service Pack 1 and now
the data driven subscription does not work.
Any ideas?
Thanks,
DaveSorry, SQL Server 2000 SP3
>--Original Message--
>Hello,
>I have an installation of Reporting Services with SQL
>Server 7.0 SP3. One of my reports is a data driven
>subscription and it worked wonderfully.
>Then, I applied Reporting Services Service Pack 1 and now
>the data driven subscription does not work.
>Any ideas?
>Thanks,
>Dave
>.
>

Data driven subscription: if no report data => do not deliver

I am wondering if there is a simple way to tell the report server to not
deliver a report if there is no data in the report.
I have several reports which have table layout to display a set of data IF
there happens to be data. One example is that I have a polling process
looking at certain tables in SQL Server every 10 minutes. Is there a quick
way to not send me an e-mail if there isn't data to look at?
Thanks!
DavidCurrently there is not, although this feature has been requested several
times. The only way to do it now is to construct the Data Driven
Subscriptions query to return no rows when the report will return no rows.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"david boardman" <davidboardman@.discussions.microsoft.com> wrote in message
news:8D692421-D6E1-4185-B66B-3E2356F59CB6@.microsoft.com...
>I am wondering if there is a simple way to tell the report server to not
> deliver a report if there is no data in the report.
> I have several reports which have table layout to display a set of data IF
> there happens to be data. One example is that I have a polling process
> looking at certain tables in SQL Server every 10 minutes. Is there a
> quick
> way to not send me an e-mail if there isn't data to look at?
> Thanks!
> David|||Hi,
I have a similar data-driven subscription. The first query determines the
receivers for email, the second query prepares the email content for the
corresponding receiver.
So as Daniel wrote, first I had to eliminate no-data records then run the
query for the remaining set.
"david boardman" wrote:
> I am wondering if there is a simple way to tell the report server to not
> deliver a report if there is no data in the report.
> I have several reports which have table layout to display a set of data IF
> there happens to be data. One example is that I have a polling process
> looking at certain tables in SQL Server every 10 minutes. Is there a quick
> way to not send me an e-mail if there isn't data to look at?
> Thanks!
> David|||I guess I can post my interim solution for those looking to at least have
something working. I just am looking for a more elegant/built in solution.
For data-driven subscriptions, RS requires you to specify an SQL query which
returns data to the subscription (things like what e-mails to send to, and
what parameters to pass to the actual report, if any). I exec a stor proc in
order to return this information back to my subscription. The key lies in
the stor proc being called.
The stor proc which feeds the data driven subscription ends up calling the
stor proc which returns data for the report (which in reality is completely
compartmentalized from the subscription itself). The subscription proc
checks to see if at least 1 row of data is returned by the report proc. If
the report stor proc returns no data, then the subscription stor proc returns
a NULL SET back for the e-mail addresses to deliver the report to.
I don't know if I'm capitalizing on a bug or not, but there is no error
generated in the log files. I guess the report is actually generated (with
no data) and delivered into never-never land.
Hope I explained what I'm doing clearly, but just wanted people to know
there is an interim solution, although some what cludgy.
Cheers!
"eralper" wrote:
> Hi,
> I have a similar data-driven subscription. The first query determines the
> receivers for email, the second query prepares the email content for the
> corresponding receiver.
> So as Daniel wrote, first I had to eliminate no-data records then run the
> query for the remaining set.
>
> "david boardman" wrote:
> > I am wondering if there is a simple way to tell the report server to not
> > deliver a report if there is no data in the report.
> >
> > I have several reports which have table layout to display a set of data IF
> > there happens to be data. One example is that I have a polling process
> > looking at certain tables in SQL Server every 10 minutes. Is there a quick
> > way to not send me an e-mail if there isn't data to look at?
> >
> > Thanks!
> > David|||This is by design from the perspective of RS. If the query used to generate
the notifications returns no rows then the report will not be run for that
instance of the subscription until the next time it fires and the query
returns data.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"david boardman" <davidboardman@.discussions.microsoft.com> wrote in message
news:7855BBDB-18BB-4191-86A1-778126B1D049@.microsoft.com...
>I guess I can post my interim solution for those looking to at least have
> something working. I just am looking for a more elegant/built in
> solution.
> For data-driven subscriptions, RS requires you to specify an SQL query
> which
> returns data to the subscription (things like what e-mails to send to, and
> what parameters to pass to the actual report, if any). I exec a stor proc
> in
> order to return this information back to my subscription. The key lies in
> the stor proc being called.
> The stor proc which feeds the data driven subscription ends up calling the
> stor proc which returns data for the report (which in reality is
> completely
> compartmentalized from the subscription itself). The subscription proc
> checks to see if at least 1 row of data is returned by the report proc.
> If
> the report stor proc returns no data, then the subscription stor proc
> returns
> a NULL SET back for the e-mail addresses to deliver the report to.
> I don't know if I'm capitalizing on a bug or not, but there is no error
> generated in the log files. I guess the report is actually generated
> (with
> no data) and delivered into never-never land.
> Hope I explained what I'm doing clearly, but just wanted people to know
> there is an interim solution, although some what cludgy.
> Cheers!
> "eralper" wrote:
>> Hi,
>> I have a similar data-driven subscription. The first query determines the
>> receivers for email, the second query prepares the email content for the
>> corresponding receiver.
>> So as Daniel wrote, first I had to eliminate no-data records then run the
>> query for the remaining set.
>>
>> "david boardman" wrote:
>> > I am wondering if there is a simple way to tell the report server to
>> > not
>> > deliver a report if there is no data in the report.
>> >
>> > I have several reports which have table layout to display a set of data
>> > IF
>> > there happens to be data. One example is that I have a polling process
>> > looking at certain tables in SQL Server every 10 minutes. Is there a
>> > quick
>> > way to not send me an e-mail if there isn't data to look at?
>> >
>> > Thanks!
>> > David

Data Driven subscription not working for PDF, IMAGE

Hi,
I worked on SQL Server tutorials in Books online, "Data Driven
Subscription". In this tutorial, reports are delivered via email on a
scheduled time. as per the tutorial emails are being delivered in "MHTML"
format but it does not deliver the report in "PDF" or "Image" format. The
report manager shows a status message that there was an error but there is
no way to know the exact error. It just says "1 errors". The reprot is
working absolutely fine as it is being delivered in "MHTML" format but not
in "PDF" or "IMAGE". Please assist.
Regards
GinnyJust check in errorlog file for any specific errors. Just manually run the
same report and see whether it gives the same error.
Amarnath
"Ginny" wrote:
> Hi,
> I worked on SQL Server tutorials in Books online, "Data Driven
> Subscription". In this tutorial, reports are delivered via email on a
> scheduled time. as per the tutorial emails are being delivered in "MHTML"
> format but it does not deliver the report in "PDF" or "Image" format. The
> report manager shows a status message that there was an error but there is
> no way to know the exact error. It just says "1 errors". The reprot is
> working absolutely fine as it is being delivered in "MHTML" format but not
> in "PDF" or "IMAGE". Please assist.
> Regards
> Ginny
>
>

Data Driven Subscription Not Available

I am trying to create a data driven subscription. However, on the
Subscriptions tab for the reports the New Data-Driven Subscription selection
is not present. Only the New Subscription selection is present. I can
create regular subscriptions but need to create a data driven subscription.
Is there something in the config file that needs changed to enable data
driven subscriptions?Do you have Standard or Enterprise. Data driven subscriptions is a
Enterprise feature.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>I am trying to create a data driven subscription. However, on the
> Subscriptions tab for the reports the New Data-Driven Subscription
> selection
> is not present. Only the New Subscription selection is present. I can
> create regular subscriptions but need to create a data driven
> subscription.
> Is there something in the config file that needs changed to enable data
> driven subscriptions?|||Data driven subscriptions are only available with SQL Server Enterprise
Edition.
Are you running Standard?
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>I am trying to create a data driven subscription. However, on the
> Subscriptions tab for the reports the New Data-Driven Subscription
> selection
> is not present. Only the New Subscription selection is present. I can
> create regular subscriptions but need to create a data driven
> subscription.
> Is there something in the config file that needs changed to enable data
> driven subscriptions?|||I thought I was running Enterprise everywhere but on this server it is only
the Standard edition. We are planning on upgrading to SQL Server 2005 1Q06 -
what version of it will I need to have?
Thanks for your help.
Blaine
"Bruce L-C [MVP]" wrote:
> Do you have Standard or Enterprise. Data driven subscriptions is a
> Enterprise feature.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Blaine" <Blaine@.discussions.microsoft.com> wrote in message
> news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
> >I am trying to create a data driven subscription. However, on the
> > Subscriptions tab for the reports the New Data-Driven Subscription
> > selection
> > is not present. Only the New Subscription selection is present. I can
> > create regular subscriptions but need to create a data driven
> > subscription.
> > Is there something in the config file that needs changed to enable data
> > driven subscriptions?
>
>|||Data driven subscriptions is still an enterprise feature in RS 2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:3C1F63FF-EFBB-469D-9A1E-F27AE5A48165@.microsoft.com...
>I thought I was running Enterprise everywhere but on this server it is only
> the Standard edition. We are planning on upgrading to SQL Server 2005
> 1Q06 -
> what version of it will I need to have?
> Thanks for your help.
> Blaine
> "Bruce L-C [MVP]" wrote:
>> Do you have Standard or Enterprise. Data driven subscriptions is a
>> Enterprise feature.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Blaine" <Blaine@.discussions.microsoft.com> wrote in message
>> news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>> >I am trying to create a data driven subscription. However, on the
>> > Subscriptions tab for the reports the New Data-Driven Subscription
>> > selection
>> > is not present. Only the New Subscription selection is present. I can
>> > create regular subscriptions but need to create a data driven
>> > subscription.
>> > Is there something in the config file that needs changed to enable data
>> > driven subscriptions?
>>

Data driven subscription

Hi,
I worked on SQL Server tutorials in Books online, "Data Driven
Subscription". In this tutorial, reports are delivered via email on a
scheduled time. as per the tutorial emails are being delivered in "MHTML"
format but it does not deliver the report in "PDF" or "Image" format. The
report manager shows a status message that there was an error but there is
no way to know the exact error. It just says "1 errors". The reprot is
working absolutely fine as it is being delivered in "MHTML" format but not
in "PDF" or "IMAGE". Please assist.
Regards
GinnyHi Ginny,
To know the exact error you will have to look into the ReportServer log
file; its default location is
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\LogFiles
Look at the latest ReportServerService__<time stamp>.log file for
description of the error.
Virat
Ginny wrote:
> Hi,
> I worked on SQL Server tutorials in Books online, "Data Driven
> Subscription". In this tutorial, reports are delivered via email on a
> scheduled time. as per the tutorial emails are being delivered in "MHTML"
> format but it does not deliver the report in "PDF" or "Image" format. The
> report manager shows a status message that there was an error but there is
> no way to know the exact error. It just says "1 errors". The reprot is
> working absolutely fine as it is being delivered in "MHTML" format but not
> in "PDF" or "IMAGE". Please assist.
> Regards
> Ginny

Data Display in Reports based on windows Authentication ID

Hi Experts,

I have a reporting scenario, where the reports are fetched from Analysis Services.

The reports should display data only spcecific to that user.

All users except those in admin roles should be validated using the Windows Authentication ID and data specific to them has to be displayed.

Any pointers/suggestions on how to implement this in Reporting services/ Analysis Services 2005 would be highly appreciated

Thanks,

Hi,

Easier said than done. I guess that the easier path would be to use data filtering based on parameters values limited by userid.

It depends, if you access cubes directly as well, i.e. from Excel, then that would be different. You would have to create custom MDX dimension access formulas based on roles and map these roles to Windows groups.

Assuming you are only going after AS data from RS, then you would still need to create an access policy.

i.e. you can segregate access to data slices based on membership to Windows groups.

We have found that using cumulative membership to groups was the most flexible and did not require too many groups.

You have to find a way to load LDAP (or Windows AD groups and membership) data, then each time an user access the report, you use the userid info to check what is the acceptable list of values for your parameters.

This way, a given user will be able to see and select only parameters values acceptable for her job function.

That is quite a lot of code, functions and procedures to write, no quick fix.

First thing first, you need the AD or LDAP data, there are quite a few ways to get it. I remember that SQL Server magazine ran an article a few month ago about getting it with a SSIS package.

You can also settle for another easier way, like calling Exporter Pro from a Windows scheduled task. Exporter Pro is part of the Hyena software.

Your question is not the type of question where a quick and precise answer is available. I can only give some high level clues. The rest would take time and require insider knowledge of your situation and requirements.

Hope it helps somehow

Philippe

Data comparison in crystal reports?

how to compare dates in crystal reports' selection formula.

I want to apply selection criteria on my crystal report.
Report is binded to a data view.
and i m doing like this

CRViewer.SelectionFormula = "{v_advances.creationDate} > '2/2/2004'"

v_advances= database view name
creationDate= view's field's alias name

and its not working.

kindly tell me; how to compare dates in selection formula of crystal report.Use Date(yr,mon,day) format

i.e, {table.field} < Date(2004,4,1)

Otherwise pass a date parameter, check with that parameter name.

Hope this will work|||its not working :(

what if i compare the view field with a parameter?

how to compare that.

:confused:|||Hi,

I'm not clear. What's view field. Is it ur database field. If it's use the folg.

{table.field} > {?Date}|||field is alias of db field in view.|||Then simply select the field, operator(like >,<),parameter field(Should be date datatype)

Data Caching in reports?

I wrote an invoice report that gets its data from an Oracle database. This is working fine except when users change something on the server (like adding a new charge to the invoice) then when they re-run the SSRS report the new line doesn't show up. They wait 15 minutes and re-run the SSRS report and then it appears.

It is like the SSRS report is caching the old data of the report.

Points to note though...

To execute the report I am using the SSRS 2005 webservice. I understand that there is 2 cachings, 1 server and 1 IIS side. I have not cached the server and don't know how to clear the IIS side. I see there is a rs:ClearSession=true parameter that you can pass in but by using the SSRS 2005 webservice this is not an option (I don't see how you can pass query strings in to the call).

Does SSRS cache the Oracle DataSet at all?

Thanks heaps for any help,

Craig

I'm having issues with caching too, but it may be a different problem than yours. Check the settings on your report server to make sure it is set to not caching.

Under the Properties tab, execution left menu there is a "Render this report with the most recent Data" radio button. Make sure the "Do not cache temporary copies of this report" radio button is checked.

Dashboard Guage type graph?

Hi,
I am on RS sp1, I have developed several reports bases on Analysis Services
cubes. I use in the reports several pie, bar, etc charts. I would like to
know if there is a Dashboard type Guage chart ( sort of like a speedometer
in the dashboard of one's car) in the RS graphicas library, maybe not built
in but can be added to the RS existing Graphics library, where I can use it
seemlesly as if it wa part of the product. If an addition exists, how do I
get it and what is the procedure to add it in.
Thank you in advance for your help.
--
Message posted via http://www.sqlmonster.comwould't that be nice. The extensions RS are very expensive. Every executive
now wants some sort of analog guage to display the overall aggregates of
their metrics at different levels of the enterprise.
--
Message posted via http://www.sqlmonster.com|||Here is an idea:
You could try creating a background image that gives the appearance of
the dashboard, then use a pie-chart with 2 values to act as the guage.
If you place it just right, you may be able to simulate the "Guage"
appearance you want.
Good luck!
~Lance Hunt
http://weblogs.asp.net/lhunt/

DAO Error code 0xbd7

Hi
I have a button in vb calling crsytal reports 9 . These reports are opening in cr viewer. I have an access database secured with a password. I can open the report but when I go to enter new parameters in the cr viewer, I get this error.

"LOGON FAILED"
Details: DAO Error Code 0xbd7
Source: Dao.Workspace
Description: Not a valid Password

Im lost on this one and I would be grateful for some help.
Thanks!!Hello,
This is in C#, I thing it can help you :

crystalReportDocument1.DataSourceConnections[0].SetConnection(SERVER, Database, "USERNAME", "YOUR PASSWORD"); crystalReportViewer1.ReportSource = crystalReportDocument1;

I use Microsoft Access file, so I left the Username blank, and for Server and Database put the new path to my .mdb file.

I hope it helps.

Cyrstal Report count

Need help. I am new to crystal reports. I have the sql below that would run perfectly fine unders windows SQL 2000 server and give me the results that I needed. But I can't get the correct count from crystal report if I only want each distinct record to shown once.

SELECT TYPE, PART_NUM, COUNT(PART_NUM) AS Expr1
FROM dbo.ITEM
GROUP BY PART_NUM, TYPE

type part_num count

Monitor gx260 20
Monitor gx620 40You might need to use distinct count in Crystal.

GJ

Cyrstal Report

Hi,

Nittu here...i am at enty level of crystal reports...i am into support team.

i am facing a problem in most of the reports related to grp by.

viz : i have a table called ward charges...

wardid wardname charges
1 ac room 1950
2 room #1 1400
3 room #2 1400

i need to calculate charges for patient admitted in room#1...
in report since they have groped by wardid...always
1950 is fetched for calculating the ward charges
i want 1400 instead

ward charges = charges * no. of days

same probm i facing in many other places due to grp by..

plz help me hw to sort it out.

from,
nittuIf you are grouping by wardid, then create a formula and place that formula in your group header.

Formula: ({Charges * no.ofdays}) \\ Place this in wardid group header
This will give the calculation for each wardid.

Hope that is what you are after.
GJ

Cycling Through Subreports

I have a master report which contains several subreports. My end users want these reports to cycle through for a list of clients in a loop. So, for example, given a list of three clients, the users want to see all subreports run for client 1, then all subreports run for client 2, then all subreports run for client3. (I hope this is making sense)

Currently the report uses an "in" statement so the users get subreport 1 for clients 1, 2, and 3, followed by subreport 2 for clients 1, 2, and 3, etc., which is not what they want.

I've tried placing the subreports inside a table and creating a group, but that just seems to crash the Report Designer.

Is there any to create a loop outside of the report that will call the report once for each client? Or is there some other way I can get it to run the subreports one client at a time?

Any help would be greatly appreciated.

Creating a group by client and putting the subreports inside of the group should be the right way of doing it. I'm not sure why the designer crashes when you are doing this using a table. But you can also try using a list instead.

Cutting and Pasting from PDF output

Hi

We have some reports that are published as PDF files. The layout of the report is fairly free, using lists within lists.

Some of our users want to cut and paste some of the data. When they do so, the order and layout of the fields does not resemble the layout of the report. Any way around this.

Note that when the report is published as mhtml or excel, cutting and pasting from these formats is much better.

thanks

Peter

No, there is no way around that. If the user is going to reuse the figues in another format then it is best to stick to Excel output. If only specific users need this then you could set them up with an subscription that has Excel output, and leave everyone else with the PDF version.

Customizing Report Manager Interface

Is it possible to customize the Reporting Services Report Manager interface?
What I am wanting to do is display the reports in a tree view.On Tue, 17 Aug 2004 23:43:02 -0700, Mick B <Mick
B@.discussions.microsoft.com> wrote:
>Is it possible to customize the Reporting Services Report Manager interface?
>What I am wanting to do is display the reports in a tree view.
Hi Mick:
I have an article showing how to do this with the web service API:
SQL Reporting Services Tree Navigation Sample
http://odetocode.com/Articles/95.aspx
--
Scott
http://www.OdeToCode.com