Hide Group Header Elements when Detail Visible

This seems like an easy request but I can't figure it out.
I have a table with multiple groups. Each group header contains subtotal
fields. I want to hide the contents of the subtotal fields on each group
header when that group is expanded but I want the field that contains the
name of the group to remain visible.
Thanks, JonI did this by adding an additional row to the group header.
Put the field that contains the name of the group on row 1 of your header,
and the subtotal field on row 2. Now you can select the field with the group
name to toggle Visibility on or off for both your Details and your Subtotal
field (or row). Leave the Subtotal field visible in the report definition
(Hidden=False), but hide the Details section.
Hth,
Flip
"Jon B" wrote:
> This seems like an easy request but I can't figure it out.
> I have a table with multiple groups. Each group header contains subtotal
> fields. I want to hide the contents of the subtotal fields on each group
> header when that group is expanded but I want the field that contains the
> name of the group to remain visible.
> Thanks, Jon

Hide Folders

Hi All,
I have a list of folders per department
i.e.
HR
Sales
etc
Each of these folders are assigned a group and have been given the default
role of browswer
However when the user logs into the reporting services site, they can see
all the folders - go into them however if they try to browse a report which
they do not have permissions to they get a Page cannot be dsiplayed error?
Surely there is a better way of doing this.
When my user goes into RS, I would either like them to see only the folder
they have been assigned to or at least not even be able to access the
folders at all that they have not been assigned to.
How do I do this.
Please help.
Thanks
KNot sure what you mean. If a user does not have access to an item on the
server, it will not display in Report Manager. Try removing all role
assignments from an item and see if they can see it.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kathy" <joe@.soap.com> wrote in message
news:poydnaDzeqHOL3rcRVn-pQ@.is.co.za...
> Hi All,
> I have a list of folders per department
> i.e.
> HR
> Sales
> etc
> Each of these folders are assigned a group and have been given the default
> role of browswer
> However when the user logs into the reporting services site, they can see
> all the folders - go into them however if they try to browse a report
> which
> they do not have permissions to they get a Page cannot be dsiplayed error?
> Surely there is a better way of doing this.
> When my user goes into RS, I would either like them to see only the folder
> they have been assigned to or at least not even be able to access the
> folders at all that they have not been assigned to.
> How do I do this.
> Please help.
> Thanks
> K
>sql

Hide Duplicates - and border

If a person selects the "hide duplicates" option in a Table/Group, how would
one also hide the "border"?
I've tried using expressions to set the borderstyle to None, and this works,
but I can't figure out how to evaluate if a table cell (value) is "hidden".
Below is what I'm trying to do, hide the border, if the (duplicating) value
is hidden.
Division Product 1999 2000 2001 2002
North Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
South Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
East Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
West Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
Thx,
RussellHaven't tried it but you should be able to use a conditional border based on
the Previous() aggregate.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
news:uN%23WlOexEHA.2036@.TK2MSFTNGP12.phx.gbl...
> Sorry, but my example did not come across as I sent it.
> I've attached a jpg as an example...
> Thx,
> Russell
>
> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
> news:eWFwWGexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> If a person selects the "hide duplicates" option in a Table/Group, how
>> would
>> one also hide the "border"?
>> I've tried using expressions to set the borderstyle to None, and this
>> works,
>> but I can't figure out how to evaluate if a table cell (value) is
>> "hidden".
>> Below is what I'm trying to do, hide the border, if the (duplicating)
>> value
>> is hidden.
>> Division Product 1999 2000 2001 2002
>> North Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> South Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> East Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> West Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>>
>> Thx,
>> Russell
>>
>|||Thanks Brian,
That is my issue. I have been trying to do a conditional border, but I can't
figure out what the "expression" is that I need to use to evaluate to True.
If I test the textbox (in the table) for Value="" it returns a False. I
assume that the textbox still has a value, it's Visibility is just hidden.
So what I can't figure out is the expression to use to test a textbox's
"Visibility" (if this is the correct approach).
Thanks,
Russell
"Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
news:%23Hz3i$ixEHA.1260@.TK2MSFTNGP12.phx.gbl...
> Haven't tried it but you should be able to use a conditional border based
> on the Previous() aggregate.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
> news:uN%23WlOexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> Sorry, but my example did not come across as I sent it.
>> I've attached a jpg as an example...
>> Thx,
>> Russell
>>
>> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
>> news:eWFwWGexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> If a person selects the "hide duplicates" option in a Table/Group, how
>> would
>> one also hide the "border"?
>> I've tried using expressions to set the borderstyle to None, and this
>> works,
>> but I can't figure out how to evaluate if a table cell (value) is
>> "hidden".
>> Below is what I'm trying to do, hide the border, if the (duplicating)
>> value
>> is hidden.
>> Division Product 1999 2000 2001 2002
>> North Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> South Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> East Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> West Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>>
>> Thx,
>> Russell
>>
>>
>

