generating report based on specific input

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • anchu
    New Member
    • May 2010
    • 6
    #1

    generating report based on specific input

    Respected sir/madam

    i want to generate a report and display the information in report based on specific id for example: if i enter roll no of a student in textbox so only this information should be displayed in the report and next time when i enter other roll no then this information should b displayed i wrote a query

    select fypersonal.appn o as ApplicationNo,f ypersonal.fname ,
    fypersonal.mnam e,fypersonal.ln ame,fypersonal. category,fypers onal.frmyear,fy personal.toyear ,fypayment.fees _paid,fypayment .total_fees,fyp ayment.balance, fypayment.cours e,fypayment.pda te,fypayment.pm onth,fypayment. pyear from fypersonal,fypa yment where fypersonal.appn o=fypayment.app no and fypersonal.stud _id='"+txtid.te xt+"'

    but no output/information is displayed in the report...
    please help me with this problem

    thanking u very much..
    Tags: None
    • vb5prgrmr
      Recognized Expert Contributor
      • Oct 2009
      • 305
      #2
      Need to see your code and we need to know if it is a data report or crystal reports and what version...



      Good Luck

        Comment

        • anchu
          New Member
          • May 2010
          • 6
          #3
          Originally posted by vb5prgrmr
          Need to see your code and we need to know if it is a data report or crystal reports and what version...



          Good Luck
          thanks for the reply

          it is a data report of visual basic 6.0 version
          and their is no vb code
          i have written the query in sql statement
          which is in properties of command...

          waiting for your reply..
          thankin u very much..

            Comment

            • vb5prgrmr
              Recognized Expert Contributor
              • Oct 2009
              • 305
              #4
              Okay, if the student ID is a numeric field, then
              Code:
              ... and fypersonal.stud_id=" & txtid.text
              else if it is a text field then...
              Code:
              ... and fypersonal.stud_id='" & txtid.text & "'"


              Good Luck

                Comment

                • anchu
                  New Member
                  • May 2010
                  • 6
                  #5
                  Originally posted by vb5prgrmr
                  Okay, if the student ID is a numeric field, then
                  Code:
                  ... and fypersonal.stud_id=" & txtid.text
                  else if it is a text field then...
                  Code:
                  ... and fypersonal.stud_id='" & txtid.text & "'"


                  Good Luck
                  thankin u sir

                  i tried both of them but yet no output is displayed

                  actually the stud_id and the information of that student is stored in database and when the application is running
                  the user has to specify the id and based on that id the information should be displayed in the data report..

                  waiting for your reply
                  thankin you very much..

                    Comment

                    Previous template Next
                    Working...