Encerrado

Convert a different SSRS report to use a new database

We have an SSRS reports called "Spending Analysis" It was using the old Great plains databases (2 of them) and recently we made one new common database with some new columns. We need to convert this stored Proc: <[url removed, login to view]> the tables will be changed and some of the colums names. we are using sql server 2008 r2. you can do this work on your local or online. but is preferred off line. please indicate if you know Great plains (Microsoft dynamics) as this would be a plus as the data is from this system.

Then we can run this SSRS and verify that it runs correctly. Here is a pic of the SSRS output: <[url removed, login to view]>

here you can see some of the ssrs layout.<[url removed, login to view]>

some of the expression in use are:

=[url removed, login to view]("{0:C2}", IIF(IsNothing(SUM(Fields![url removed, login to view])), 0, SUM(Fields![url removed, login to view])))

and

=[url removed, login to view]("{0:C2}", IIF(IsNothing(SUM(Fields![url removed, login to view])), 0, SUM(Fields![url removed, login to view])))

## Deliverables

SSRS Reporting, Stored Procedures, SQL Server 2008 R2, Query

Habilidades: Engenharia, Arquitetura de software, Teste de Software

Ver mais: ssrs microsoft, ssrs architecture, common string, common query, microsoft ssrs, microsoft great plains dynamics, microsoft dynamics online, great plains dynamics, dynamics online, engineering report format, use, ssrs, ssrs sql, ssrs report, sql database report, report sql, report layout, proc, iif, great plains, dynamics great plains, dynamics, convert reports database, engineering work report, sql query format

Acerca do Empregador:
( 39 comentários ) United States

ID do Projeto: #3066992

3 freelancers estão ofertando em média $96 para este trabalho

timessolutions

See private message.

$59.5 USD in 14 dias
(41 Comentários)
5.0
robotappsvw

See private message.

$208.25 USD in 14 dias
(16 Comentários)
4.5
CrazyFramework

See private message.

$21.25 USD in 14 dias
(8 Comentários)
4.5
jeganee

See private message.

$63.75 USD in 14 dias
(4 Comentários)
3.1