suppress line conditional in crystal report
Solution 1
You can't conditionally suppress a line in CR. I know of two options to get around that:
- Put the line in its own section and then conditionally suppress the section.
- 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
, wherecrWhite
will hide the line,NoColor
will show it.
Solution 2
Simple way,
Insert Text object increase the length of the object as required.
Go to Format Object -> select border property and choose Top or bottom lines.
- 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.
Related videos on Youtube
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, 2020Comments
-
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 over 5 yearsagree with solution 1