Creating Mathematical Formulas and Calculations

I've created a sql statement that retrieves number data from various table joins. The number data is then grouped according to various categories. What I need to do is to calculate the average of all the number data in a particular group. How do i go about this? Once calculated, the average needs to be displayed under the data.

For example, the report will list say five numbers (some sets may have more, it depends on how much data is returned based on the query), then under the five numbers, the average is given

2

4

3

6

0

Average: 5

What technique is best? Do I have to calculate the numbers in sql or do I need to configure the report to calculate the average? If so, how? Can someone show me step by step how to do averages for a set of data in the reporting services?

I am completely new to doing reports, I'm just a hobbyist, and I've only used databases to retrieve basic data, but not make manipulations for reports.

Any help will be appreciated.

You can use the "Avg" function in reporting services to do this calculation. Average returns the average of the numbers.

Creating databases on WinXP SP2 with SQL Server 2005 CE RC

Hi,

For various reasons a new desktop application I am developing is using the SQL Server 2005 Compact Edition Release Candidate to store local data. On my development machine (XP SP2, VS2005, SQL Server 2005 Developer Edition) the software is able to create the database file, and read and write to it fine.

However on our test machine, which does not have any of the development tools the software is unable to create the database. A System.Data.SqlServerCe.SqlCeException is thrown. The message is: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU." Obviously this goes somewhat against the blurb for SQL Server CE.

Is this something that will be fixed shortly? Or is it the intention that databases can't be created on machines that do not SQL Server or Visual Studio installed? (Incidentally the reason for creating the database on the fly is that we are encrypting it, using the users credentials, so that only they can open the database.)

Thanks, Steve

The restriction has been removed in RC1 bits. Have you installed RC1 bits on your test machine? It looks like your test machine is using the old bits.

Thanks

Raja

|||

Hi,

I thought I was using the RC1 version of the software. Is there a list of the DLL's and versions that I can check against my machine, and the test machine?

Thanks, Steve

|||

Sorry for the delayed reply. RC1 bits are of the version 3.0.5258.0

When you are running your app through VS, please check the location and version of sqlcese30.dll. It should be loaded from C:\Program Files\Microsoft SQL Server Everywhere Edition\v3.1 and of the version 3.0.5258.0

Thanks

Raja

Creating databases on WinXP SP2 with SQL Server 2005 CE RC

Hi,

For various reasons a new desktop application I am developing is using the SQL Server 2005 Compact Edition Release Candidate to store local data. On my development machine (XP SP2, VS2005, SQL Server 2005 Developer Edition) the software is able to create the database file, and read and write to it fine.

However on our test machine, which does not have any of the development tools the software is unable to create the database. A System.Data.SqlServerCe.SqlCeException is thrown. The message is: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU." Obviously this goes somewhat against the blurb for SQL Server CE.

Is this something that will be fixed shortly? Or is it the intention that databases can't be created on machines that do not SQL Server or Visual Studio installed? (Incidentally the reason for creating the database on the fly is that we are encrypting it, using the users credentials, so that only they can open the database.)

Thanks, Steve

The restriction has been removed in RC1 bits. Have you installed RC1 bits on your test machine? It looks like your test machine is using the old bits.

Thanks

Raja

|||

Hi,

I thought I was using the RC1 version of the software. Is there a list of the DLL's and versions that I can check against my machine, and the test machine?

Thanks, Steve

|||

Sorry for the delayed reply. RC1 bits are of the version 3.0.5258.0

When you are running your app through VS, please check the location and version of sqlcese30.dll. It should be loaded from C:\Program Files\Microsoft SQL Server Everywhere Edition\v3.1 and of the version 3.0.5258.0

Thanks

Raja