You can't with a Calendar control... You'd have to use a dropdown and use a query against a Calendar table.

create table scripts? insert scripts? expected results?

I'm holding up some fingers. Guess how many.

a view would probably be simplest. But test it for yourself. Clear the buffers on your dev server (not the production server!!!), set statistics IO on, set statistics...

If all the parameters have defaults, then there's nothing for the report to wait for... you could add a fake parameter and SSRS would be forced to wait for the...

If all of the parameters have default values, then the report needs no interaction to run. So remove a default.

Insert a List item, not a tablix. Then adjust the Top and Bottom Padding of the individual cells and set them to slide up.

Edit... oh, and shut off...

IF you set the Top and Bottom Padding on the textboxes to 0, does that fix it? That's part of what controls the line spacing between the textboxes.

The short answer is to create an auxiliary Calendar table and then cross join that to the Customer table and then outer join that to invoices. The (Calendar X...

Can't really drop that into SQL Server and play with it. Help us help you. Read this[/url].

You could use ROW_NUMBER() and maybe select the columns you need and filter by ROW_NUMBER() to put them into separate records.

Please show your desired output. (My psychic skills are...

Crosspost... original is here:

http://www.sqlservercentral.com/Forums/Topic1739452-3077-1.aspx#bm1739455

(Should actually be in 2014).

Could you please post your expected output?

If you're using 2012, use LAG to get the previous record, then you can compare/do math on the two in the same row.

The spam this weekend is insane... is the filter taking the weekend off?

Could you explain why you need a recursive query for this? Performance of recursive queries will probably be really slow. If you have a dummy database outside of work,...