Extra white space in table

I've got a table with a header, group, and detail row. The detail row
is collaspable however when it's collasped there is several lines of
white space between the parent groups. How do I get rid of this white
space?
Thanks in advance for the helpIs it possible that the white space is really the detail row, and it is
not shrinking as expected? (I've had this same problem before...) If
you are supressing just a column or two, but not hiding the entire
detail row (such as setting visibility --> hidden property based upon
conditional expression) then you will get the spacing issue as
described.|||Thanks Matt
That was the problem. I was setting the visibility at the cell level
when i should have been setting it on the over all row. thanks for the
help
Mathiassql

Extra Lines in ReportViewer (lots of em)

Any idea where these extra lines are coming from in the detail? The data is being summarized correctly. I just need to dump all the extra space. I'm one stumped kahuna.

Maybe the datasource is returning a bunch of empty strings. I assume this table is set to grow with the data.|||I thought that, too, and checked it out. In one or two cases it is returning just a couple empty strings but nothing like what I'm seeing here.

Extra Blank Page at end of Report

I have a crystal report and it is printing an extra blank page at the end. I have the detail ruler coming right up to the end of the text and I have surpressed the report header and footer. Any idea?In the section expert window, check if the 'New page after' options is checked for any of the sections.

If so, try this:
click on the X+2 button to the right of it and enter the following formula
Not OnLastRecord|||Thanks! In the Page Footer Section Expert, it is checked, but is greyed out so I can't uncheck it or alter it (see attached shot). Do you know how to un-grey it out?

Thanks,
Michael|||:) No, this is not the case...

Sorry, I didn't mention but I meant Detail, GH, GF sections, for which you would be able to uncheck the 'New Page after' option.
How about the 'New Page before' for the RF section? Is it checked?|||Yes...but it is greyed out like the page footer :(|||...'New Page Before' for the RF ?

Check this, may be you will find it useful:

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=http--supportbusinessobjectscom-communityCS-TechnicalPapersNoNav-crremoveblankspdfasp&sliceId=&dialogID=4246102&stateId=1%200%204244224

Actually, your situation is strange for me: you have no groups in the report just Details...

Expressions not working if Matrix cell is not populated by dataset

Hi
I'm using the following expression for the BackGroundColor in a matrix
detail cell:
=IIF(Fields!ID_Quarter.Value = "Cumulative", "Gainsboro","Transparent")
This is checking the value of another cell before setting the
BackGroundColor value.
I'm also using an expression for the bottom border style:
=IIF(Fields!ID_Quarter.Value = "Cumulative", "Solid","Dotted")
This is checking the value of the same cell that the BackGroundColor
expression checks.
These expression ONLY work if the cell has been populated from the dataset
(in my matrix some cells don't have a value - this is expected).
My Cell has three expressions all up, the remaining expression checks it's
own value for nothing and then put's a "0" in the cell if true.
=IIF(Fields!Deep_SSI.Value = Nothing,"0",Sum(Fields!Deep_SSI.Value))
This expression always works.
Is there a problem with using more than one expression on a cell' I think
not because they all work fine if the cell is populated.
Any thoughts?
SimonBHello...
RE: Expressions not working if Matrix cell is not populated by dataset!
Has anyone got any clues on this problem?
Simon
"simonb" wrote:
> Hi
> I'm using the following expression for the BackGroundColor in a matrix
> detail cell:
> =IIF(Fields!ID_Quarter.Value = "Cumulative", "Gainsboro","Transparent")
> This is checking the value of another cell before setting the
> BackGroundColor value.
> I'm also using an expression for the bottom border style:
> =IIF(Fields!ID_Quarter.Value = "Cumulative", "Solid","Dotted")
> This is checking the value of the same cell that the BackGroundColor
> expression checks.
> These expression ONLY work if the cell has been populated from the dataset
> (in my matrix some cells don't have a value - this is expected).
> My Cell has three expressions all up, the remaining expression checks it's
> own value for nothing and then put's a "0" in the cell if true.
> =IIF(Fields!Deep_SSI.Value = Nothing,"0",Sum(Fields!Deep_SSI.Value))
> This expression always works.
> Is there a problem with using more than one expression on a cell' I think
> not because they all work fine if the cell is populated.
> Any thoughts?
> SimonB

Exports to Excel the details of the report but I need summary

The trouble I am having is that I have a drilldown report that exports the detail to Excel, but I want the summary exported to Excel.

I perform the following steps but get wrong results. Please help me identify the correct steps for the correct results. Thanks you.

1) Select Matrix.

2) Right click, select Properties.

3) Select tab Groups.

