Em Andamento

Convert SSRS report use new database SQL Server Report Builder

We have a few SSRS reports that have to be converted to use a new single database. Prior, we are using 2 or more databases. THis project is for one conversion but there could be a few more on the next project.

You have to convert the stored proc here: <[url removed, login to view]>

the output fields can stay the same and should run ok in the program so you just have to map the columns in the SQL from the old tables to the new ones. SOme cases there are itemid that is new but it matches to an items mapping table.

You may need to tweak the above SQL to only produce the 5 highest totals. as it has been some time since we have looked at this.

a shot of the SSRS are code is here: <[url removed, login to view]>

it is not too long code. behind the expression are some code as this:

=FormatNumber(IIF(IsNothing(Sum(Fields![url removed, login to view])), 0, Sum(Fields![url removed, login to view])),0)

Habilidades: Engenharia, Arquitetura de software, Teste de Software

Ver mais: ssrs architecture, Use, use cases, ssrs, ssrs sql, ssrs report, sql database report, reports sql server, report sql, ProC, iif, database sql, convert png, convert reports database, code ssrs, convert database program, sql ssrs, convert sql database, report table, convert output, can convert convert png, produce report, ssrs table, using sql report builder, ssrs code

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

ID do Projeto: #3050074

Premiar a:

sefbob

See private message.

$42.5 USD em 14 dias
(2 Avaliações)
1.5

7 freelancers estão ofertando em média $72 para este trabalho

jpcentral

See private message.

$35.7 USD in 14 dias
(20 Comentários)
4.5
yubor

See private message.

$212.5 USD in 14 dias
(25 Comentários)
4.3
saumilmodi

See private message.

$59.5 USD in 14 dias
(23 Comentários)
3.9
nithyarajeshg

See private message.

$21.25 USD in 14 dias
(23 Comentários)
3.2
patelrajan2000

See private message.

$85 USD in 14 dias
(2 Comentários)
0.0
awais9981

See private message.

$50.15 USD in 14 dias
(1 Comentário)
0.0