Sorry, missed that bit of the requirements, the answer is No because it is just one group, so it won't recognise any difference between Country, State, City.

To summarise:

You need this...

Hi

Create your group by adding the first field (probably country), then right click on the group and click on edit group. This bring a dialogue box to the screen...

You could use the same principles as described above, but in a matrix.

The key is to ensure that you only have one row group, and that row group must be...

Yes, depends entirely on how you want to join them in the report but there are many possibilities:

1. Create two datasets, and have these printed on the report in...

No, for some reason unknown to me, they don't allow this.

Go figure......

There is a drop down list on the tool bar which allows you to select Excel, then click on the export button. Should work fine.

Good luck,

Once you have the value available in the main report body, you should then be able to refer to it in the footer by using the expression such as:

=ReportItems!FirstName.Value

This of...

Hi

In that case I can only suggest that the storage inside the DB is incorrect, but that's about all I can say really, I can't be any more help.

Anyone else???????

Are you using a table or a matrix?

Not sure what your problem can be here, I print images from the DB all the time without any problem at all.

After you have gone through the wizard to put...

Not sure how you're adding the £ symbol in there, but try doing something like

CAST(MoneyColumn AS Decimal(6,2) to ensure the value is coming to two decimal places.

Regards,

I have created a query using T-SQL, to generate a result set for a report. When I execute this query in SSMS, i get the right result format for money...

Standard chart reporting in SSRS does not support secondary X & Y Axis values, we bought the Dundas Charting Control in order to achieve this and many other things. ...

First, to limit the number of rows in any table or list box, the best thing to do is to set up a group on row numbers. You can...

In two different organisations I have used SQL inside the Dataset, and Stored Procedures.

Both work equally well.

Both accept parameters.

In my opinion Stored Procedures are the way to go simply because...