• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

Suppress a field at runtime

hi friends,
how can we suppress a field in crystal report from VB at run time if the field is empty.
0
satdream
Asked:
satdream
  • 5
  • 2
1 Solution
 
rsripracCommented:
Set the field to hide if content is = null.

-Ram
0
 
satdreamAuthor Commented:
hi rsriprac,
if we hide the field, the space will be there. i need to ignore the space if the filed is empty. thankx for ur cooment
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
satdreamAuthor Commented:
hi  WesleySaysHi,
thankx so much for the link that u gave to me. i'll test this replay to u.

0
 
satdreamAuthor Commented:
hi  WesleySaysHi,
as ur link specified, i did everything. but still the space is there. how can i remove the space for that suppressed field.

thankx n regards
0
 
WesleySaysHiCommented:
Lets see.....

1. You read:

"you could create a subreport to replace all of the fields"

Known issue (maybe here was your problem?):

when a formula which tests for a blank field is created, even though the formula has no errors, it does not complete the requested action when the field is empty.

The following formula needs to be created to replace the actual database field on the report.

If IsNull({database.field}) then
" "
else
{database.field};

For Crystal reports 8 and up, about creating report and subreports at runtime you can read at:
http://support.businessobjects.com/library/kbase/articles/c2007211.asp


2. You read:

"Within your subreport you can split the rows into separate detail sections and supress fields / sections as needed"

About how to supress a blank subreport in Crystal Reports 9, read here:
http://www.businessobjects.com/search/?summary=1&ct=livewww-all&site=my_collection&client=my_collection&proxystylesheet=my_collection&output=xml_no_dtd&lr=lang_en&oe=utf8&ie=utf8&website=&q=how+to+suppress+blank+subreports+in+CR+9&btnG.x=19&btnG.y=14

In Crystal Reports 8.5 and earlier, a blank subreport cannot be suppressed.

Read how to supress a section that containes a blank subreport in CR 8.5, if interested:
http://support.businessobjects.com/library/kbase/articles/c2005853.asp

The rest should be clear.

Regards,

Wesley
0
 
satdreamAuthor Commented:
hi WesleySaysHi
thankx so much. hope it will work. after check this i'll inform u

thankx n regards
Sathar
0
 
satdreamAuthor Commented:
hi friends,
thankx so much all of them for try to solve my problem.

thankx n regrads
Sathar
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now