Josh:

I'm a report writer and use both Crystal XI r2 and SSRS 2005. My overall opinion is that SSRS 2005 is better than Crystal, but there are some features in...

Well, shucks. Looks like I tested for situations of 182 vs 182.09; didn't test for 182.99. Good catch.

Try this:

=iif(

(YourField.Value/cint(YourField.Value))=1

,formatnumber(YourField.Value,0)

,formatnumber(YourField.Value,1)

)

Just substitute "YourField" with the field your need to evaluate.

--pete

The following might be helpful regarding your need to write data to a SQL table.

Brian Welcker (who was on the reporting services team for several years) created a clever "report"...

Interesting article... would it be possible to post the .rdl xml of an example to this discussion thread. I can't quite visualize it based on the article alone.

I just copied-n-paste your sql into sql management studio to check for syntax--> several syntax errors came up. Also, I noticed that there are no Joins in your From...

I may be wrong, but I'm pretty sure that once a report is rendered, what you see on the screen is what you'll get on paper.

But, here's a possible workaround:

Any...

Thanks for the feedback -- After doing some more searching around, I've determined that what I've been searching for is likely a template. I found a couple of articles here...

Are you looking to concantenate all values or distinct values?

Also, are you looking to concantenate the values within the entire dataset or are there groupings?

--pete

I want to show the results in this form

1 a b c d -

2 e f x ...

I just had an idea. If your goal is to plot the look of the data, couldn't the X-axis contain the individual elements (or ranges of elements) and the...

Hmmm.... I've been playing with this issue a little bit throughout the day. I haven't come up with a definitive answer, yet, however.

What I can share is that a bell...

Your "main objective" is somewhat undefined. MS Access can link to different SQL servers (it's obviously not open source, but it meets your objective and you can do report writing.)

As...

Try these basic steps:

This can work if you can store the url (not the image) in a database:

1. Add an image control to your layout.

2. When the wizard appears, select...

Hi Ravi:

I buillt a sample treeview in SSRS using a table region object. (I believe the same technique could work in matrix). The trick is to make the first couple...