suppress line conditional in crystal report

21,876

Solution 1

You can't conditionally suppress a line in CR. I know of two options to get around that:

  1. Put the line in its own section and then conditionally suppress the section.
  2. Put a textbox over the line and then conditionally format the background of the textbox by right-clicking on the textbox -> Format Field -> Border tab -> check Background check box -> click "x+2" box to enter conditional formula, The formula would be something like if condition then crWhite else NoColor, where crWhite will hide the line, NoColor will show it.

Solution 2

Simple way,

  1. Insert Text object increase the length of the object as required.

  2. Go to Format Object -> select border property and choose Top or bottom lines.

  3. Put some text (like under score or space) for object text and minimize the width of the object so that you can't see the provided data to the object but still border appears as a line.

As it worked for me.

Share:
21,876

Related videos on Youtube

Shohel
Author by

Shohel

Hi, I am Shohel Rana, a creative software developer with a solid programming background on web technologies, endeavoring to come to global attention in the tech world. As a software engineer, I enjoy bridging the gap between research and engineering combining my technical knowledge with my sharp eye for Machine Learning and Data Science to create an innovative application. When I'm not in front of a computer screen, I'm probably busy with doing some research on AI stuffs or focusing on setting myself up for achieving a leadership role in any challenging and creative environment. KEY SKILLS • JavaScript (ES6/ES2015), TypeScript, React (Hook, Redux, Context API), Angular 2+ (Material, ngRx, ngXs), AngularJS, Vue, RequireJS, jQuery, jQuery UI, Ajax, Webpack, Gulp, Yarn, Bower, Angular CLI, CreateReactApp, Jasmine, Karma, Protractor, Jest, Mocha, Enzyme. • HTML5, CSS, Twitter Bootstrap, Material Design, SASS. • .NET (C#, ASP.NET, ASP.NET MVC, ASP.NET Core, WPF, Silverlight, ADO.NET, EF, SSRS, RDLC, Crystal Report), Java (Spring, Spring Boot, Hibernate, Maven, Jesper) NodeJS (Express.js, Next.js), Microservices, SOAP, REST, PHP (Laravel, WordPress). • MySQL, MsSQL, MongoDB, NeoDB, Redis, PostgreSQL, Oracle. • TFS, Git, SVN, Docker. • AI (Natural Language Processing, Machine Learning, Deep Learning, Expert System)

Updated on October 15, 2020

Comments

  • Shohel
    Shohel over 3 years

    I've a vertical line that i want to suppress with a condition. Unfortunately I don't see the condition option by a line. When I use an empty textbox, all the other text is moved down. Is there conditional another suppress option for a line?

  • Moumit
    Moumit over 5 years
    agree with solution 1