Ooooh, you mean code it in?? If so, I've never used the CEILING function but I'm sure I can figure it out. Thanks for the tip!

Mike

Hmmm, I'm not exactly sure what you're talking about. How do I do this?

Agreed. Set up a new dataset (query) that only produces the fruit selections, then set up a QUERIED parameter in your original dataset that references your new fruit parameter....

Hello,

I'm not exactly sure how to format it in Visual Studio, but an easy way to do it is convert the 'text' to 'number' in your syntax. The...

Forget it Hump, I figure out how to customize. I was using ACTUAL numbers when customizing which obv wasnt working, I soon found out I'm supposed to be using...

OK, found it and trhat works. I have the number 978376 formatted to 978,376.00. However, I can't for the life of me, figure out how to round it....

Good question and I'm not sure haha. My query is about 32,000 characters long with nested selects, joins, etc. A real doozy. I've added two parameters thus...

I literally just wrote a parameter that I wanted to allow the user to use OR not use, their choice. It was a range parameter for population figures where...

Whoa, sounds complicated, but thank you very much for the quick response. I'm sure I'll have more questions once I dive in.

Very helpful reply, so again, thank...

I apologize. I want it centered above EACH column.

Centered above all columns.

Hello,

Thanks for responding. I've attached the Design View, rather than the report preview.

Please keep in mind that I'm dropping my data into a MATRIX table, and...

So in other words, I have to combine the two existing queries into one query?

Please forgive me because I'm definitely a rookie when is comes to SSRS, but there isn't...

Maybe this screenshot will help better ID my problem. You can see my two datasets to the left "mike_PRD" and "Population." Does this help provide you with a...

Im working in MS Visual Studio 2005 so I believe I mean .net Datasets. And yes, all I think I need to do is join the two tables. ...