4Vikram Posted September 14, 2015 Report Posted September 14, 2015 i have requrirement and out of it oka report create cheyali,,,ssrs report.. so nenu query rasina inka filters part kncham ardam aitaledu.. anyone please help ============================================================ this is the query i wrote.. DECLARE @iStartDate DATETIME = '5/1/2015'; DECLARE @iEndDate DATETIME = Getdate(); --DECLARE @iRegion VARCHAR(50); Select RL.CLNUM AS LoanNumber ,RB.B_NAME_LAST AS BorrowerLastName ,RB.B_NAME_FIRST AS BorrowerFirstName ,RA.ORIG_LOAN_AMOUNT AS LoanAmount ,RD.APPLICATION_DATE AS ApplicationDate ,RL.LOAN_STATUS AS CurrentLoanStatus ,RC.REGION AS Region ,RC.BRANCH AS Branch ,RC.ORIGINATOR AS NameofOrginator ,RC.PROCESSOR NameofProcessor From WG_RPT_LOAN RL LEFT JOIN WG_RPT_BORROWER RB ON RB.LNUM = RL.LNUM LEFT JOIN WG_RPT_AMOUNTS RA ON RL.LNUM = RA.LNUM LEFT JOIN WG_RPT_DATES RD ON RL.LNUM = RD.LNUM LEFT JOIN WG_RPT_CMS RC JOIN WG_RPT_CMS_CONTACTS RCC ON RC.BRANCH_CID = RCC.CID ON RL.LNUM = RC.LNUM WHERE RD.APPLICATION_DATE BETWEEN @iStartDate and @iEndDate and Region=@iRegion =============================================================================== requirement idi: create an SSRS report as follows. You can add it to the Ad Hoc and Custom folder. Please include the following fields: 1) Loan Number 2) Borrower Last Name (Primary borrower) 3) Borrower First Name (Primary Borrower) 4) Loan amount 5) Application Date 6) Current loan status 7) Region 8) Branch 9) Name of originator 10) Name of processor Please include a date range for application date, starting and ending dates. (Bonus points if you can default to 1st day of current month as start, yesterday as end) Please include a filter for region, including a drop-down list for users to select region. Please exclude test loans (hint: GF_TL_POINT_OF_SALE_INFO) Subtotal by Branch
mtkr Posted September 14, 2015 Report Posted September 14, 2015 aa strt dt and end dt parameters ki expressions raayii.... strt dt as frst of month n end date as getdate -1
4Vikram Posted September 14, 2015 Author Report Posted September 14, 2015 em ardam aithaledhuu??? bhaiyya req idi ani rasina kada, akada nunchi requirement danki naaku ochinatu paina query rasina.. adi antha bane undi kani aa filter part naaku ravatledu
pandugadu999 Posted September 14, 2015 Report Posted September 14, 2015 nee query ni storec proc lo pettu man,,with stardate , enddate, region as parameters......region filter drop down values ki inko dataset create chey.. simple e kada..
ramudu3 Posted September 14, 2015 Report Posted September 14, 2015 nuvvu kuda help aduguthy ela bro???? i have requrirement and out of it oka report create cheyali,,,ssrs report.. so nenu query rasina inka filters part kncham ardam aitaledu.. anyone please help ============================================================ this is the query i wrote.. DECLARE @iStartDate DATETIME = '5/1/2015'; DECLARE @iEndDate DATETIME = Getdate(); --DECLARE @iRegion VARCHAR(50); Select RL.CLNUM AS LoanNumber ,RB.B_NAME_LAST AS BorrowerLastName ,RB.B_NAME_FIRST AS BorrowerFirstName ,RA.ORIG_LOAN_AMOUNT AS LoanAmount ,RD.APPLICATION_DATE AS ApplicationDate ,RL.LOAN_STATUS AS CurrentLoanStatus ,RC.REGION AS Region ,RC.BRANCH AS Branch ,RC.ORIGINATOR AS NameofOrginator ,RC.PROCESSOR NameofProcessor From WG_RPT_LOAN RL LEFT JOIN WG_RPT_BORROWER RB ON RB.LNUM = RL.LNUM LEFT JOIN WG_RPT_AMOUNTS RA ON RL.LNUM = RA.LNUM LEFT JOIN WG_RPT_DATES RD ON RL.LNUM = RD.LNUM LEFT JOIN WG_RPT_CMS RC JOIN WG_RPT_CMS_CONTACTS RCC ON RC.BRANCH_CID = RCC.CID ON RL.LNUM = RC.LNUM WHERE RD.APPLICATION_DATE BETWEEN @iStartDate and @iEndDate and Region=@iRegion =============================================================================== requirement idi: create an SSRS report as follows. You can add it to the Ad Hoc and Custom folder. Please include the following fields: 1) Loan Number 2) Borrower Last Name (Primary borrower) 3) Borrower First Name (Primary Borrower) 4) Loan amount 5) Application Date 6) Current loan status 7) Region 8) Branch 9) Name of originator 10) Name of processor Please include a date range for application date, starting and ending dates. (Bonus points if you can default to 1st day of current month as start, yesterday as end) Please include a filter for region, including a drop-down list for users to select region. Please exclude test loans (hint: GF_TL_POINT_OF_SALE_INFO) Subtotal by Branch
4Vikram Posted September 14, 2015 Author Report Posted September 14, 2015 DECLARE @iStartDate DATETIME; DECLARE @iEndDate DATETIME; --DECLARE @iRegion VARCHAR(50); SET @iStartDate = '8/7/2015'; SET @iEndDate = GetDate()-1; itla ichina
4Vikram Posted September 14, 2015 Author Report Posted September 14, 2015 nee query ni storec proc lo pettu man,,with stardate , enddate, region as parameters......region filter drop down values ki inko dataset create chey.. simple e kada.. bhaiya chepkodanki aina undali kani siggu lekunda cheptuna, literally dumb nenu sql la... select statement joins thapa inka em radu naaku.. na karma kaali 2 years job sql mida kaani sql la pani chese chance ee raledu.. ipudu ipudu chestuna anduke oka muka ardam ai sastaledu... nuvu chepina style la ne ma vodu chepindu kaani burra ki ekale
4Vikram Posted September 14, 2015 Author Report Posted September 14, 2015 nuvvu kuda help aduguthy ela bro???? nenu emana sql devudini aa bro doubt adagakunda undadanki
Raja123 Posted September 14, 2015 Report Posted September 14, 2015 nenu emana sql devudini aa bro doubt adagakunda undadanki kadule
ramudu3 Posted September 14, 2015 Report Posted September 14, 2015 ala kadhu but I don't think neekanna exprets ikkada untaru anukonu , try stakoverflow (i think you already tried) nenu emana sql devudini aa bro doubt adagakunda undadanki
4Vikram Posted September 14, 2015 Author Report Posted September 14, 2015 ala kadhu but I don't think neekanna exprets ikkada untaru anukonu , try stakoverflow (i think you already tried) naaku aa telidu p telidu sql la ikada chala mandi experts unaru nenu vala mundu jujupi... anyways waiting for experts
charygaru Posted September 14, 2015 Report Posted September 14, 2015 bhaiya chepkodanki aina undali kani siggu lekunda cheptuna, literally dumb nenu sql la... select statement joins thapa inka em radu naaku.. na karma kaali 2 years job sql mida kaani sql la pani chese chance ee raledu.. ipudu ipudu chestuna anduke oka muka ardam ai sastaledu... nuvu chepina style la ne ma vodu chepindu kaani burra ki ekale are you me ?
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts