Total Row count in crystal report document

Home Forums Crystal Reports Total Row count in crystal report document

This topic contains 15 replies, has 5 voices, and was last updated by Profile photo of Malik Malik 5 years, 5 months ago.

Viewing 16 posts - 1 through 16 (of 16 total)
  • Author
    Posts
  • #2947
    Profile photo of Sid
    Sid
    Member

    Is there a way to figure out total number of rows in a crystal report
    document ? (I have a report with groupings and sections). Finally wud
    I be able to enter that total # of row count from document in an
    Alert? How? Step by step pls

    #2948
    Profile photo of Ali
    Ali
    Member

    @Esam … Hey Esam, on the bottom of your Crystal Report it should give you a number of records which is your number of rows. As for the alerter issue, it’s likely possible, I just don’t know how.

    #2950
    Profile photo of Sid
    Sid
    Member

    @aftab … Is it possible for you to send me a screen shot of what you just described

    #2951
    Profile photo of Ali
    Ali
    Member

    @esam … If you scroll down it will say Records: 60, right above the taskbar.

    #2952
    Profile photo of Malik
    Malik
    Member

    @esam

    Esam bhai,

    That row count would only show as it shows in Excel i.e. bottom pane displays Records: (count)

    You can try adding a “Running Total Field” so you would have an index next to each row.

    Press F1 for help and then select “Creating Running Totals in a list” to see how to step by step.

    #2953
    Profile photo of Khan
    Khan
    Member

    Isn’t there a rowindex type function?
    Can’t you create a variable with this function?
    Can you add variable to an alert?

    #2954
    Profile photo of Ali
    Ali
    Member

    Wouldn’t the number of Records as shown on the bottom of a Crystal Report and a Row Count in Excel be the same?

    #2955
    Profile photo of Malik
    Malik
    Member

    @aftab … Aftab,
    I think Esam bhai wanted the row count to display in the report itself
    which is irrespective of the tool used to view the report.

    #2956
    Profile photo of LetsLearnBI
    LetsLearnBI
    Member

    :)

    #2959
    Profile photo of Sid
    Sid
    Member

    Exactly Aqeel bhai…lol the f I’m gonna do with the printed count on bottom bar

    #2960
    Profile photo of Sid
    Sid
    Member

    Oh by the way crystal report is sh!t…I miss Web I

    #2958
    Profile photo of Malik
    Malik
    Member

    wow!!

    #2961
    Profile photo of Sid
    Sid
    Member

    I went over this problem with Masum…I have a decent idea now on how to solve this…

    #2962
    Profile photo of Malik
    Malik
    Member

    awesome. Today I was Googling something on webi and found Masum’s youtube video.

    Such work!!
    ..but what’s the rush mate? slow the f down!!

    #2965
    Profile photo of Sid
    Sid
    Member

    Alright so the original problem was to somehow display the Row Count (Number of Records you see on the bottom toolbar) in an Alert in Crystal Reports. Alerts or no Alerts if you simply want to display the number of Records you do RecordNumber and save that into a formula and that should display the # of records in the report (matching the count from the bottom tool bar as well if you put the cell in an appropriate place). But if for instance you wanted to use this in an Alert it won’t work so the following will fix that :

    1) Create a formula, let’s name it Records and type in the following code:
    whilereadingrecords;
    Global NumberVar RecordCount

    2) Go to Report > Alerts > Create or Modify Alerts>New give it a name, then click on the ‘x-2′ button and type in the following: count({@Records}) & ” ”

    3) Finally click on Condition type in TRUE ,save it , OK and Close.

    Next time you refresh your report it will display the number of Records in an Alert. Our company is doing some funky stuff so that’s why they needed this count in an Alert

    FIN !

    #2966
    Profile photo of Malik
    Malik
    Member

    Sweet

Viewing 16 posts - 1 through 16 (of 16 total)

You must be logged in to reply to this topic.