Help in crystal report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • muddasirmunir
    Contributor
    • Jan 2007
    • 284

    Help in crystal report

    i am using vb6 and crystal report 10

    i want to ask solution of one proble which i am facing in making report.

    first , in my programe i ask the user to give paramerter (range) of the data
    (dates for e-g 01-apr-2008 to 03-apr-2008) for which i uses a form.

    now when user gives paramerter it show the result . the result are perfect
    the only thing i nedd is to display the parameter (dates for e-g 01-apr-2008 to 03-apr-2008) at the page header of the each page of report.

    now , how can i get data (dates ) from the form and put it on crystal report page header section

    as bytes does not support much pictures to explian our question clearly
    i had also make a post on


    see this where i uploaded pictues to expliain my question more clearly.

    can any body help me to solve this/
  • Dököll
    Recognized Expert Top Contributor
    • Nov 2006
    • 2379

    #2
    Originally posted by muddasirmunir
    i am using vb6 and crystal report 10

    i want to ask solution of one proble which i am facing in making report.

    first , in my programe i ask the user to give paramerter (range) of the data
    (dates for e-g 01-apr-2008 to 03-apr-2008) for which i uses a form.

    now when user gives paramerter it show the result . the result are perfect
    the only thing i nedd is to display the parameter (dates for e-g 01-apr-2008 to 03-apr-2008) at the page header of the each page of report.

    now , how can i get data (dates ) from the form and put it on crystal report page header section

    as bytes does not support much pictures to explian our question clearly
    i had also make a post on


    see this where i uploaded pictues to expliain my question more clearly.

    can any body help me to solve this/
    Hello muddasirmunir!

    Sorry for your troubles! Might do us a lot of good though if you could simply copy what you posted to the other forum to ours just in case one of us is passing through and has an idea.

    Please copy at least the portion you are having issues with, rest assured you can keep asing questions, all in all to get added hits on your question.

    Thank you, muddasirmunir! In a bit;-)

    Comment

    • anuragshrivastava64
      New Member
      • Jan 2007
      • 66

      #3
      Report.repDate. setText formName.txtDat e

      Comment

      • Jyo72
        New Member
        • Apr 2007
        • 3

        #4
        Hi,

        Why don't you create 2 parameters in crystal report as FromDate & Todate.
        you cna pass the values from VB to crystal report these parameters.
        ex:
        'Global Variable Crystal Report Application
        Public CRApp As CRAXDRT.Applica tion

        Set CRApp = New CRAXDRT.Applica tion
        CRApp.LogOnServ er "P2SODBC.DL L", "Servername ", "DBname", LoginName, Password


        Dim Rpt As CRAXDRT.Report
        Dim m_Rptname as string
        m_rptname = "C:\test1.r pt"

        Screen.MousePoi nter = vbHourglass

        Set Rpt = CRApp.OpenRepor t(m_RptName, CRNOTEXCLUSIVE)
        If Rpt.HasSavedDat a Then Rpt.DiscardSave dData

        If Rpt.ParameterFi elds(1).IsCurre ntValueSet Then Rpt.ParameterFi elds(1).ClearCu rrentValueAndRa nge
        Rpt.ParameterFi elds(1).AddCurr entValue DateFrom
        If Rpt.ParameterFi elds(2).IsCurre ntValueSet Then Rpt.ParameterFi elds(2).ClearCu rrentValueAndRa nge
        Rpt.ParameterFi elds(2).AddCurr entValue DateTo


        ...... in crystal report create a header in Page header section using of this parameters from the report.

        ... Please try this and let me know if any issue is there.

        All the best.





        Originally posted by muddasirmunir
        i am using vb6 and crystal report 10

        i want to ask solution of one proble which i am facing in making report.

        first , in my programe i ask the user to give paramerter (range) of the data
        (dates for e-g 01-apr-2008 to 03-apr-2008) for which i uses a form.

        now when user gives paramerter it show the result . the result are perfect
        the only thing i nedd is to display the parameter (dates for e-g 01-apr-2008 to 03-apr-2008) at the page header of the each page of report.

        now , how can i get data (dates ) from the form and put it on crystal report page header section

        as bytes does not support much pictures to explian our question clearly
        i had also make a post on


        see this where i uploaded pictues to expliain my question more clearly.

        can any body help me to solve this/

        Comment

        Working...