Skip to Content
avatar image
Former Member

Hiding a data field in SAP Crystal Reports 2011


Hello,

I am new to SAP Crystal Reports 2011 (Crystal Reports).

Does any one know how to hide a Special Field in a Crystal Report?

Specifically, I am trying to hide the Special Field, 'Record Number' from displaying on my report.

I need the Special Field, 'Record Number' to know how many records was printed on my report

in order to limit the amount of records printed while I am testing this new report.

Thanks for the help!

Tony

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 18, 2014 at 03:09 PM

    Hi Tony,

    Right-click the field > format field > common tab > check 'Suppress'.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Hey Tony,

      You cannot use the RecordNumber field to filter records. Also DJ's suggestion about 'suppressing' the section based on this field might not be the best one in terms of report's performance either.

      You should consider adding another field in your datasource that 'numbers' each row (more like what the RowNum() function in oracle does) and use this in the record selection formula.

      If you're reporting against a Stored Proc or a Command Object, you can simply use the field I mentioned above in the where clause of the query.

      -Abhilash