Is it possible to keep the page header at top of browser page with drill enabled?

When I click a drilldown [+] on a report in the browser the page starts
at the point where I start (click) the drill. Everything above the
click-point is above and I have to scroll up to see it. Is there a way
to keep the heading visible on a report using drill?RS 2005 will provide floating headers on table or matrix which may be close
to what you are looking for. For RS 2000 I can't think of anything that
would do it - unless you try to write your own "report viewing" application
which shows the required context information outside the boundaries where
you show the report contents.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Merkin" <flyin_merkin@.yahoo.com> wrote in message
news:1112206546.496405.301270@.f14g2000cwb.googlegroups.com...
> When I click a drilldown [+] on a report in the browser the page starts
> at the point where I start (click) the drill. Everything above the
> click-point is above and I have to scroll up to see it. Is there a way
> to keep the heading visible on a report using drill?
>

Is it possible to dynamically create columns in a table in SSRS

Hi,

I have a sproc that returns somevalues and everything is working fine... and in my reports i am assigning the header data (in a detail column) based on the some feilds in the sproc... and there around 20 feilds that i want to show... but at a given time i am pretty sure that there wont be more than 10 fields that will have data.

So is it possible that show only the columns that have data in it and sometimes if there is less that 5 - 6 fields.. i want to realign the widths of the column in those tables without shrinking the size of the Table...

any help is appreciated..

Regards

Karen

Hi,

So is it possible that show only the columns that have data in it and sometimes if there is less that 5 - 6 fields.. i want to realign the widths of the column in those tables without shrinking the size of the Table...

If there's no record in one of your row, you can use =IsNothing(Fields!productname.Value) filter your record. But if you want to hide the column that has no data, I suggest you to handle these works in your data accessing modular. For example, if you check one of your column is empty, just remove the column in your record set, so the column would not show in the report.

Thanks.

|||

Jin,

Thanks for your response.. what do u mean by remove the column from the recordset... cause i am populating the Reports using a stored procedure and sometimes... there may be some data or not..

Can u pls give me code snipet or an example

Regards

Karen

|||

Hi,

if you check one of your column is empty, just remove the column in your record set, so the column would not show in the report.

Here's the sample code, suppose you have two fields, Sp and Hd. If there's no data in Hd field of your return set, then only Sp field would been selected.

DECLARE @.NULLCOUNTINTSELECT @.NULLCOUNT =COUNT(*)FROM MatrixCapitalWHERE MatrixCapital.Spisnot nullif @.NULLCOUNT=0BEGIN SELECT MatrixCapital.HdFROM MatrixCapitalEND ELSEBEGIN SELECT MatrixCapital.Hd,MatrixCapital.SpFROM MatrixCapitalEND

Thanks.|||

Jin,

Thanks a lot for your answer so this mean that if i have more 5 - 6 columns NULL... i have check for each column in the NULL count and then prob union for each feild so that my end resultset will be columns that has data in them?

I have another question too.. if i have a table variable like

Declare @.tbl table

(

tblid int indentity(1,1),

Col 1,

Col 2,

..,

Col n

)

Is it possible to have a variable column size depending on the number of entries in my select column like for example.. my if i have 10 columns in my select statement and in that 5 are null... so can just insert 5 rows to the table and then remove the remaining columns out.

Regards

Karen

|||

Hi,

i have check for each column in the NULL count and then prob union for each feild so that my end resultset will be columns that has data in them?

Yes, that's right.

Is it possible to have a variable column size depending on the number of entries in my select column like for example..

Based on my knowledge, another way i can see is to use CASE WHEN clause in your SQL, but it still requires you to give differrent sql statments accoring to the "isNUll" result of a column.

Thanks.

sql

Is it possible to create a cover page in SSRS 2005?

Very simply, I need to add a cover page to my SSRS 2005 report. I've tried this using the Page Header region, but the cover page will not show up on Preview or Export. How and where do I create a cover page?

Hi, Bibble,

Whatever you place first on the Report Design surface (the dotted white area), renders first. So try adding a rectangle which will act as a container, put whatever you want in the rectangle, and set a page break at the end of the rectangle.

==========================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Is HierarchyUniqueNameStyle Enumeration Working?

Hi,

When I am performing a drillthrough on my cubes I discover the header of my drillthrough report of all column consist of [<DimensionUniqueName>].[<HierarchyName>]. I am trying to make the header of all columns to contain only [<HierarchyName>].

After reading http://msdn2.microsoft.com/en-us/library/microsoft.analysisservices.hierarchyuniquenamestyle.aspx, I set this property in my cube to ExcludeDimensionName, however, it does not solve remove the DimensionUniqueName from my drillthrough report.

Anyone has any idea how to remove DimensionUniqueName from the header of my drillthrough report?

I am having the same problem. hierarchyuniquenamestyle set to ExcludeDimensionNam doesn't work neither.