I've been so sick and then so swamped I haven't been able to spend a minute on this until now!

The code examples listed will set the date of the parameter...

Thanks, I will give both options a try! Appreciate the help.

The query is a simple select with a StartDate and EndDate constrained by the RDL parameter. I can try the suggestion of using a formula in the parameter default, but...

bump. still stumped here...

if i understand correctly, the OP is looking to have the values returned in the query used as Y-axis values for a bar graph. the query should return two values,...

right, right... sorry for the bad info.

does this script work in a query window? i could be wrong but i think you might have to put an "as Size" after the cast statement.

I would imagine this would be done in the "Code" dialog box... Just add an "AfterUpdate" event to the parent parameter, forcing it to clear out the value of the...

Thanks Niraj, that's a much simpler example... but unfortunately the report in question has two layers of parameters. Let's say Country and State are on the first layer, passed in...

Why take a class if you're just going to fish for answers on the net? 😛

http://download.sqlpower.ca/architect/0.9.13/doc/api/ca/sqlpower/architect/profile/output/ProfileColumn.html

TSQL and Jet SQL handle joins a bit differently in terms of syntax. Here's the TSQL code for your join. I've put in "aliases" so references to specific tables are...

There are plenty of ways to loop in SQL without a cursor. A while loop with an insert statement and some incrementing values to get you unique records is probably...

And for the solution...

Had to add a shell proc which accepts the nvarchar value that SSIS insists on using, converts it to xml, and then sends it to the real...

Yes, I'm finding the issue is a datatype issue, not an extra columns issue. The proc is expecting XML and the SSIS is converting the XML to unicode text...

Thanks for...

one of my co-workers pointed out a difference, and this is probably it... she believes these jobs were created via in-line SQL rather than through the "New Job" GUI. so...