sql - SSRS Numbers appear differently than same view in Excel -


in ssrs, have report running pulls sql view, reason showing insanely wrong numbers particular campaign.

for example, getting in ssrs:

ssrs numbers

ssrs designer: i.stack.imgur.com/lohaf.png

(cant post more 2 links

as opposed exact same view being shown in excel:

excel numbers

it seems lead not have locks or closes being aggregated 1 campaign reason. joining 2 views becuase there data 2 different systems. works flawlessly within excel, stumped why cannot working in ssrs.

i appreciate help.

thanks

sql view code

select * xxviableleadsvelocifyencompassgrpcampaign left outer join xxlocksandcloses on xxlocksandcloses.campaign =       xxviableleadsvelocifyencompassgrpcampaign.title

xxviableleadsvelocifyencompassgrpcampaign

select c.[campaignid], c.[title], c.[lead_ct], cast(c.[cost] int) "cost", cast(c.[cost per lead] int) "cost per lead",  count(v.leadid) "viable leads", cast(cast(c.[cost] int)/count(v.leadid) decimal(10,2)) "cost per viable lead", cast( cast(count(v.leadid) float)/c.[lead_ct] decimal(10,2)) "viable lead conversion" xxviableleadsvelocifyencompass v inner join xxleadcampaigngrpcountcosts c on v.campaignid = c.campaignid group c.[campaignid], c.[title], c.[lead_ct], c.[cost], c.[cost per lead]

xxleadcampaigngrpcountcosts:

 select c.campaignid, c.title,    count(leadid) lead_ct,   cast(sum(lw.f660) decimal(10,2)) cost,   cast(avg(lw.f660) decimal(10,2)) "cost per lead         [velocifydb].[dbo].[leadwarehouse] lw   inner join campaign c on lw.campaignid = c.campaignid   dateadd(hh, 3, lw.createdate) >= '7-5-2016'   , lw.campaignid != '225'   , lw.campaignid not null   group c.campaignid, c.title

xxlocksandcloses

select c.title campaign,  count(leadid) locked_loans, sum(case when cx_closing_completion null 0 else 1 end) closed_loans velocifydb.dbo.lead l  inner join [encompass_dw].[dbo].[encompass_loandata] e on l.leadid=  e.cx_leads360id inner join velocifydb.dbo.campaign c on l.campaignid = c.campaignid lockdate not null , dateadd(hh, 3, l.createdate) >= '7-5-2016' group c.title


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl...
Read more

Laravel mail error `Swift_TransportException in StreamBuffer.php line 269: Connection could not be established with host smtp.gmail.com [ #0]` -

i developing website contact-us page guest users can send me email using gmail . anytime try send mail using contact-us form, error swift_transportexception in streambuffer.php line 269: connection not established host smtp.gmail.com [ #0] this mail.php return [ 'driver' => env('mail_driver', 'smtp'), 'host' => env('mail_host', 'smtp.gmail.com'), 'port' => 587, 'from' => ['address' => '', 'name' => ''], 'encryption' => env('mail_encryption', 'tls'), 'username' => env('mail_username'), 'password' => env(mail_password), 'sendmail' => '/usr/sbin/sendmail -bs', 'pretend' => env('mail_pretend', false), ]; this .env mail_driver=smtp mail_host=smtp.gmail.com mail_port=587 mail_username=afecjaped@gmail.com mail_password=********...
Read more

c# SetCompatibleTextRenderingDefault must be called before the first -

i tried search exception couldn't find solution on case i'am using code below invoke .net application : assembly assem = assembly.load(data); methodinfo method = assem.entrypoint; var o = activator.createinstance(method.declaringtype); method.invoke(o, null); the application invoked has form , in entrypoint of application : [stathread] static void main() { application.enablevisualstyles(); application.setcompatibletextrenderingdefault(false); //exception application.run(new form1()); } setcompatibletextrenderingdefault must called before first iwin32window object created in application. edit : assembly = assembly.load(data); methodinfo method = a.gettype().getmethod("start"); var o = activator.createinstance(method.declaringtype); method.invoke(o, null); you should create new method skips initialization...
Read more