Hide data of collapsed matrix group

I have a matrix with date month on the rows axis. I want to hide all
but the most recent month. The data measures I am using are not
additive so I would like to hide the data for all collapsed groups.
Is this possible? I can't figure out how to reference a report item
to see if it is hidden or not.I got it...
--code to only show values in matrix where the group is visible.
=iif(
count(Fields!Num.Value) > 1
,""
, sum( Fields!Num.Value)
)
--code to set the most recent group to visible - default
=iif(format( Fields!Date.Value,"MMM yy") = format(
First(Fields!MaxDate.Value, "MaxDateForProject") ,"MMM yy")
, false,true)

Hide Columns

Hi,
I have created a report that contains a table. The table returns data w/
multiple statuses. I have created a group based on the status and have a
page break at the end of the group (so each page will display only one status
type). I would like to dynamically show / hide columns based on the status.
Is this possible? I tried setting the visibility of the individual cells,
however, this leaves a gap where the cells were (which is not desirable)â?¦
Any thoughts?
Thanks!Try setting the visibility property on the column instead of the
individual cells.
On Sep 5, 4:18 pm, David <Da...@.discussions.microsoft.com> wrote:
> Hi,
> I have created a report that contains a table. The table returns data w/
> multiple statuses. I have created a group based on the status and have a
> page break at the end of the group (so each page will display only one status
> type). I would like to dynamically show / hide columns based on the status.
> Is this possible? I tried setting the visibility of the individual cells,
> however, this leaves a gap where the cells were (which is not desirable)...
> Any thoughts?
> Thanks!|||Hi Jen,
Can this be done with a Cross-Tab Report? I dont see the Visibility Property
of the column group :( .
--
With Thanks and Regards,
Raja Krishnamurthy
"Jen" wrote:
> Try setting the visibility property on the column instead of the
> individual cells.
> On Sep 5, 4:18 pm, David <Da...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I have created a report that contains a table. The table returns data w/
> > multiple statuses. I have created a group based on the status and have a
> > page break at the end of the group (so each page will display only one status
> > type). I would like to dynamically show / hide columns based on the status.
> > Is this possible? I tried setting the visibility of the individual cells,
> > however, this leaves a gap where the cells were (which is not desirable)...
> >
> > Any thoughts?
> >
> > Thanks!
>
>

Hide Calculated Column in Matrix Report And show only in Total

Hi All,

I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using

InScope, as it creates *Blank column. Please go thru details below.

Year

Month01 02 03 Total

Salary Salary Salary Salary Cumulative (Calc)

Employee01 20 5 25 25

Employee02 10 10 20 45

.....

Total

How can i achieve this?. Any suggestion on this would be appreciated.

Thanks,

You have a couple of options:

1 - Can you add Total Salary as part of your dataset and return that for each Employee/Year ?
If so, then you just include that field in your cumulative statement, so no need for the column

2 - You may be able to take both Tot Salary and Cumulative salary and place them in a single cell using the cells in cells technique. Select your cell and drop a Rectangle control into it. You’ll notice the background change from solid white to the transparent grid pattern. Next, select a textbox control and drop this into the rectangle. You have to get it perfect and sometimes it’s a bit annoying when you don’t land exactly on the control. Next, drop in another textbox so it rests directly beside your first one.
In one cell add your Sal Tot, and in the right textbox the Cumulative Salary. Set the Sal Tot textbox to hidden=True and as small width as possible. To the end user it will appear as though this is a single column.

Hide [+]/[-] toggle sign when group doesnot have any member

Hi,

I need help to hide [+]/[-] sign when a group doesnot have any item in it. Currently, I have a table with a group header where I put the companyName and in the detail section I put the users for that company. I want that, if a company doesnot have any users then there should not be any [+]/[-] sign next to it. Please help!!

Thanks,

-Rohit

Does any one know the answer to this one?

Thanks.

Hidding rows disappearing in Excel export

I have a report that looks fine in Report Server, but when I export to
Excel, I lose data.
I have a group that I am repeating the group footer 3 times. The
original footer is the toggle. when I hit the + in Rep Services, it
expands with no problem, showing all of my hidden rows.
when I export it to excel and hit the toggle, it only shows the first
hidden row and loses the other two.
Any ideas?What version of Report Server and Office do you have?
daw
"M@." wrote:
> I have a report that looks fine in Report Server, but when I export to
> Excel, I lose data.
> I have a group that I am repeating the group footer 3 times. The
> original footer is the toggle. when I hit the + in Rep Services, it
> expands with no problem, showing all of my hidden rows.
> when I export it to excel and hit the toggle, it only shows the first
> hidden row and loses the other two.
> Any ideas?
>|||Microsoft SQL Server Reporting Services Version 8.00.1038.00
Excel 2003
thx,
M@.
On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> What version of Report Server and Office do you have?
> daw
> "M@." wrote:
> > I have a report that looks fine in Report Server, but when I export to
> > Excel, I lose data.
> > I have a group that I am repeating the group footer 3 times. The
> > original footer is the toggle. when I hit the + in Rep Services, it
> > expands with no problem, showing all of my hidden rows.
> > when I export it to excel and hit the toggle, it only shows the first
> > hidden row and loses the other two.
> > Any ideas?|||Are you sure that the rows are not just hidden rows in Excel? Are the row
numbers consecutive?
"M@." wrote:
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> Excel 2003
> thx,
> M@.
> On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> > What version of Report Server and Office do you have?
> >
> > daw
> >
> > "M@." wrote:
> > > I have a report that looks fine in Report Server, but when I export to
> > > Excel, I lose data.
> >
> > > I have a group that I am repeating the group footer 3 times. The
> > > original footer is the toggle. when I hit the + in Rep Services, it
> > > expands with no problem, showing all of my hidden rows.
> >
> > > when I export it to excel and hit the toggle, it only shows the first
> > > hidden row and loses the other two.
> >
> > > Any ideas?
>
>|||I have a group footer (group1) that I repeat. The first line is the
toggle, lines 2-5 are details. I'm using running values. Row 1 is
the sum. Row2 is a sum when a field = PRV, Row3 is a sum when a field
= MCD and so on.
It looks fine in Reporting Services, but if I export it to excel and
hit the toggle, only the first hidden row pops in.
Yeah, the row numbers are consecutive.
On Mar 21, 4:32 pm, daw <d...@.discussions.microsoft.com> wrote:
> Are you sure that the rows are not just hidden rows in Excel? Are the row
> numbers consecutive?
>
> "M@." wrote:
> > Microsoft SQL Server Reporting Services Version 8.00.1038.00
> > Excel 2003
> > thx,
> > M@.
> > On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> > > What version of Report Server and Office do you have?
> > > daw
> > > "M@." wrote:
> > > > I have a report that looks fine in Report Server, but when I export to
> > > > Excel, I lose data.
> > > > I have a group that I am repeating the group footer 3 times. The
> > > > original footer is the toggle. when I hit the + in Rep Services, it
> > > > expands with no problem, showing all of my hidden rows.
> > > > when I export it to excel and hit the toggle, it only shows the first
> > > > hidden row and loses the other two.
> > > > Any ideas... Hide quoted text -
> - Show quoted text -

Hidden Expression for Group Header

I am trying to hide a group header (table row) based on the value of that group, but have not been able to get it working.

Let's say I have 2 groups in my table:

Group 1: State

Group 2: City

I want to hide the group header (tablerow2) where State = "Unknown" but I want the Group 2 cities to still display - just w/o a header.

I tried putting the following expressions on the hidden property of tablerow2 with no luck:

First I tried referencing the field that it's grouped on:

=Iif((Fields!state.Value = "Unknown", true, false)

I also tried refereing the name of the group:

=Iif(("State_GRP" = "Unknown"), true, false)

In both cases, nothing gets hidden - all rows, including the group header that says "Unknown", are visible.

Any help would be greatly appreciated!

Kathleen

You are doing this correctly, and I was not able to reporduce the behavior--it works as you are thinking. I would make sure that the case of "Unknown" is consistent with the field value. I would do this in the expression (or change the query to do the trimming), so that case and extranious white space is not a factor.

=IIF(Fields!state.Value.Trim().ToLower()="unknown", true, false)

Ian

|||Thanks Ian - the trim/tolower seemed to resolve whatever issue I was having.

Hidden Expression enquiry

Help!!!
I have a group that is grouped on a category code...
Under that group is a details line that lists the transactions of that
grouped code
I then have a group footer that has a subtotal...
On my report I also have two parameters Date From and Date To...
In order to show only the category codes and details that are in the user
defined period I have entered the following into the hidden expression
dialog box on the three rows..
=iif(Fields!DATE.Value >= Parameters!Report_Parameter_FROM.Value AND
Fields!DATE.Value <= Parameters!Report_Parameter_To.Value,False, True)
Now for my question:
On my report the details is correct... it shows only the details that fall
between the two data parameters. However, the categoryID sometimes will be
displayed and other times will not. I think it has something to do with the
grouping... but I cannot for the life of me solve it.
Can anyone assist?All,
I have got around the problem through the use of a subreport... but can
anyone explain why this happened?
"AshVsAOD" <.> wrote in message
news:u3tcSIbhEHA.1644@.tk2msftngp13.phx.gbl...
> Help!!!
> I have a group that is grouped on a category code...
> Under that group is a details line that lists the transactions of that
> grouped code
> I then have a group footer that has a subtotal...
> On my report I also have two parameters Date From and Date To...
> In order to show only the category codes and details that are in the user
> defined period I have entered the following into the hidden expression
> dialog box on the three rows..
> =iif(Fields!DATE.Value >= Parameters!Report_Parameter_FROM.Value AND
> Fields!DATE.Value <= Parameters!Report_Parameter_To.Value,False, True)
> Now for my question:
> On my report the details is correct... it shows only the details that fall
> between the two data parameters. However, the categoryID sometimes will
be
> displayed and other times will not. I think it has something to do with
the
> grouping... but I cannot for the life of me solve it.
>
> Can anyone assist?
>

Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
NalakaAFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:

>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that i
s
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>

Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
NalakaAFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:
>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that is
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>sql

Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
Nalaka
AFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/
|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:

>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that is
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>

Hi, from México City

Hi all group
I can't post any comment in my MSDN GROUP (spanish):
http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.es.sqlserver&SLCID=ES&sd=GN&id=fh;ES-ES;NEWSGROUPS
Always send me an error like this:
"Sorry, the page you requested is not available.
The page you were looking for is currently not available. The address may
not be correct, or there may be a temporary problem with this site. Please
try one of the following options:
Check the address for typing errors.
Click the Back button and try a different option from the navigation menu.
Try this page again later.
For additional assistance, try one of the pages below:
Home
Go to the Microsoft Help and Support site
Product Support Center (FAQs and Highlights)
Review common support questions, issues, and new information for Microsoft
products.
TechNet
Search the online support site that provides detailed "how-to" information
for IT professionals concerning Microsoft products.
MSDN
Search the online support site that provides detailed information for
development professionals concerning Microsoft products."
Any ideas, tks
--
Saludos
IIslasIsaias,
Not sure what you are doing to get this error message but look here.
http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&query=the+page+requested+is+not+available&x=11&y=13
Modify the search for the product you are using or the criteria for your
situation.
HTH
Jerry
"Isaias" <Isaias@.discussions.microsoft.com> wrote in message
news:CBD520B3-38FA-4856-A766-CAE0EE00D916@.microsoft.com...
> Hi all group
> I can't post any comment in my MSDN GROUP (spanish):
> http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.es.sqlserver&SLCID=ES&sd=GN&id=fh;ES-ES;NEWSGROUPS
> Always send me an error like this:
> "Sorry, the page you requested is not available.
> The page you were looking for is currently not available. The address may
> not be correct, or there may be a temporary problem with this site. Please
> try one of the following options:
> Check the address for typing errors.
> Click the Back button and try a different option from the navigation menu.
> Try this page again later.
> For additional assistance, try one of the pages below:
> Home
> Go to the Microsoft Help and Support site
> Product Support Center (FAQs and Highlights)
> Review common support questions, issues, and new information for Microsoft
> products.
> TechNet
> Search the online support site that provides detailed "how-to" information
> for IT professionals concerning Microsoft products.
> MSDN
> Search the online support site that provides detailed information for
> development professionals concerning Microsoft products."
> Any ideas, tks
> --
> Saludos
> IIslas|||Tks Jerry
But I can't resolve my problem yet.
:(
--
Saludos
IIslas
"Jerry Spivey" wrote:
> Isaias,
> Not sure what you are doing to get this error message but look here.
> http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&query=the+page+requested+is+not+available&x=11&y=13
> Modify the search for the product you are using or the criteria for your
> situation.
> HTH
> Jerry
> "Isaias" <Isaias@.discussions.microsoft.com> wrote in message
> news:CBD520B3-38FA-4856-A766-CAE0EE00D916@.microsoft.com...
> > Hi all group
> >
> > I can't post any comment in my MSDN GROUP (spanish):
> >
> > http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.es.sqlserver&SLCID=ES&sd=GN&id=fh;ES-ES;NEWSGROUPS
> >
> > Always send me an error like this:
> >
> > "Sorry, the page you requested is not available.
> >
> > The page you were looking for is currently not available. The address may
> > not be correct, or there may be a temporary problem with this site. Please
> > try one of the following options:
> > Check the address for typing errors.
> > Click the Back button and try a different option from the navigation menu.
> > Try this page again later.
> > For additional assistance, try one of the pages below:
> > Home
> > Go to the Microsoft Help and Support site
> > Product Support Center (FAQs and Highlights)
> > Review common support questions, issues, and new information for Microsoft
> > products.
> > TechNet
> > Search the online support site that provides detailed "how-to" information
> > for IT professionals concerning Microsoft products.
> > MSDN
> > Search the online support site that provides detailed information for
> > development professionals concerning Microsoft products."
> >
> > Any ideas, tks
> > --
> > Saludos
> > IIslas
>
>

hi all

http://groups.msn.com/-netusergroup
http://groups.msn.com/-netusergroup
Hi all its my .net user group all r welcome to join
this groups.And develop your skillsjinishivs wrote:

Quote:

Originally Posted by

http://groups.msn.com/-netusergroup
http://groups.msn.com/-netusergroup
>
>
Hi all its my .net user group all r welcome to join
this groups.And develop your skills

Poor grammar. Off-topic here. Redundant with the
microsoft.public.dotnet.* hierarchy of groups. Lame.|||On 10 Giu, 13:41, jinishivs <jinish...@.gmail.comwrote:

Quote:

Originally Posted by

Hi all its my .net user group all r welcome to join
this groups.And develop your skills

I don't want to sound rude, but I will join you group to develop my
skills in Sql Server after you develop yours in English.

P

HelpSQL Agent Security

We have sensitive data that requires the builtin\administrators group be removed so domain admins are unable to see data. When we do this, SQL can continue to run under the local system account, but the SQL Agent cannot.

Does anyone else have a solution that will lockout NT admins (both local and domain) and allow both SQL and the SQL AGENT to run properly?

TIA

Ryan HuntDid you give the new domain account sysadmin rights?

And configure it to start with that account?|||Thanks for the response. I ended up just creating a local admin account for the agent with specific SA rights to the server. Then, had the only department allowed to have access to the data change the password. This seems like the best choice...

Thanks

Help: Question to the Group on Report Grouping

Has anyone successfully created a report that has a main Table and 2 Group
Levels and correctly shows aggregates (SUM) in both Group footers and the
Table footer?
Like this:
_______________________________________________________________
Table
Group #1
Group #2
Detail Row #1 (this shows fields that relate to Group #1. HideDuplicates is
set to True.
Detail Row #2 (this shows fields that relate to Group #2)
Group #2 Footer
Group #1 Footer
Table Footer
_______________________________________________________________
The data I am selecting contains, per row, all the data to populate the
detail rows. (It's basically a flat row that selects invoice and invoice
line item information. So it looks like this:
CustID, InvoiceID, Invoice Number, Invoice Amt, Invoice Line Item ID,
Invoice Line Item Amount...
1,001,123ABC,100.00,1,50
1,001,123ABC,100,2,50
... and so on...
The Invoice fields go in the first detail row. The invoice line item fields
go in the 2nd detail row. I'm just showing line items by invoice by
customer.
I have SUMs in the Group #2 footer. Works fine.
I have SUMs in the Group #1 footer. Problem: Since each detail row
contains the value, it adds them all. For example, if I put invoice amount
in Detail Row #1 and SUM(invoiceamount) in the Group #1 footer it adds
invoice amount in every detail row so, of course, the value isn't correct.
Now, it only shows on the report once because of HideDuplicates is true.
The same applies to what goes in the Table footer.
Is this report design wrong? Any ideas on how to handle this'
--
Adrian M.
MCPHi Adrian,
I'm not 100% sure I understand how you are designing your report, how's
this?: You have many invoices, and each invoice has many line items,
right? So for each invoice you want a sum of the invoice amount?
Without knowing what your groups are, here is what I would suggest, I
hope this helps: I would add another group - this group would be where
you put your invoice fields. There would then only be 1 detail row for
your line items.
Group #1 ?
Group #2 ?
Group #3 invoice info
Detail Row line items
Take care,
Michelle|||I think my question is similar. I'm trying to total items that are grouped
but I don't want all the items totaled, just the grouping. For example, I
have 1 - 1, 2-2's and 3-3's, which display as, 1-1, 2-2, 3-3 (in a table
format). I want to sum those 'groups', meaning the sum would be '6', not '14'.
How can I do that?
Bill
"Adrian M." wrote:
> Has anyone successfully created a report that has a main Table and 2 Group
> Levels and correctly shows aggregates (SUM) in both Group footers and the
> Table footer?
> Like this:
> _______________________________________________________________
> Table
> Group #1
> Group #2
> Detail Row #1 (this shows fields that relate to Group #1. HideDuplicates is
> set to True.
> Detail Row #2 (this shows fields that relate to Group #2)
> Group #2 Footer
> Group #1 Footer
> Table Footer
> _______________________________________________________________
> The data I am selecting contains, per row, all the data to populate the
> detail rows. (It's basically a flat row that selects invoice and invoice
> line item information. So it looks like this:
> CustID, InvoiceID, Invoice Number, Invoice Amt, Invoice Line Item ID,
> Invoice Line Item Amount...
> 1,001,123ABC,100.00,1,50
> 1,001,123ABC,100,2,50
> ... and so on...
> The Invoice fields go in the first detail row. The invoice line item fields
> go in the 2nd detail row. I'm just showing line items by invoice by
> customer.
>
> I have SUMs in the Group #2 footer. Works fine.
> I have SUMs in the Group #1 footer. Problem: Since each detail row
> contains the value, it adds them all. For example, if I put invoice amount
> in Detail Row #1 and SUM(invoiceamount) in the Group #1 footer it adds
> invoice amount in every detail row so, of course, the value isn't correct.
> Now, it only shows on the report once because of HideDuplicates is true.
> The same applies to what goes in the Table footer.
> Is this report design wrong? Any ideas on how to handle this'
> --
> Adrian M.
> MCP
>
>|||So are you trying to COUNT and not SUM?|||No, I'm trying to sum. I'm trying to su the values that are grouped, not all
the values of data set.
"Vivienne" wrote:
> So are you trying to COUNT and not SUM?
>|||I have a similar problem and I know there has to be a way to do it. My
dataset query returns results like this:
Company Value CaseNumber CaseDate
---
Microsoft 134.40 00462 June 25
Microsoft 134.40 01568 May 6
Microsoft 134.40 00224 Sept 12
Sony 212.00 00986 Mar 22
Sony 212.00 02944 Dec 1
I want the company and value shown at the group level, and each case listed
in the details for each company. I can get everything to work except for a
grand total of the company's values.
Here is how I want the report to look:
Microsoft 134.40
00462 June 25
01568 May 6
00224 Sept 12
Sony 212.00
00986 Mar 22
02944 Dec 1
--
Total 346.40
Everything I've tried gives me an error, or returns a Total of 827.20
instead of 346.40.
Thanks in advance for any help.

Help: Instance index

I need to create an instance index for a table group by studentid and classid

CREATE TABLE Table1

(ClassID varchar(10),

StudentID varchar(10),

Fee1 money,

fee2 money,

fee3 money

)

INSERT INTO Table1

VALUES ('02003', '00001', 20,10,15)

INSERT INTO Table1

VALUES ('02003', '00001', 25,15,15)

INSERT INTO Table1

VALUES ('02005', '00001', 10,10,15)

INSERT INTO Table1

VALUES ('02005', '00004', 20,10,15)

INSERT INTO Table1

VALUES ('02005', '00004', 20,10,15)

INSERT INTO Table1

VALUES ('02005', '00004', 20,10,15)

SELECT * FROM Table1

the output i'd like to see is :

ClassIDStudentIDFee1Fee2Fee3Index

020030000120.0010.0015.001

020030000125.0015.0015.002

020050000110.0010.0015.001

020050000420.0010.0015.001

020050000420.0010.0015.002

020050000420.0010.0015.003

Any suggestions on what method to use? Thanks.

Here it is,

Code Snippet

SELECT

ClassID,StudentID,Fee1, Fee2, Fee3,

ROW_NUMBER() over (Partition By ClassId, StudentId Order By ClassId, StudentId) as Index

FROM

Table1

|||

Use ROW_NUMBER()...something like this (didn't test it)

select

ClassID

,StudentID

,Fee1

,Fee2

,Fee3

,RANK() OVER (PARTITION BY ClassID, StudentID ORDER BY Fee1) AS 'Index'

from

Table1

|||

Thanks!!

help: a problem to add a login in sql server

Hello,
I am trying to add a login for a Window NT user
in the SQL server but getting following error messages
Error 15401: Windows NT user or group '%s' not found.
Check the name again.
I have checked all the setting in the domain and could not
find anything wrong.
Plese some one can tell me what should I do to fix it.
Thanks
KarenHave had similar problem. Three times in one year. Some advice I've
received was check PDC & BDC sync, verify upper & lower case, but what
seemed to work for me was to reboot the server. I know this is sometimes
unacceptable, but sometimes it works.
You can do a google search also.
Bill
"Karen" <kchen@.grainscanada.gc.ca> wrote in message
news:086101c35c61$64eea390$a101280a@.phx.gbl...
> Hello,
> I am trying to add a login for a Window NT user
> in the SQL server but getting following error messages
> Error 15401: Windows NT user or group '%s' not found.
> Check the name again.
> I have checked all the setting in the domain and could not
> find anything wrong.
> Plese some one can tell me what should I do to fix it.
> Thanks
> Karen

help: indexed view question

I have created a unique clustered index on a view.
The view does a GROUP BY on 3 of the columns and
uses the COUNT_BIG aggregate function.
I used the following SET commands before creating the view and the index:

SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL ON
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET NUMERIC_ROUNDABORT OFF

I can insert and delete rows from the base table, and the indexed view is updated fine.

However, when a scheduled job does effectively the same thing (delete some rows, and insert some new rows) I get the following error:

Executed as user: NT AUTHORITY\SYSTEM. DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. [SQLSTATE 42000] (Error 1934). The step failed.

Why am I getting this error?

The same SET commands above are in the Transact-SQL code for the job before the delete and before the insert statements.

Thanks,
TomYES!!!!! I found a simple solution!!!

I simply put a GO after the SETs.
Although the code was not exactly in a stored procedure I suppose it acted like it was (the code was in a T-SQL script as one of the steps of a SQL Server agent job in Management Studio).
It may not sound like much, but this will help save 1 hour a month for an end user ... for probably 3-4 years!

Thanks Dan Guzman (SQL Server MVP) and Alex Kuznetsov!!!
:beer: