You can only aggregate Report Items in the Header and Footer. At least that's what Report Builder keeps yelling at me about.

Thanks for the reply @Get me?

I actually tried that before posting here. It gives me a scope error.

I may try some of the custom code and see if...

Default? I have never had Report Builder generate a default. I am confused my friend. I'll be back on in the morn maybe we can get our brains together and...

Maybe you could create a Value -1 Label -ALL- then put that into the logic for how you are making the other reports show.

So the parameter drop down would look...

Thanks so much GilaMonster. I actually started reading one of your article right before you posted that.:-D

Thank you gents so very much. I knew it was best to stop by the forum and ask some questions before doing:-D

Can you point me to any info about configuring the transaction log? Filling the HD sounds bad:crazy:

That's right, I forgot well it looks like you did get a solution from the other gent. 🙂

On your output that's my bad when I first posted that code I tested it in my environment and left my data field in there. v.fromdate is mine, I have...

Try this in your SQL query then feed it into your report.

DATENAME(MONTH, Requested_Start_Date)+ ' ' + DATENAME(Year ,Requested_Start_Date) AS MonthYear

Sure Lynn, I believe that it can.

However, this issue goes beyond reports. This is the "Charges" dataset that this occurred on. Its not just SSRS that points to...

I got one that I just fired off a email about.

Double checking some reports that were previously built by the vendor. One of them kept crashing. Report Builder says next...

I am so using this line:laugh:

@BWFC

I actually had this conversation a few...

Jeff you must have a crystal ball??! You just described yesterday for me. I actually had to say this in a email to one of our administrator's, "My reports only...

My first response is that I'm neither I'm a noob... But seriously I'm a report writer where do we fall? Red headed stepchild???