Problem removing group header

Using SS2000, RS2000, VS2003
I have a report that displays group totals and grand totals but no detail
lines. There is nothing in the group header. I made the height of the group
header as small as possible but there is still too much room between the rows
when the report is run.
I tried removing the group header and that works as far as the space between
rows. However, after removing the group header and running the report, I
noticed that nothing in the report footer was showing up.
Any ideas? Thanks,
--
Dan D.Have you tried setting Group Header's visibility to False?
"Dan D." wrote:
> Using SS2000, RS2000, VS2003
> I have a report that displays group totals and grand totals but no detail
> lines. There is nothing in the group header. I made the height of the group
> header as small as possible but there is still too much room between the rows
> when the report is run.
> I tried removing the group header and that works as far as the space between
> rows. However, after removing the group header and running the report, I
> noticed that nothing in the report footer was showing up.
> Any ideas? Thanks,
> --
> Dan D.|||I tried that and it made the group footer data disappear. Apparently, the
visibility is for the group as a whole and there is no way to make just the
header hidden.
Thanks,
--
Dan D.
"isaak" wrote:
> Have you tried setting Group Header's visibility to False?
> "Dan D." wrote:
> > Using SS2000, RS2000, VS2003
> > I have a report that displays group totals and grand totals but no detail
> > lines. There is nothing in the group header. I made the height of the group
> > header as small as possible but there is still too much room between the rows
> > when the report is run.
> >
> > I tried removing the group header and that works as far as the space between
> > rows. However, after removing the group header and running the report, I
> > noticed that nothing in the report footer was showing up.
> >
> > Any ideas? Thanks,
> > --
> > Dan D.|||Of course you can do this but not from the Edit Group >> Visibility tab. As
you discovered, changing the visibility here affects the whole group.
Make sure the properties window is visible in report designer (menu: View >>
Properties Window) and then select the group header row you want to hide. Now
find the Visibility property in the properties window, expand it and set
Hidden = True.
"Dan D." wrote:
> I tried that and it made the group footer data disappear. Apparently, the
> visibility is for the group as a whole and there is no way to make just the
> header hidden.
> Thanks,
> --
> Dan D.
>
> "isaak" wrote:
> > Have you tried setting Group Header's visibility to False?
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003
> > > I have a report that displays group totals and grand totals but no detail
> > > lines. There is nothing in the group header. I made the height of the group
> > > header as small as possible but there is still too much room between the rows
> > > when the report is run.
> > >
> > > I tried removing the group header and that works as far as the space between
> > > rows. However, after removing the group header and running the report, I
> > > noticed that nothing in the report footer was showing up.
> > >
> > > Any ideas? Thanks,
> > > --
> > > Dan D.|||That did it Jim. Thanks.
--
Dan D.
"Jim" wrote:
> Of course you can do this but not from the Edit Group >> Visibility tab. As
> you discovered, changing the visibility here affects the whole group.
> Make sure the properties window is visible in report designer (menu: View >>
> Properties Window) and then select the group header row you want to hide. Now
> find the Visibility property in the properties window, expand it and set
> Hidden = True.
> "Dan D." wrote:
> > I tried that and it made the group footer data disappear. Apparently, the
> > visibility is for the group as a whole and there is no way to make just the
> > header hidden.
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "isaak" wrote:
> >
> > > Have you tried setting Group Header's visibility to False?
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003
> > > > I have a report that displays group totals and grand totals but no detail
> > > > lines. There is nothing in the group header. I made the height of the group
> > > > header as small as possible but there is still too much room between the rows
> > > > when the report is run.
> > > >
> > > > I tried removing the group header and that works as far as the space between
> > > > rows. However, after removing the group header and running the report, I
> > > > noticed that nothing in the report footer was showing up.
> > > >
> > > > Any ideas? Thanks,
> > > > --
> > > > Dan D.|||Well, this is weird. I just noticed that when I change the visibility on the
group header to false, the report header and footer both disappear, like
they've also been changed to false. I don't see a visibility setting for the
report header and footer under properties, though. Do you have any idea what
happened? If I change the visibility of the group header back to true, the
report header and footer both appear again.
--
Dan D.
"Jim" wrote:
> Of course you can do this but not from the Edit Group >> Visibility tab. As
> you discovered, changing the visibility here affects the whole group.
> Make sure the properties window is visible in report designer (menu: View >>
> Properties Window) and then select the group header row you want to hide. Now
> find the Visibility property in the properties window, expand it and set
> Hidden = True.
> "Dan D." wrote:
> > I tried that and it made the group footer data disappear. Apparently, the
> > visibility is for the group as a whole and there is no way to make just the
> > header hidden.
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "isaak" wrote:
> >
> > > Have you tried setting Group Header's visibility to False?
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003
> > > > I have a report that displays group totals and grand totals but no detail
> > > > lines. There is nothing in the group header. I made the height of the group
> > > > header as small as possible but there is still too much room between the rows
> > > > when the report is run.
> > > >
> > > > I tried removing the group header and that works as far as the space between
> > > > rows. However, after removing the group header and running the report, I
> > > > noticed that nothing in the report footer was showing up.
> > > >
> > > > Any ideas? Thanks,
> > > > --
> > > > Dan D.sql

problem reading datavalues to an arraylist

I have an SQL command below that works fine

"SELECT sum(Preference) FROM [projectDB].[dbo].[Vote] group by preference;

SqlDataReader

datareader = cmdPres.ExecuteReader();
ArrayList myArr =newArrayList();

when i read the data in the values i get are
10,14,10,17

I want to loop through the reader, then add the values to an arrayList. Then i want to check of the value in the arrayList is greater than 15 but it dosent work. I get an error message when i add
sum(Prefernece) to the arraylist, it will not allow me.

while (dreader.Read())
{
myArr.Add(datareader["sum(Preference)"].ToString());

if(myArr.? > 15)
{
Response.Write("Its greater than 15");
}
}

sorry,

think i posted this into the wrong section...its not really an sql problem.

but if anyone has any ideas they will be appriciated

|||

ArrayList uses index to get the specific position's value. Because you use reader() to get the data, you have to add extra steps to do. Here is the clue

int position = 0;

while (dreader.Read())
{

myArr.Add(datareader["sum(Preference)"].ToString());

if((int)myArr[position] > 15)

{
Response.Write("Its greater than 15");
}

position++;

}

Hope it helps

sql

Problem Month Granularity

Hello,

I suppose that my problem is something basic but it's the first time i'm confronted with this.

I want to link a measure group to a time dimension on a Month granularity.

My time dimension is a server time dimension, the inventory data comes on a monthly base, but with a normal datetime field (always the last day of the month). Linking this on a date granularity is no problem, but has no sense. When i set the granularity to Month i'm getting this error.

Errors in the OLAP storage engine: The attribute key cannot be found: Table: ASW_Monthly_Stock, Column: ASW_STOCK_DATE, Value: 31/08/2006. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Month of Dimension: Calendar Time from Database: SdwCubes, Cube: c_Sales, Measure Group: ASW Monthly Stock, Partition: ASW Monthly Stock, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while processing the 'ASW Monthly Stock' partition of the 'ASW Monthly Stock' measure group for the 'c_Sales' cube from the SdwCubes database.

I've seen that when setting the granularity in the Define Relationship window i'm getting a warning 'If you Select a non-key ....', but when i go into the 'Advanced...' button i can link more attributes.

But what function do i have to put on my ASW_STOCK_DATE to link it to the Month attribute of the time dimension ? The T-Sql function Month only returns the Month-number, and not the year ...

So ... if anyone could get me a bit furter on this ... greatly appreciated.

Please check that releationship between measure group and dimension columns is correct, most likely you still have days as a measure group column. To do this go to the Dimension Usage Tab, click on ... near the time dimension name, you'll get window "define relationship".|||

Hi,

Does your table AS_Monthly_Stock stock, store data for the last day of the month.

It seems like the server time dimension has the "month key" as the first day of the month. This can be the cause of your issue.

The easiet option is to change your fact table to record data on the first day of the month.

CAST(CAST(year(getdate())asvarchar)+'-'+CAST(month(getdate())asvarchar)+'-'+'01'asdatetime)

Punita

Problem Month Granularity

Hello,

I suppose that my problem is something basic but it's the first time i'm confronted with this.

I want to link a measure group to a time dimension on a Month granularity.

My time dimension is a server time dimension, the inventory data comes on a monthly base, but with a normal datetime field (always the last day of the month). Linking this on a date granularity is no problem, but has no sense. When i set the granularity to Month i'm getting this error.

Errors in the OLAP storage engine: The attribute key cannot be found: Table: ASW_Monthly_Stock, Column: ASW_STOCK_DATE, Value: 31/08/2006. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Month of Dimension: Calendar Time from Database: SdwCubes, Cube: c_Sales, Measure Group: ASW Monthly Stock, Partition: ASW Monthly Stock, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while processing the 'ASW Monthly Stock' partition of the 'ASW Monthly Stock' measure group for the 'c_Sales' cube from the SdwCubes database.

I've seen that when setting the granularity in the Define Relationship window i'm getting a warning 'If you Select a non-key ....', but when i go into the 'Advanced...' button i can link more attributes.

But what function do i have to put on my ASW_STOCK_DATE to link it to the Month attribute of the time dimension ? The T-Sql function Month only returns the Month-number, and not the year ...

So ... if anyone could get me a bit furter on this ... greatly appreciated.

Please check that releationship between measure group and dimension columns is correct, most likely you still have days as a measure group column. To do this go to the Dimension Usage Tab, click on ... near the time dimension name, you'll get window "define relationship".|||

Hi,

Does your table AS_Monthly_Stock stock, store data for the last day of the month.

It seems like the server time dimension has the "month key" as the first day of the month. This can be the cause of your issue.

The easiet option is to change your fact table to record data on the first day of the month.

CAST(CAST(year(getdate())asvarchar)+'-'+CAST(month(getdate())asvarchar)+'-'+'01'asdatetime)

Punita