Hi,

I would create a separate dataset and table for this which returned the averages for each Area Group. From this dataset you could work out the District Average.

When the...

Hi, I think the subreport may be worth a try and should work as I have done a similar report.

return the details in a separate report and add this as...

Hi,

I would create a query in your dataset that would return the item, year, month and total.

I would insert an extra field which would return the month number, so you...

It says it is executing at the bottom of the window but nothing seems to happen.

I am logged into the ssms on my personal machine and I have tested the...

Thanks I have reconfigured so that the advance options are shown.

I have reconfigured the xp_cmdshell value so that the config_value and the run_value are 1

Then I have re-run the...

Tried that and it returned the same message as before.

Yes I ran the query in SSMS in query analyser and copied the results from the grid.

Thanks that makes sense I have run the following script in query analyser Which is as follows:

EXEC master..xp_CMDShell 'C:\\PARA.bat'

This returns a column output

1 'C:\\PARA.bat' is not recognized as...

I have a report which will go out to certain an individual so security isn't really an issue.

All I want to achieve is to be able to click a...

Hi,

The reportitems expression is case sensitive, look at each of the expressions and then check the textbox name and make sure the spelling is exactly the same.

If this...

Hi,

I have created an example report which is attached.

There are 2 tables one which shows the customer data and the second which shows the customer bills.The customer data table...

Thanks, but it has lots of sensitive data 🙁

To give you an idea, the report can be run for an individual customer or many customers and is grouped by the...

Thanks for you help, will give it a go.

🙂

Thanks for your reply, I will bear that in mind.

I know the feeling, as long as the data only relates to the user then it won't be too bad. You should be be able to resend the emails with...