help me Calling Sql Experts, Urgent Help

[arshad]

Nuvvu pani kooda chestavani cheppanike ee post vesinav le  

 

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 1^st 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]

Oka query undi and you want to plug it into an ssrs report... and it is not giving you any output antenaaa man nee issue??? Or emanna errors vastunnayaaa..??

no oka query ledu em ledu, ma vodu just requirement ichindu danki query chesi SSRS report develop cheyali.. 

[4Vikram]

Nuvvu pani kooda chestavani cheppanike ee post vesinav le  

nenu epudu pani kaani publicity cheya ma kcr laga 

[arshad]

nenu epudu pani kaani publicity cheya ma kcr laga 

mari deennemantaro

[loveindia]

If u have my number call me man..

[loveindia]

If u have sql query already it is very easy to do man..

[arshad]

If u have my number call me man..

 

free consulting aa myan

[Appaji]

wat oo wat 

[4Vikram]

If u have sql query already it is very easy to do man..

sql query nenu rasina vuncle with my friend help anuko adi entha correst oo ardam aitaledu.. let me see mee number undali naa degara

[4Vikram]

If u have my number call me man..

phone dided meeru not lifted uu 

[4Vikram]

free consulting aa myan

poduna nunchi idane unav gintha aina help seyale, kanisam chesetolani nduku man ila gelkutaru 

[Raja123]

free consulting aa myan

[riashli]

K

[ramudu3]

bhayaaa , 4vikram ki nuvve training ichavaaa? heard that your training is good.

If u have my number call me man..

 

 

If u have sql query already it is very easy to do man..

 

[Appaji]

yelp