Online SSRS, Values, SQL tutor

4 weeks ago

Sri Niwaspuri, India TeacherOn Full time
Hi, I need help with an SQL query created in SSRS.

I have two parameters in my SSRS report: startdate and enddate. The values of startdate are stored in a datearray(i). Could you help me understand how to pass the values stored in datearray(i) to my SQL query?

  • Custom Code created in Report
Function GetDateArray(startDate As Date, endDate As Date) As String()
Dim dateArray() As String
Dim currentDate As Date
Dim i As Integer

' Calculate the number of days between start and end date
Dim daysCount As Integer = DateDiff(DateInterval.
Day, startDate, endDate)

' Initialize the array to hold dates
ReDim dateArray(daysCount)

' Populate the array with dates in the desired format
For i = 0 To daysCount
currentDate = DateAdd(DateInterval.
Day, -i, endDate)
dateArray(i) = "Startdate-" & (daysCount - i) & "(" & Format(currentDate, "dd MMMM") & ")"
Next

Return dateArray
End Function

  • Calling the custom code in an expression:=Code.
GetDateArray(ParametersStartDate.
Value, ParametersEndDate.
Value)

  • I need to pass the values to this sql Query
Select * From Feed where Date>(here is where I need to pass the values stored in datearray(i))

Level:
Intermediate

Gender Preference:
None

Meeting options:
Available online - via skype etc.

  • Online JavaScript, CSS, Python, HTML, SQL, WordPress tutor

    1 month ago

    Sri Ganganagar, India TeacherOn.com Part time

    I am looking on doing some projects related to HTML, CSS, WordPress, JavaScript, python and SQL. So need some tutoring with the languages above and the help with the projects.Level: Beginner Gender Preference: NoneMeeting options: Available online - via skype etc.

  • Online Personal Finance tutor

    3 weeks ago

    Sri Ganganagar, India TeacherOn.com Part time

    Personal finance task, has three tasks part A,B,C of uk. I am looking for an online tutor for completing assignments.Level: Expert Gender Preference: NoneMeeting options: Available online - via skype etc.

  • Online IELTS ACADEMIC WRITING tutor

    2 weeks ago

    Sri Muktsar Sahib, India TeacherOn.com Full time

    In writing i wanna 7+bands score. I am looking for an online tutor. The preferred time for classes will be between 12 p.m. to 4 p.m.Level: Expert Gender Preference: NoneMeeting options: Available online - via skype etc.

  • Data Scientist

    4 weeks ago

    Maharashtra/Orrisa/Guwahati/Bhubaneshwar/Cuttack/Mumbai/Pune/Navi Mumbai/Aurangabad/Nasik/Nagpur/Sri, IN Dotflick Solutions Full time

    Profile : Data ScientistJob description :- Design and Develop data science solutions fairly independently to drive incremental value for the team.- Collaborate with business functions to design and shape experiments to demonstrate data science-enabled advantage.- Define best practices related to information architecture, including collection, integration,...

  • Data Scientist

    1 month ago

    Maharashtra,Orrisa,Guwahati,Bhubaneshwar,Cuttack,Mumbai,Pune,Navi Mumbai,Aurangabad,Nasik,Nagpur,Sri, India Dotflick Solutions Full time

    Profile : Data ScientistJob description :- Design and Develop data science solutions fairly independently to drive incremental value for the team.- Collaborate with business functions to design and shape experiments to demonstrate data science-enabled advantage.- Define best practices related to information architecture, including collection, integration,...

  • Team Leader Plant Floor Systems

    1 day ago

    Sri City, India Colgate-Palmolive Full time

    Relocation Assistance Offered Within Country # 159772 - Sricity, Andhra Pradesh, India About Us Would you like to be part of a team that is building a future to smile about? What about having the opportunity to collaborate with teams across the world, full of stimulating discussions, and making impactful contributions? If this is how you see your...

  • Team Leader Plant Floor Systems

    1 day ago

    Sri City, India Colgate-Palmolive Company Full time

    Relocation Assistance Offered Within Country# 159772 - Sricity, Andhra Pradesh, IndiaWho We AreColgate-Palmolive Company is a caring, innovative growth company that is reimagining a healthier future for all people, their pets and our planet. Focused on Oral Care, Personal Care, Home Care and Pet Nutrition, we sell our products in more than 200 countries and...