Wednesday, March 28, 2007

Running a Sql Server Reporting Services 2005 Report on SSRS 2000


Converting 2005 SSRS Report to 2000

Change:
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
to
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">


Remove nodes:
<InteractiveWidth> </InteractiveWidth>
and
<InteractiveHeight> </InteractiveHeight>

Voila! (sp?)

Labels: ,

Tuesday, March 27, 2007

Complete History of Final Fantasy



Recaps of ALL Final Fantasy games. Includes FFI, FFII, FFIII, FFIV, FFV, FFVI, FFVII, FFVIII, FFIX, FFX, FFXI, FFXII, FFXIII, FF Tactics, FF Tactics Advance and FFVII Spinoffs: Advent Children, Before Crisis, Crisis Core, Dirge of Cerberus, & Last Order.

This feature is included with the Collectors Edition of Final Fantasy XII.

Labels:

Thursday, March 22, 2007

Ajax Control Toolkit 10301 Fun

And by fun I actually mean a searing pain in the ass.

As much as I'd love to vent about MS's tendency to over complicate the simplest of tasks, I've chosen my poison and need to deal with it.

The problem: Updated my Ajax Control Toolkit to version 10301 and nothing worked. Got some Sys is not defined error.

Path to solution: Google is becoming decreasingly helpful with code problems. Either their algorithms are getting rusty or sites/forums (*cough* Microsoft *cough*) are purposefully hiding data from them. If true, the former is disturbing and the latter is deplorable. Then there's the remote possibility that my search skills are withering... no.

Solution: Cut and paste sections from the web.config that came with the latest toolkit to see if anything would magically make things work again.

This did it:

<system.web>
<!--Other stuff-->
<httphandlers>
<remove verb="*" path="*.asmx">
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false">
</httphandlers>
<httpmodules>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
</httpmodules>
</system.web>

What this really comes down to is that I don't understand .NET innards... yet. I do however think the trip is unnecessarily painful (for something they''re just going to dump in a few years anyway). I still remember when RDO was the wave of the future.

A.D.D.-Techno-schizophrenic bastards. Wouldn't be so bad if I didn't so closely resemble them.

Labels: , , ,

Tuesday, March 06, 2007

Correlated Subquerys

Ah, the wonderful Correlated Subquery...

This discovery neared completion with a google search for "t-sql select subquery parameter from select". Which returned a link to this article (http://www.databasejournal.com/features/mssql/article.php/3485291).

Why did I need subquery that made use of data from the outer query?

I've got a calendar table built using this article (http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html).
Now I have a need to return data from the Quarter Name column and the last date in that quarter for each line item. Sure there are lots of ways to do it, but a solution modified from the first referenced article allows me to do it in a single line of SQL.

I'd previously created a view (view_Quarters) to return DISTINCT quarter names (and id) for simplified inclusion in other queries.

Here's the Code:
SELECT
qn, qid, (SELECT TOP 1 dt FROM Calendar WHERE qid = vQ.qid ORDER BY dt DESC) LastDay
FROM
view_Quarters vQ ORDER BY qid

I knew what I wanted to happen ahead of time, but didn't know if it had been implemented SQL (ANSI or the flavor of my choice). It's always incredible to see that someone else had laid the groundwork for most of the problems you'll run into and even better with a good search engine to make that work easily available. Thank you DatabaseJournal, ASP.FAQ and Google.

Labels: ,