Skip to Content
author's profile photo Former Member
Former Member

Programmatically Supress Section and Override Condition

Post Author: Ragu

CA Forum: .NET

Hi Everyone,I am trying to programmatically modify a report when it's being written out in Excel format. The idea is to suppress any page headers, footers, etc. that are not desirable when creating an Excel file (so that the end result looks more like a spreadsheet, rather than a printable document). The reason for doing it this way, is that the reports are sometimes run to PDF and we'd like them to print with nice headers, etc. (Rather than maintain two sets of reports, this originally seemed like a good idea.) Things started out good, but then I noticed I was unable to programmatically suppress some group footers. At first I was totally stumped, but then I realized that in these footers I have a conditional formula set. (Basically it allowed the user to toggle whether or not they wanted to see graphs.) Since I never want these footers in Excel format, I tried setting:SectionFormat.EnableSuppress = true;The problem, it seems, is that the conditional formula overrides the EnableSuppress property. It also seems that there is no way to remove the conditional formula programmatically in .NET.Does anyone out there know of a way to disable or remove the conditional formula programmatically? OR a way to check in a CR formula if the section is already suppressed? I could easy update the conditional suppression to work like this:not() OR {?ShowGraphs} = "No" Thanks in advance.Dan

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2007 at 01:53 PM

    Post Author: Argan

    CA Forum: .NET

    It is not possible using the CR.NET SDK.

    It should be possible using RAS or by using a parameter field as the basis for the conditional formula (ie you can change the value going to the parameter field which is then passed through to the condition.)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2007 at 10:33 PM

    Post Author: bobberino1

    CA Forum: .NET

    Did you ever get a response to this question?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.