4) Select item in Columns list, click Edit.

5) Select tab Visibility.

6) Select Initial visibility: Hidden, and click okay to the Grouping and Sorting dialog box.

Now I can export summary to Excel okay, but now I can not expand the summary in the report itself, so I do the following:

7) Do one through six above (but do not close dialog box), then click visibility can be toggled by another report item.

8) Select the report item in the Report Item drop down list.

Now the report functions normally in the Reporting Services report web page, but when I export on the summary level, again it exports the detail to Excel, but what I want it to export is the summary.

Ideas?

Is this forum active? Only when the drilldown functionality is disabled does the summary export to excel, even though the summary column is calculated from the underlying detail columns. As soon as the drilldown feature is enabled, then the export to excel generates the detail data, even though it is the summary being displayed in the Reporting Services report at the time of the export. Ideas? Anyone?|||

http://msdn2.microsoft.com/en-us/library/aa178935(SQL.80).aspx

I believe I found the answer to the question of why this report is exporting to the detail. Click on the link above peruse down to this comment, here:

“For matrices, if the matrix is collapsed when viewed in HTML, exporting to Excel expands it. All rows and columns are visible. ”

Part of my confusion comes from being told by the users that this used to work prior to the service pack 2 upgrade. However, I suspect that the summary was never exported to Excel, even prior to the upgrade.

To export with the appropriate summary, I am recommending that the report move from implementing a matrix, to implementing a table for drilldown.

Exports to Excel the details of the report but I need summary

The trouble I am having is that I have a drilldown report that exports the detail to Excel, but I want the summary exported to Excel.

I perform the following steps but get wrong results. Please help me identify the correct steps for the correct results. Thanks you.

1) Select Matrix.

2) Right click, select Properties.

3) Select tab Groups.

4) Select item in Columns list, click Edit.

5) Select tab Visibility.

6) Select Initial visibility: Hidden, and click okay to the Grouping and Sorting dialog box.

Now I can export summary to Excel okay, but now I can not expand the summary in the report itself, so I do the following:

7) Do one through six above (but do not close dialog box), then click visibility can be toggled by another report item.

8) Select the report item in the Report Item drop down list.

Now the report functions normally in the Reporting Services report web page, but when I export on the summary level, again it exports the detail to Excel, but what I want it to export is the summary.

Ideas?

Is this forum active? Only when the drilldown functionality is disabled does the summary export to excel, even though the summary column is calculated from the underlying detail columns. As soon as the drilldown feature is enabled, then the export to excel generates the detail data, even though it is the summary being displayed in the Reporting Services report at the time of the export. Ideas? Anyone?|||

http://msdn2.microsoft.com/en-us/library/aa178935(SQL.80).aspx

I believe I found the answer to the question of why this report is exporting to the detail. Click on the link above peruse down to this comment, here:

“For matrices, if the matrix is collapsed when viewed in HTML, exporting to Excel expands it. All rows and columns are visible. ”

Part of my confusion comes from being told by the users that this used to work prior to the service pack 2 upgrade. However, I suspect that the summary was never exported to Excel, even prior to the upgrade.

To export with the appropriate summary, I am recommending that the report move from implementing a matrix, to implementing a table for drilldown.

Exporting to CSV

I have a report which is just a simple table with only the detail row (which then as about a dozen columns)

I have uploaded this to report manger. The report generates correctly and I export to CSV.

But when I open the CSV file there are Headings at the top. I want to know is there any way of getting rid of there headers so it is jus the data which shows.

(The headers seem to be the name of the textbox column in reporting services)

See this post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1487851&SiteID=1

cheers,

Andrew