Solved

How sort report based upon parm?

Posted on 2002-04-08
6
405 Views
Last Modified: 2010-08-05
Basics:  vb6 sp5, cr8.0, W/2000.

I have written a Visual Basic program that calls a Crystal Report and passes various parameters to it.  One of these parms is the sort parm.  In CR I want the report to sort in one of three ways based upon the passed parm from vb.

I thought that creating a formula that would interogate the parm and point to the field to be sorted would work.  But it gives me errors.  

For example, here is the code in a formula in CR that uses the Select Case method:

Select Case {?mSort_Opt_Parm}
Case "Invoice #"
formula = {Reporting.Inv_No}
Case "Invoice Date"
formula = {Reporting.Inv_Date}
Case "Delivery Date"
formula = {Reporting.Del_Date_Sort}
End Select

This code generates an error.  I swapped out the Select Case with an If, ElseIf etc. code and it does not work either.  Here is that code:

If {?mSort_Opt_Parm} = "Invoice #" Then {Reporting.Inv_No}
ElseIf {?mSort_Opt_Parm} = "Invoice Date" Then {Reporting.Inv_Date}
Else {Reporting.Del_Date_Sort}

I am trying to come up with a formula that points to the field I want the report to sort on, i.e. {Reporting.Inv_No}.  With this type of field, I would only have to add it to the sort dialog box and the report would supposedly sort in the correct sequence based upon the passed parm.  Should I be doing this differently?

Question:  How do I sort a report based upon a passed parameter?

Thanks for the help.
0
Comment
Question by:EYoung
  • 4
  • 2
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
How are you calling the report from VB.  CR provides a sort field array to use.

Here is the code I use

Public Sub preview_Report_from_View_with_Sort(txt_Report_File_Name As String, _
                                                                        txt_Record_Selection_Formula As String, _
                                                                        txt_Sort_Fields() As String, _
                                                                        int_Sort_Field_Count As Integer)
Dim i As Integer
Dim rpt_title As String
    cr_Generic_Report.WindowTitle = rpt_title

    cr_Generic_Report.ReportFileName = txt_Report_File_Name
    cr_Generic_Report.ReplaceSelectionFormula txt_Record_Selection_Formula
    For i = 0 To int_Sort_Field_Count - 1
        cr_Generic_Report.SortFields(i) = txt_Sort_Fields(i)
    Next i
    cr_Generic_Report.WindowState = crptMaximized
    cr_Generic_Report.Destination = crptToWindow
    cr_Generic_Report.WindowShowCloseBtn = True
    cr_Generic_Report.Action = 1
    cr_Generic_Report.Reset
   
End Sub

The sort fields are strings like {view_rpt_basic.student_id}

If you need more information let me know.
good luck

mlmcc
0
 
LVL 7

Author Comment

by:EYoung
Comment Utility
mlmcc,

Here is the code I use in VB to call the report:


Private Sub Form_Activate()
    Set Report = New dsrDetail_and_Summary
   
    Report.EnableParameterPrompting = False

    Report.ParameterFields(1).AddCurrentValue mTeam_No_Parm
    Report.ParameterFields(2).AddCurrentValue mTeam_Name_Parm

    If mTeam_No_Parm <> 0 Then
         Report.RecordSelectionFormula = "{Reporting.mKey} = '" & mKey2 & "'"
    End If

    Screen.MousePointer = vbHourglass
    CRViewer1.ReportSource = Report
    CRViewer1.DisplayTabs = False
    CRViewer1.DisplayToolbar = True
    CRViewer1.EnableGroupTree = False
    CRViewer1.EnableExportButton = True
    CRViewer1.ViewReport

    Screen.MousePointer = vbDefault
End Sub

------------------------------------------

The report has two levels of grouping and then one of three fields make up the third sort field.  For example, the sort fields could be Group1, Group2, Invoice_No.  Or the sort fields could be Group1, Group2, Invoice_Date.

Would I add the .SortFields(i) as follows:

CRViewer1.SortFields(1) = Group1
CRViewer1.SortFields(2) = Group2
CRViewer1.SortFields(3) = Invoice_No

Thnaks for the help.
0
 
LVL 7

Author Comment

by:EYoung
Comment Utility
I tried doing the example above and it did not have any effect on the sort sequence of the report.

Would appreciate any help.  Thanks.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 7

Author Comment

by:EYoung
Comment Utility
Oops, I should have said I tried:

Report.ReportSortFields(1) = ...
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 25 total points
Comment Utility
0
 
LVL 7

Author Comment

by:EYoung
Comment Utility
Thanks for the help.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now