Hiding Rows

Hi, I'm new using Crystal Report, currently using Visual Studio 2005. Seeking guidance from you...

I need to generate a product report that retrieves data from more than 10 tables. Under different criterias, some tables might not actually contain data of the particular queried product. Therefore in such case, I wish that the row reflecting data from the table that does not have any record will be invisible, while the row below will move up.

How do I do that? Is there any online reference or anything that I can read and follow... Thanks...

[806 byte] By [wrytat] at [2008-1-7]

«« try-catch-finally
»» Rundll32 and network dialog

# 1

I would suggest that you optimize your query to fetch only required data , this will make the report fast.But istill if you want to supres in report then

1) Right click all the fileds > Format there check supress and formula , ie if that filed is null or blank.It need to be done for all the fields, select all fileds together and then do it.

2) Right click section > Section Expert will open, select the section where you fields are lying and now check "Supress blank section" this will remove blank spaces in between rows.

hope this helps

captJackSparrow at 2007-10-2 >

Visual Studio

Crystal Reports for Visual Studio

Visual Studio Hot Topic

Visual Studio New Topic

Visual Studio

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Hiding Rows...'

Hiding Rows

Visual Studio Hot Topic

Visual Studio New Topic

Visual Studio

Site Classified