addning roles to a user

I created a "standard" role called "TestRole". Then I went to the list of
users and selected "dbo". I tried adding "TestRole" but I received a message
"Error 15405: Cannot use the reserved user or role name 'dbo'". I have
looked thru various sources to try to understand this but nothing really
straightforward explains what the problem is.
Hi Steven
Please ALWAYS state what version you are running.
The user dbo can do everything in a database. Why do you want to add that
user to a role?
What are you trying to accomplish?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:46113FB9-B978-4DC3-83BE-609BACE5F8F1@.microsoft.com...
>I created a "standard" role called "TestRole". Then I went to the list of
> users and selected "dbo". I tried adding "TestRole" but I received a
> message
> "Error 15405: Cannot use the reserved user or role name 'dbo'". I have
> looked thru various sources to try to understand this but nothing really
> straightforward explains what the problem is.
>
sql

addning roles to a user

I created a "standard" role called "TestRole". Then I went to the list of
users and selected "dbo". I tried adding "TestRole" but I received a message
"Error 15405: Cannot use the reserved user or role name 'dbo'". I have
looked thru various sources to try to understand this but nothing really
straightforward explains what the problem is.Hi Steven
Please ALWAYS state what version you are running.
The user dbo can do everything in a database. Why do you want to add that
user to a role?
What are you trying to accomplish?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:46113FB9-B978-4DC3-83BE-609BACE5F8F1@.microsoft.com...
>I created a "standard" role called "TestRole". Then I went to the list of
> users and selected "dbo". I tried adding "TestRole" but I received a
> message
> "Error 15405: Cannot use the reserved user or role name 'dbo'". I have
> looked thru various sources to try to understand this but nothing really
> straightforward explains what the problem is.
>

addning roles to a user

I created a "standard" role called "TestRole". Then I went to the list of
users and selected "dbo". I tried adding "TestRole" but I received a message
"Error 15405: Cannot use the reserved user or role name 'dbo'". I have
looked thru various sources to try to understand this but nothing really
straightforward explains what the problem is.Hi Steven
Please ALWAYS state what version you are running.
The user dbo can do everything in a database. Why do you want to add that
user to a role?
What are you trying to accomplish?
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:46113FB9-B978-4DC3-83BE-609BACE5F8F1@.microsoft.com...
>I created a "standard" role called "TestRole". Then I went to the list of
> users and selected "dbo". I tried adding "TestRole" but I received a
> message
> "Error 15405: Cannot use the reserved user or role name 'dbo'". I have
> looked thru various sources to try to understand this but nothing really
> straightforward explains what the problem is.
>

Additional JOIN altering values

Can anyone see why I would get different GrossSales values by adding the
JOIN on LaborJobCosts?
****************************************
******
This gives the correct GrossSales values:
DECLARE @.BeginSaleDate datetime
DECLARE @.EndSaleDate datetime
SET @.BeginSaleDate = '6/1/2004'
SET @.EndSaleDate = '6/1/2005'
SELECT
SC.ItemSaleCode,
ISNULL(SUM(ISNULL(S.TotalSaleAmount,0)),0) as GrossSales
FROM Sales S
RIGHT JOIN SaleCodes SC
ON SC.ItemSaleCode = S.ItemSaleCode
WHERE S.CompletedDate BETWEEN @.BeginSaleDate AND @.EndSaleDate
GROUP BY SC.ItemSaleCode
Results (correct):
ItemSaleCode GrossSales
C 373807.08
D 39213.52
P 113303.00
R 204072.92
S 119939.00
W 506886.13
****************************************
******
Now if I add a JOIN for the LaborCosts table, I get incorrect values for my
GrossSales (but the LaborCosts are correct!):
DECLARE @.BeginSaleDate datetime
DECLARE @.EndSaleDate datetime
SET @.BeginSaleDate = '6/1/2004'
SET @.EndSaleDate = '6/1/2005'
SELECT
SC.ItemSaleCode,
ISNULL(SUM(ISNULL(S.TotalSaleAmount,0)),0) as GrossSales,
ISNULL(SUM(ISNULL(LC.LaborCost,0)), 0) AS LaborCosts
FROM Sales S
RIGHT JOIN SaleCodes SC ON SC.ItemSaleCode = S.ItemSaleCode
LEFT OUTER JOIN LaborJobCosts LC ON LC.SalesID = S.SalesID
WHERE S.CompletedDate BETWEEN @.BeginSaleDate AND @.EndSaleDate
GROUP BY SC.ItemSaleCode
Results (inflated and incorrect):
ItemSaleCode GrossSales
C 936678.78
D 29213.52
P 300171.00
R 264072.84
S 207079.00
W 529586.13
****************************************
******
CREATE TABLE [dbo].[Sales] (
[SalesID] [int] IDENTITY (1, 1) NOT NULL ,
[CompletedDate] [smalldatetime] NULL ,
[ItemSaleCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[SaleCodes] (
[SaleCodeID] [int] IDENTITY (1, 1) NOT NULL ,
[ItemSaleCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[JobType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LaborJobCosts] (
[LaborCostsID] [int] IDENTITY (1, 1) NOT NULL ,
[SalesID] [int] NULL ,
[LaborCost] [money] NULL
) ON [PRIMARY]
GOIt looks like SalesId isn't unique in the LaborJobCosts table. Try the
following query. Notice that RIGHT JOIN is redundant in your original - the
WHERE clause turns it into an INNER JOIN anyway. I've also taken out the
ISNULLs from inside the SUM functions - they don't achieve anything except
possibly slow things down.
It helps if you include keys and constraints with your DDL and also post
INSERT statements for some sample data. What you did post tells us that the
LaborJobCosts doesn't have any key other than the IDENTITY column. That's a
potentially serious design flaw.
SELECT SC.itemsalecode,
ISNULL(SUM(S.totalsaleamount),0) AS grosssales,
ISNULL(SUM(LC.laborcost),0) AS laborcosts
FROM Sales S
JOIN SaleCodes SC
ON SC.itemsalecode = S.itemsalecode
LEFT JOIN
(SELECT salesid, SUM(laborcost) AS laborcost
FROM LaborJobCosts
GROUP BY salesid) AS LC
ON S.salesid = LC.salesid
WHERE S.completeddate BETWEEN @.beginsaledate AND @.endsaledate
GROUP BY SC.itemsalecode
David Portas
SQL Server MVP
--|||hi
you might be getting a lot rows from the query and they are getting
hidden because of the SUM and GROUP BY,
please try to remove the SUM and GROUP BY and see the duplicate rows.
once the duplicate rows are eliminated then u can see the expected
results again
best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***|||David Portas wrote:
> I've also taken out the ISNULLs from inside the SUM functions
> - they don't achieve anything except possibly slow things down.
They MAY achieve something: if there are NULL-s in that column, the
ISNULL from inside the SUM prevents the "Warning: Null value is
eliminated by an aggregate or other SET operation.". For example:
CREATE TABLE Test (
ID int primary key,
Value int NULL
)
SELECT SUM(Value) FROM Test
SELECT SUM(ISNULL(Value,0)) FROM Test
SELECT ISNULL(SUM(Value),0) FROM Test
SELECT ISNULL(SUM(ISNULL(Value,0)),0) FROM Test
SET NOCOUNT ON
INSERT INTO Test VALUES (1, 100)
INSERT INTO Test VALUES (2, 100)
INSERT INTO Test VALUES (3, 200)
INSERT INTO Test VALUES (4, null)
SET NOCOUNT OFF
SELECT SUM(Value) FROM Test
SELECT SUM(ISNULL(Value,0)) FROM Test
SELECT ISNULL(SUM(Value),0) FROM Test
SELECT ISNULL(SUM(ISNULL(Value,0)),0) FROM Test
I'm not saying that the original poster intended this, nor that it's a
good thing. The warning is harmless most of the times and the best way
to avoid it would be to make that column not nullable. I'm only saying
that the ISNULL-s inside the SUM can make a difference.
Razvan|||You are correct in that the NULL inside the column does prevent the warning.
And it is intended -- I want to ensure I get a value back in the event there
was no value. Alternatively, I could turn the warnings off and/or use
ArithAbort and/or ArithIgnore, but I may just go in and prevent this from
occuring :=)
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1122211153.821275.237420@.o13g2000cwo.googlegroups.com...
> David Portas wrote:
> They MAY achieve something: if there are NULL-s in that column, the
> ISNULL from inside the SUM prevents the "Warning: Null value is
> eliminated by an aggregate or other SET operation.". For example:
> CREATE TABLE Test (
> ID int primary key,
> Value int NULL
> )
> SELECT SUM(Value) FROM Test
> SELECT SUM(ISNULL(Value,0)) FROM Test
> SELECT ISNULL(SUM(Value),0) FROM Test
> SELECT ISNULL(SUM(ISNULL(Value,0)),0) FROM Test
> SET NOCOUNT ON
> INSERT INTO Test VALUES (1, 100)
> INSERT INTO Test VALUES (2, 100)
> INSERT INTO Test VALUES (3, 200)
> INSERT INTO Test VALUES (4, null)
> SET NOCOUNT OFF
> SELECT SUM(Value) FROM Test
> SELECT SUM(ISNULL(Value,0)) FROM Test
> SELECT ISNULL(SUM(Value),0) FROM Test
> SELECT ISNULL(SUM(ISNULL(Value,0)),0) FROM Test
> I'm not saying that the original poster intended this, nor that it's a
> good thing. The warning is harmless most of the times and the best way
> to avoid it would be to make that column not nullable. I'm only saying
> that the ISNULL-s inside the SUM can make a difference.
> Razvan
>|||Yep, I could remove the SUM and the GROUP BY, thus negating the entire
reason for the query in the first place, but I'm trying to get the whole
enchilada so I can use the summed values in a report. However I believe you
are correct in thinking there are duplicate rows being created -- I'll dig
into that further. Thanks.
"Chandra" <chandra@.discussions.hotmail.com> wrote in message
news:%23Pk9DQDkFHA.1968@.TK2MSFTNGP14.phx.gbl...
> hi
> you might be getting a lot rows from the query and they are getting
> hidden because of the SUM and GROUP BY,
> please try to remove the SUM and GROUP BY and see the duplicate rows.
> once the duplicate rows are eliminated then u can see the expected
> results again
> best Regards,
> Chandra
> http://groups.msn.com/SQLResource/
> http://chanduas.blogspot.com/
> ---
> *** Sent via Developersdex http://www.examnotes.net ***|||This is why you guys are MVPs ... that was perfect, giving me precisely the
results I was looking for.
The inner ISNULLS were being used to prevent warnings (as I noted in the
post below), but I am going to clean that up so no NULLS are possible.
Thanks very much for your help.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:mKidneN_kpIx237fRVn-jQ@.giganews.com...
> It looks like SalesId isn't unique in the LaborJobCosts table. Try the
> following query. Notice that RIGHT JOIN is redundant in your original -
> the WHERE clause turns it into an INNER JOIN anyway. I've also taken out
> the ISNULLs from inside the SUM functions - they don't achieve anything
> except possibly slow things down.
> It helps if you include keys and constraints with your DDL and also post
> INSERT statements for some sample data. What you did post tells us that
> the LaborJobCosts doesn't have any key other than the IDENTITY column.
> That's a potentially serious design flaw.
> SELECT SC.itemsalecode,
> ISNULL(SUM(S.totalsaleamount),0) AS grosssales,
> ISNULL(SUM(LC.laborcost),0) AS laborcosts
> FROM Sales S
> JOIN SaleCodes SC
> ON SC.itemsalecode = S.itemsalecode
> LEFT JOIN
> (SELECT salesid, SUM(laborcost) AS laborcost
> FROM LaborJobCosts
> GROUP BY salesid) AS LC
> ON S.salesid = LC.salesid
> WHERE S.completeddate BETWEEN @.beginsaledate AND @.endsaledate
> GROUP BY SC.itemsalecode
> --
> David Portas
> SQL Server MVP
> --
>|||Earl wrote:
> I want to ensure I get a value back in the event there was no value.
As shown by my example, you will get a value even if you DON'T use
ISNULL inside the SUM, as long as you use ISNULL outside the SUM.

> Alternatively, I could turn the warnings off and/or use ArithAbort and/or ArithIgn
ore
Using ArithAbort and/or ArithIgnore will not prevent this warning.
AFAIK, there is no configuration setting to turn off this warning.
Razvan|||> The inner ISNULLS were being used to prevent warnings
Try:
SET ANSI_WARNINGS OFF
David Portas
SQL Server MVP
--

Adding\Removing roles to Yuokon Database

Hi all,
I am trying to access the database roles of a database made in Sql Server
2005 (Yukon).
I am trying to create a new role for a databse. Here is the code
public void AddRole(string role)
{
Server server = new Server();
string strConnection = "";
strConnection = "DataSource=server
name;Provider=MSOLAP.3;Initial Catalog=DatabaseName";
server.Connect(strConnection);
Database db = new Database();
db = server.Databases.FindByName("DatabaseName");
db.Roles.Add(role);//db.Roles.Remove(role);
db.Update();
server.Disconnect();
}
I can successfully read the roles for that particular database , however i
cannot add or remove a role . Kindly advice.Hello nick1234,
For questions of SQL Server 2005, please post at the following Newsgroup:
Microsoft SQL Server 2005 Beta 2 Newsgroups
http://communities.microsoft.com/ne...qlserver2005&sl
cid=us
Thanks for your understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.sql

Adding/Previewing custom table style

Hi,

I need to add and preview custom table styles. I was able to add custom style by editing the StyleTemplates.xml file under "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles' as per one of the postings here.

Now, how should I add the ability for the user to preview this custom style. I can write a form similar to MS "Choose table style" proobably. Is there a way to launch a particular page of the report wizard programatically?

Thanks,

-Surendra

I have the same problem, Have you find the solution?

Adding/Previewing custom table style

Hi,

I need to add and preview custom table styles. I was able to add custom style by editing the StyleTemplates.xml file under "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles' as per one of the postings here.

Now, how should I add the ability for the user to preview this custom style. I can write a form similar to MS "Choose table style" proobably. Is there a way to launch a particular page of the report wizard programatically?

Thanks,

-Surendra

I have the same problem, Have you find the solution?

Adding, Deleting rows from Visual Basic 2005 Express Edition

Hi,

I'm a complete novice concerning SQL Server (Express Edition)

I'm trying to Add or Delete rows froma VB 2005 Express Function or Sub. While the program is running everything is ok. Except when restarted added records are gone and deleted records are back.

Have i missed an option during installation?

Thx,

Steven

Your installation of SQL Server 2005 Express may be operating in 'Snapshot Isolation' mode. Refer to Books Online for more details.

You may also find this series of instructional videos to be useful.

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#1

|||

Make sure that you did not specify the datafile for "Always copy", if you did this, the file will always be copied from scratch upon new start of the Visual Studio debug session.

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

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Arnie,

Thx for your trouble, but i got the 'Always Copy' option wrong!

Greetings,

Steven

|||

Hi Jens,

Your answer was the correct one.

Thx,

Steven

ADDING WITH COUNTING

Below is my query so far. There is a field in Winpayment call
transaction_amount that I would like to add up for use count statement if
possible. So what I am asking is there a way to for each count case add the
transaction amount and have a transaction total show for each count case
statement. For example, every exsistence in the first count statement would
be added up by using the transaction_amount and then have a field right afte
r
SHEETZ_MC_TAPPED_INSIDE say transactions total? Thanks for any help.
Use Winpayment
GO
SELECT S.card_acceptor_identification STORE,
COUNT(M.card_acceptor_identification) TOTAL,
COUNT(CASE WHEN id_code_1 = 'MC' and terminal_num = '001' and pos_entry_mode
= '921' THEN 1 END) SHEETZ_MC_TAPPED_INSIDE,
COUNT(CASE WHEN id_code_1 = 'MC' and terminal_num = '001' and pos_entry_mode
= '021' THEN 1 END) SHEETZ_MC_SWIPED_INSIDE,
COUNT(CASE WHEN id_code_1 = 'MC' and terminal_num = '003' and pos_entry_mode
= '921' THEN 1 END) SHEETZ_MC_TAPPED_OUTSIDE,
COUNT(CASE WHEN id_code_1 = 'MC' and terminal_num = '003' and pos_entry_mode
= '021' THEN 1 END) SHEETZ_MC_SWIPED_OUTSIDE
FROM Store S
Left Join financial_message M
On M.card_acceptor_identification = S.card_acceptor_identification
And settlement_batch_number = '961'
AND id_number_1 like '540168%'
Where len (S.card_acceptor_identification) = 4
GROUP BY S.card_acceptor_identificationI'm not following what you are trying to do. In addition to your query,
could you post the DDL and a few rows of sample data and something showing
your expected result?
--Brian
(Please reply to the newsgroups only.)
"tarheels4025" <tarheels4025@.discussions.microsoft.com> wrote in message
news:8C71D6DF-414C-4B77-95CD-2934AB2CA45D@.microsoft.com...
> Below is my query so far. There is a field in Winpayment call
> transaction_amount that I would like to add up for use count statement if
> possible. So what I am asking is there a way to for each count case add
> the
> transaction amount and have a transaction total show for each count case
> statement. For example, every exsistence in the first count statement
> would
> be added up by using the transaction_amount and then have a field right
> after
> SHEETZ_MC_TAPPED_INSIDE say transactions total? Thanks for any help.
>
> Use Winpayment
> GO
> SELECT S.card_acceptor_identification STORE,
> COUNT(M.card_acceptor_identification) TOTAL,
> COUNT(CASE WHEN id_code_1 = 'MC' and terminal_num = '001' and
> pos_entry_mode
> = '921' THEN 1 END) SHEETZ_MC_TAPPED_INSIDE,
> COUNT(CASE WHEN id_code_1 = 'MC' and terminal_num = '001' and
> pos_entry_mode
> = '021' THEN 1 END) SHEETZ_MC_SWIPED_INSIDE,
> COUNT(CASE WHEN id_code_1 = 'MC' and terminal_num = '003' and
> pos_entry_mode
> = '921' THEN 1 END) SHEETZ_MC_TAPPED_OUTSIDE,
> COUNT(CASE WHEN id_code_1 = 'MC' and terminal_num = '003' and
> pos_entry_mode
> = '021' THEN 1 END) SHEETZ_MC_SWIPED_OUTSIDE
> FROM Store S
> Left Join financial_message M
> On M.card_acceptor_identification = S.card_acceptor_identification
> And settlement_batch_number = '961'
> AND id_number_1 like '540168%'
> Where len (S.card_acceptor_identification) = 4
> GROUP BY S.card_acceptor_identification

adding windows user via sp_cmdshell

assuming SQL server nt service is started under domain user with right to cr
eate windows user in domain, is there a way to execute sp_ in QA that allow
mw to create domain user, set password and add user to group in domain? if s
o can anyone provide this s
tatment.
Tom,Hi,
Yes. See the OS commands NET USER and NET GROUP in OS Help. You can use this
command from Query Anayzer using XP_CMDSHELL.
Sample
Master..XP_cmdshell 'net user Fin_user password /DOMAIN /ADD'
go
Master..XP_cmdshell 'net group Finance /DOMAIN /ADD'
go
For more details of command execute the below from command prompt
net user ?
net group ?
Thanks
Hari
MCDBA
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:E8D38151-CF4C-4EF9-A713-617E25BA2AEE@.microsoft.com...
> assuming SQL server nt service is started under domain user with right to
create windows user in domain, is there a way to execute sp_ in QA that
allow mw to create domain user, set password and add user to group in
domain? if so can anyone provide this statment.
> Tom,|||Hello Hari,
I have tried it, but it did not work for me, I got:
The request will be processedat DC ...
System error 5 has occurred
Access denied.
I got this regardless if I'm using SA account to open Query Analizer or wind
ows auth... where am member of domain admin. any idea...
"Hari Prasad" wrote:

> Hi,
> Yes. See the OS commands NET USER and NET GROUP in OS Help. You can use th
is
> command from Query Anayzer using XP_CMDSHELL.
> Sample
>
> Master..XP_cmdshell 'net user Fin_user password /DOMAIN /ADD'
> go
> Master..XP_cmdshell 'net group Finance /DOMAIN /ADD'
> go
>
> For more details of command execute the below from command prompt
> net user ?
> net group ?
> Thanks
> Hari
> MCDBA
>
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:E8D38151-CF4C-4EF9-A713-617E25BA2AEE@.microsoft.com...
> create windows user in domain, is there a way to execute sp_ in QA that
> allow mw to create domain user, set password and add user to group in
> domain? if so can anyone provide this statment.
>
>|||Hi Tom
As Hari said it is possible, but difficult. The problem
here is its taking the userid of SQL Server instance that
the runs the xp_cmdshell and attempting to create users.
If that userid doesn't have the Server (not SQL)
permission to do its going to crash and burn.

>--Original Message--
>Hello Hari,
>I have tried it, but it did not work for me, I got:
>The request will be processedat DC ...
>System error 5 has occurred
>Access denied.
>I got this regardless if I'm using SA account to open
Query Analizer or windows auth... where am member of
domain admin. any idea...
>"Hari Prasad" wrote:
>
Help. You can use this[vbcol=seagreen]
password /DOMAIN /ADD'[vbcol=seagreen]
command prompt[vbcol=seagreen]
message[vbcol=seagreen]
617E25BA2AEE@.microsoft.com...[vbcol=seagreen]
domain user with right to[vbcol=seagreen]
execute sp_ in QA that[vbcol=seagreen]
user to group in[vbcol=seagreen]
>.
>|||Hi,
I agree with you peter. To do this you might need to start the MSSQL server
service using
a Domain Administrator account. I will not suggest you this.
I will not recommend you to create users / Groups from Query Analyzer.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2dc001c470c1$74fea120$a301280a@.phx.gbl...[vbcol=seagreen]
> Hi Tom
> As Hari said it is possible, but difficult. The problem
> here is its taking the userid of SQL Server instance that
> the runs the xp_cmdshell and attempting to create users.
> If that userid doesn't have the Server (not SQL)
> permission to do its going to crash and burn.
>
> Query Analizer or windows auth... where am member of
> domain admin. any idea...
> Help. You can use this
> password /DOMAIN /ADD'
> command prompt
> message
> 617E25BA2AEE@.microsoft.com...
> domain user with right to
> execute sp_ in QA that
> user to group in|||Agreed.

>--Original Message--
>Hi,
>I agree with you peter. To do this you might need to
start the MSSQL server
>service using
>a Domain Administrator account. I will not suggest you
this.
>I will not recommend you to create users / Groups from
Query Analyzer.
>Thanks
>Hari
>MCDBA
>
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2dc001c470c1$74fea120$a301280a@.phx.gbl...
that[vbcol=seagreen]
>
>.
>sql

Adding Win 2000 account to SQL Server database role

According to SQL Server 2000 Books online:
"When you add a Windows NT 4.0 or Windows 2000 login without a user account
in the database to a SQL Server database role, SQL Server creates a user
account in the database automatically, even if that Windows NT 4.0 or Window
s
2000 login cannot otherwise access the database".
My Questions: How can you add a login to a role without a user account (with
that login) in the database? So, I don't understand the above comments. I wa
s
unable to create the above example since I had to create a win 2000 login as
a user in the database first before adding that login to a role. Can someone
please explain the above comments?
Thanks,
KevMaybe you were trying it just through Enterprise Manager?
You need to use the system stored procedure to do this. Try
the following:
Create a new user on the machine.
In Query Analyzer, execute the following:
use northwind
go
sp_addrolemember 'db_datareader', 'YourMachine\YourUser'
The windows account will show up a user in the database with
access via group membership. You don't have to first add the
login or add the user to the database.
-Sue
On Wed, 21 Sep 2005 08:06:04 -0700, Nam
<Nam@.discussions.microsoft.com> wrote:

>According to SQL Server 2000 Books online:
>"When you add a Windows NT 4.0 or Windows 2000 login without a user account
>in the database to a SQL Server database role, SQL Server creates a user
>account in the database automatically, even if that Windows NT 4.0 or Windo
ws
>2000 login cannot otherwise access the database".
>My Questions: How can you add a login to a role without a user account (wit
h
>that login) in the database? So, I don't understand the above comments. I w
as
>unable to create the above example since I had to create a win 2000 login a
s
>a user in the database first before adding that login to a role. Can someon
e
>please explain the above comments?
>Thanks,
>Kev

Adding Weekend data to Monday

We have a data extract prcess that runs daily. In SQL Script, there is a
variable that equals to 1 (meaning 1 day worth of data). We run this monday
through friday at 9:00 PM. Now the client wants, if there is any processing
on the weekend (Saturday/Sunday) it should be added to the monday's data.
This is an automated process and we need to keep it like that. The question
is, how can I modify the script so that it picks up the daily data Tuesday
through friday and 3 days of data (Saturday, Sunday and Monday) on mondays ?
Thanks for any help.Do you want a sum or the rows on their own, only presenting those on the
weekdays ?
You have to specify your expected results a bit.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B12A81D8-BFC1-44B4-8842-AC895B2E30F0@.microsoft.com...
> We have a data extract prcess that runs daily. In SQL Script, there is a
> variable that equals to 1 (meaning 1 day worth of data). We run this
> monday
> through friday at 9:00 PM. Now the client wants, if there is any
> processing
> on the weekend (Saturday/Sunday) it should be added to the monday's data.
> This is an automated process and we need to keep it like that. The
> question
> is, how can I modify the script so that it picks up the daily data Tuesday
> through friday and 3 days of data (Saturday, Sunday and Monday) on mondays
> ?
> Thanks for any help.|||Data is selected according to what is in 'datetime' columns and not as sum.
"Jens Sü�meyer" wrote:
> Do you want a sum or the rows on their own, only presenting those on the
> weekdays ?
> You have to specify your expected results a bit.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:B12A81D8-BFC1-44B4-8842-AC895B2E30F0@.microsoft.com...
> > We have a data extract prcess that runs daily. In SQL Script, there is a
> > variable that equals to 1 (meaning 1 day worth of data). We run this
> > monday
> > through friday at 9:00 PM. Now the client wants, if there is any
> > processing
> > on the weekend (Saturday/Sunday) it should be added to the monday's data.
> >
> > This is an automated process and we need to keep it like that. The
> > question
> > is, how can I modify the script so that it picks up the daily data Tuesday
> > through friday and 3 days of data (Saturday, Sunday and Monday) on mondays
> > ?
> >
> > Thanks for any help.
>
>|||Sure that you got your results in mind you want to have, we don´t.
Do you want to get something like
Tu-1,we-1,th-1.fr-1,m-4
...if there is data for every day.
Or do you want to build a sum of some value for thse days ?
The best things would be to provide us with some DDL and sample data.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
news:28A41391-7E40-4550-88D0-EC1A32AB35CF@.microsoft.com...
> Data is selected according to what is in 'datetime' columns and not as
> sum.
>
> "Jens Süßmeyer" wrote:
>> Do you want a sum or the rows on their own, only presenting those on the
>> weekdays ?
>> You have to specify your expected results a bit.
>> --
>> HTH, Jens Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>> "DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:B12A81D8-BFC1-44B4-8842-AC895B2E30F0@.microsoft.com...
>> > We have a data extract prcess that runs daily. In SQL Script, there is
>> > a
>> > variable that equals to 1 (meaning 1 day worth of data). We run this
>> > monday
>> > through friday at 9:00 PM. Now the client wants, if there is any
>> > processing
>> > on the weekend (Saturday/Sunday) it should be added to the monday's
>> > data.
>> >
>> > This is an automated process and we need to keep it like that. The
>> > question
>> > is, how can I modify the script so that it picks up the daily data
>> > Tuesday
>> > through friday and 3 days of data (Saturday, Sunday and Monday) on
>> > mondays
>> > ?
>> >
>> > Thanks for any help.
>>

Adding Weekend data to Monday

We have a data extract prcess that runs daily. In SQL Script, there is a
variable that equals to 1 (meaning 1 day worth of data). We run this monday
through friday at 9:00 PM. Now the client wants, if there is any processing
on the weekend (Saturday/Sunday) it should be added to the monday's data.
This is an automated process and we need to keep it like that. The question
is, how can I modify the script so that it picks up the daily data Tuesday
through friday and 3 days of data (Saturday, Sunday and Monday) on mondays ?
Thanks for any help.
Do you want a sum or the rows on their own, only presenting those on the
weekdays ?
You have to specify your expected results a bit.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B12A81D8-BFC1-44B4-8842-AC895B2E30F0@.microsoft.com...
> We have a data extract prcess that runs daily. In SQL Script, there is a
> variable that equals to 1 (meaning 1 day worth of data). We run this
> monday
> through friday at 9:00 PM. Now the client wants, if there is any
> processing
> on the weekend (Saturday/Sunday) it should be added to the monday's data.
> This is an automated process and we need to keep it like that. The
> question
> is, how can I modify the script so that it picks up the daily data Tuesday
> through friday and 3 days of data (Saturday, Sunday and Monday) on mondays
> ?
> Thanks for any help.
|||Data is selected according to what is in 'datetime' columns and not as sum.
"Jens Sü?meyer" wrote:

> Do you want a sum or the rows on their own, only presenting those on the
> weekdays ?
> You have to specify your expected results a bit.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:B12A81D8-BFC1-44B4-8842-AC895B2E30F0@.microsoft.com...
>
>
|||Sure that you got your results in mind you want to have, we dont.
Do you want to get something like
Tu-1,we-1,th-1.fr-1,m-4
...if there is data for every day.
Or do you want to build a sum of some value for thse days ?
The best things would be to provide us with some DDL and sample data.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
news:28A41391-7E40-4550-88D0-EC1A32AB35CF@.microsoft.com...[vbcol=seagreen]
> Data is selected according to what is in 'datetime' columns and not as
> sum.
>
> "Jens Smeyer" wrote:

Adding Weekend data to Monday

We have a data extract prcess that runs daily. In SQL Script, there is a
variable that equals to 1 (meaning 1 day worth of data). We run this monday
through friday at 9:00 PM. Now the client wants, if there is any processing
on the weekend (Saturday/Sunday) it should be added to the monday's data.
This is an automated process and we need to keep it like that. The question
is, how can I modify the script so that it picks up the daily data Tuesday
through friday and 3 days of data (Saturday, Sunday and Monday) on mondays ?
Thanks for any help.Do you want a sum or the rows on their own, only presenting those on the
weekdays ?
You have to specify your expected results a bit.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B12A81D8-BFC1-44B4-8842-AC895B2E30F0@.microsoft.com...
> We have a data extract prcess that runs daily. In SQL Script, there is a
> variable that equals to 1 (meaning 1 day worth of data). We run this
> monday
> through friday at 9:00 PM. Now the client wants, if there is any
> processing
> on the weekend (Saturday/Sunday) it should be added to the monday's data.
> This is an automated process and we need to keep it like that. The
> question
> is, how can I modify the script so that it picks up the daily data Tuesday
> through friday and 3 days of data (Saturday, Sunday and Monday) on mondays
> ?
> Thanks for any help.|||Data is selected according to what is in 'datetime' columns and not as sum.
"Jens Sü?meyer" wrote:

> Do you want a sum or the rows on their own, only presenting those on the
> weekdays ?
> You have to specify your expected results a bit.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:B12A81D8-BFC1-44B4-8842-AC895B2E30F0@.microsoft.com...
>
>|||Sure that you got your results in mind you want to have, we dont.
Do you want to get something like
Tu-1,we-1,th-1.fr-1,m-4
...if there is data for every day.
Or do you want to build a sum of some value for thse days ?
The best things would be to provide us with some DDL and sample data.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"DXC" <DXC@.discussions.microsoft.com> schrieb im Newsbeitrag
news:28A41391-7E40-4550-88D0-EC1A32AB35CF@.microsoft.com...[vbcol=seagreen]
> Data is selected according to what is in 'datetime' columns and not as
> sum.
>
> "Jens Smeyer" wrote:
>

Adding visibility toggle to a table group

Hi!
I'm trying to add a visibility toggle to a table group in my report. The
table has one main group and a subgroup. I want to hide initially details
from the subgroup. So I changed the visibility property of this subgroup to
"Hidden" and then choosed that visibility can be toggled by another report
item (which is in my case a textbox containing the name of a subgroup in the
subgroup header). When I generated this report in Excel-format I got 2 spread
sheets: a Document map containing links with the names o my subgroups and a
report without '+/-' toggle boxes. Is it something I'm doing wrong?I didn't see anything wrong. Can you reproduce this issue by creating a new
report which uses the sample database Adventureworks2000 as its data
source? If you can repro, please post the exact steps and then we'll be
able to investigate this issue further.
Also, if you export the sample report "Territory Sales Drilldown" to an
Excel file, do you still have this issue?
What service pack level is your RS at?
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Adding visibility toggle to a table group
>thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==>X-WBNR-Posting-Host: 62.97.217.178
>From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>Subject: Adding visibility toggle to a table group
>Date: Mon, 9 May 2005 06:33:01 -0700
>Lines: 10
>Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43164
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi!
>I'm trying to add a visibility toggle to a table group in my report. The
>table has one main group and a subgroup. I want to hide initially details
>from the subgroup. So I changed the visibility property of this subgroup
to
>"Hidden" and then choosed that visibility can be toggled by another report
>item (which is in my case a textbox containing the name of a subgroup in
the
>subgroup header). When I generated this report in Excel-format I got 2
spread
>sheets: a Document map containing links with the names o my subgroups and
a
>report without '+/-' toggle boxes. Is it something I'm doing wrong?
>|||Thank you for your answer.
I compared my report with "Territory Sales Drilldown", it uses query string
as datasource and performs grouping there, while I'm using a stored
procedure. Territory sales drilldown report works fine. Does it mean that for
getting this toggle-functionality I have to use query string?
I'm using Service Pack 2 in my reporting services.
Regards,
Anna
"William Wang[MSFT]" wrote:
> I didn't see anything wrong. Can you reproduce this issue by creating a new
> report which uses the sample database Adventureworks2000 as its data
> source? If you can repro, please post the exact steps and then we'll be
> able to investigate this issue further.
> Also, if you export the sample report "Territory Sales Drilldown" to an
> Excel file, do you still have this issue?
> What service pack level is your RS at?
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> >Thread-Topic: Adding visibility toggle to a table group
> >thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==> >X-WBNR-Posting-Host: 62.97.217.178
> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
> >Subject: Adding visibility toggle to a table group
> >Date: Mon, 9 May 2005 06:33:01 -0700
> >Lines: 10
> >Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43164
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Hi!
> >I'm trying to add a visibility toggle to a table group in my report. The
> >table has one main group and a subgroup. I want to hide initially details
> >from the subgroup. So I changed the visibility property of this subgroup
> to
> >"Hidden" and then choosed that visibility can be toggled by another report
> >item (which is in my case a textbox containing the name of a subgroup in
> the
> >subgroup header). When I generated this report in Excel-format I got 2
> spread
> >sheets: a Document map containing links with the names o my subgroups and
> a
> >report without '+/-' toggle boxes. Is it something I'm doing wrong?
> >
> >
>|||Hi Anna,
I don't think you have to use a query string as the dataset. In the sample
db Adventureworks2000, I created a stored procedure and use it as the
dataset for the "Territory Sales Drilldown" report, deployed it and then
exported the report to an Excel file, the report still worked fine.
Therefore I believe this issue is specific to your report. Can you managed
to create another report using Adventureworks2000 as its data source and
reproduce this issue? You can then send the report to me so that I will
able to test this issue on my end and see find out what has been wrong. My
e-mail address is v-rxwang@.microsoft.com.
Sincerely,
William Wang
Microsoft Online Partner Support
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Adding visibility toggle to a table group
>thread-index: AcVVb0YGcz2tQamgShu62D42ca+yyA==>X-WBNR-Posting-Host: 62.97.217.178
>From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>References: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
<9rqBBERVFHA.3052@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Adding visibility toggle to a table group
>Date: Tue, 10 May 2005 07:48:05 -0700
>Lines: 77
>Message-ID: <0E31FF65-52E9-43D8-B395-EF13AE6A77C8@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43296
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Thank you for your answer.
>I compared my report with "Territory Sales Drilldown", it uses query
string
>as datasource and performs grouping there, while I'm using a stored
>procedure. Territory sales drilldown report works fine. Does it mean that
for
>getting this toggle-functionality I have to use query string?
>I'm using Service Pack 2 in my reporting services.
>Regards,
>Anna
>
>"William Wang[MSFT]" wrote:
>> I didn't see anything wrong. Can you reproduce this issue by creating a
new
>> report which uses the sample database Adventureworks2000 as its data
>> source? If you can repro, please post the exact steps and then we'll be
>> able to investigate this issue further.
>> Also, if you export the sample report "Territory Sales Drilldown" to an
>> Excel file, do you still have this issue?
>> What service pack level is your RS at?
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> This posting is provided "AS IS" with no warranties, and confers no
rights.
>> --
>> >Thread-Topic: Adding visibility toggle to a table group
>> >thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==>> >X-WBNR-Posting-Host: 62.97.217.178
>> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>> >Subject: Adding visibility toggle to a table group
>> >Date: Mon, 9 May 2005 06:33:01 -0700
>> >Lines: 10
>> >Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> > charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:43164
>> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >
>> >Hi!
>> >I'm trying to add a visibility toggle to a table group in my report.
The
>> >table has one main group and a subgroup. I want to hide initially
details
>> >from the subgroup. So I changed the visibility property of this
subgroup
>> to
>> >"Hidden" and then choosed that visibility can be toggled by another
report
>> >item (which is in my case a textbox containing the name of a subgroup
in
>> the
>> >subgroup header). When I generated this report in Excel-format I got 2
>> spread
>> >sheets: a Document map containing links with the names o my subgroups
and
>> a
>> >report without '+/-' toggle boxes. Is it something I'm doing wrong?
>> >
>> >
>>
>|||Hei William!
I've also created a stored procedure in db Adventureworks2000 and then
created a report based on that. It works fine when I run it in preview, but
not when I exporting it to Excel. I send you the project to your mail
address, so you can see what I'm doing wtrong.
"William Wang[MSFT]" wrote:
> Hi Anna,
> I don't think you have to use a query string as the dataset. In the sample
> db Adventureworks2000, I created a stored procedure and use it as the
> dataset for the "Territory Sales Drilldown" report, deployed it and then
> exported the report to an Excel file, the report still worked fine.
> Therefore I believe this issue is specific to your report. Can you managed
> to create another report using Adventureworks2000 as its data source and
> reproduce this issue? You can then send the report to me so that I will
> able to test this issue on my end and see find out what has been wrong. My
> e-mail address is v-rxwang@.microsoft.com.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> >Thread-Topic: Adding visibility toggle to a table group
> >thread-index: AcVVb0YGcz2tQamgShu62D42ca+yyA==> >X-WBNR-Posting-Host: 62.97.217.178
> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
> >References: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
> <9rqBBERVFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> >Subject: RE: Adding visibility toggle to a table group
> >Date: Tue, 10 May 2005 07:48:05 -0700
> >Lines: 77
> >Message-ID: <0E31FF65-52E9-43D8-B395-EF13AE6A77C8@.microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43296
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Thank you for your answer.
> >
> >I compared my report with "Territory Sales Drilldown", it uses query
> string
> >as datasource and performs grouping there, while I'm using a stored
> >procedure. Territory sales drilldown report works fine. Does it mean that
> for
> >getting this toggle-functionality I have to use query string?
> >
> >I'm using Service Pack 2 in my reporting services.
> >
> >Regards,
> >
> >Anna
> >
> >
> >"William Wang[MSFT]" wrote:
> >
> >> I didn't see anything wrong. Can you reproduce this issue by creating a
> new
> >> report which uses the sample database Adventureworks2000 as its data
> >> source? If you can repro, please post the exact steps and then we'll be
> >> able to investigate this issue further.
> >>
> >> Also, if you export the sample report "Territory Sales Drilldown" to an
> >> Excel file, do you still have this issue?
> >>
> >> What service pack level is your RS at?
> >>
> >> Sincerely,
> >>
> >> William Wang
> >> Microsoft Online Partner Support
> >>
> >> When responding to posts, please "Reply to Group" via your newsreader so
> >> that others may learn and benefit from your issue.
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >>
> >> --
> >> >Thread-Topic: Adding visibility toggle to a table group
> >> >thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==> >> >X-WBNR-Posting-Host: 62.97.217.178
> >> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
> >> >Subject: Adding visibility toggle to a table group
> >> >Date: Mon, 9 May 2005 06:33:01 -0700
> >> >Lines: 10
> >> >Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
> >> >MIME-Version: 1.0
> >> >Content-Type: text/plain;
> >> > charset="Utf-8"
> >> >Content-Transfer-Encoding: 7bit
> >> >X-Newsreader: Microsoft CDO for Windows 2000
> >> >Content-Class: urn:content-classes:message
> >> >Importance: normal
> >> >Priority: normal
> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >> >Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:43164
> >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >> >
> >> >Hi!
> >> >I'm trying to add a visibility toggle to a table group in my report.
> The
> >> >table has one main group and a subgroup. I want to hide initially
> details
> >> >from the subgroup. So I changed the visibility property of this
> subgroup
> >> to
> >> >"Hidden" and then choosed that visibility can be toggled by another
> report
> >> >item (which is in my case a textbox containing the name of a subgroup
> in
> >> the
> >> >subgroup header). When I generated this report in Excel-format I got 2
> >> spread
> >> >sheets: a Document map containing links with the names o my subgroups
> and
> >> a
> >> >report without '+/-' toggle boxes. Is it something I'm doing wrong?
> >> >
> >> >
> >>
> >>
> >
>|||Hi Anna,
From your report, I see that you have correctly set the Visibility
properties (Hidden and ToggleItem) of the Sales_SalesPerson Header and the
Detail row. However, for each of the two rows, click its row handler, and
then click Edit Group. On the Visibility tab, there are incorrect settings.
You just want to choose the Visible option under "Initial visibility" and
clear the "Visibility can be toggled by another report item" check box.
After that, save the report to an Excel file. This time the Excel file
should be fine.
Feel free to let me know if anything is unclear.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Adding visibility toggle to a table group
>thread-index: AcVWBmyJjdj51eYgT8OKveDvIzn2oA==>X-WBNR-Posting-Host: 62.97.217.178
>From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>References: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
<9rqBBERVFHA.3052@.TK2MSFTNGXA01.phx.gbl>
<0E31FF65-52E9-43D8-B395-EF13AE6A77C8@.microsoft.com>
<4dmYVsdVFHA.3928@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Adding visibility toggle to a table group
>Date: Wed, 11 May 2005 01:50:04 -0700
>Lines: 144
>Message-ID: <F4A9DDEC-E0FB-4FAB-8C2C-13AC07DEFAD1@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43397
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hei William!
>I've also created a stored procedure in db Adventureworks2000 and then
>created a report based on that. It works fine when I run it in preview,
but
>not when I exporting it to Excel. I send you the project to your mail
>address, so you can see what I'm doing wtrong.
>"William Wang[MSFT]" wrote:
>> Hi Anna,
>> I don't think you have to use a query string as the dataset. In the
sample
>> db Adventureworks2000, I created a stored procedure and use it as the
>> dataset for the "Territory Sales Drilldown" report, deployed it and then
>> exported the report to an Excel file, the report still worked fine.
>> Therefore I believe this issue is specific to your report. Can you
managed
>> to create another report using Adventureworks2000 as its data source and
>> reproduce this issue? You can then send the report to me so that I will
>> able to test this issue on my end and see find out what has been wrong.
My
>> e-mail address is v-rxwang@.microsoft.com.
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> This posting is provided "AS IS" with no warranties, and confers no
rights.
>> --
>> >Thread-Topic: Adding visibility toggle to a table group
>> >thread-index: AcVVb0YGcz2tQamgShu62D42ca+yyA==>> >X-WBNR-Posting-Host: 62.97.217.178
>> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>> >References: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
>> <9rqBBERVFHA.3052@.TK2MSFTNGXA01.phx.gbl>
>> >Subject: RE: Adding visibility toggle to a table group
>> >Date: Tue, 10 May 2005 07:48:05 -0700
>> >Lines: 77
>> >Message-ID: <0E31FF65-52E9-43D8-B395-EF13AE6A77C8@.microsoft.com>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> > charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:43296
>> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >
>> >Thank you for your answer.
>> >
>> >I compared my report with "Territory Sales Drilldown", it uses query
>> string
>> >as datasource and performs grouping there, while I'm using a stored
>> >procedure. Territory sales drilldown report works fine. Does it mean
that
>> for
>> >getting this toggle-functionality I have to use query string?
>> >
>> >I'm using Service Pack 2 in my reporting services.
>> >
>> >Regards,
>> >
>> >Anna
>> >
>> >
>> >"William Wang[MSFT]" wrote:
>> >
>> >> I didn't see anything wrong. Can you reproduce this issue by creating
a
>> new
>> >> report which uses the sample database Adventureworks2000 as its data
>> >> source? If you can repro, please post the exact steps and then we'll
be
>> >> able to investigate this issue further.
>> >>
>> >> Also, if you export the sample report "Territory Sales Drilldown" to
an
>> >> Excel file, do you still have this issue?
>> >>
>> >> What service pack level is your RS at?
>> >>
>> >> Sincerely,
>> >>
>> >> William Wang
>> >> Microsoft Online Partner Support
>> >>
>> >> When responding to posts, please "Reply to Group" via your newsreader
so
>> >> that others may learn and benefit from your issue.
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >>
>> >> --
>> >> >Thread-Topic: Adding visibility toggle to a table group
>> >> >thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==>> >> >X-WBNR-Posting-Host: 62.97.217.178
>> >> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>> >> >Subject: Adding visibility toggle to a table group
>> >> >Date: Mon, 9 May 2005 06:33:01 -0700
>> >> >Lines: 10
>> >> >Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
>> >> >MIME-Version: 1.0
>> >> >Content-Type: text/plain;
>> >> > charset="Utf-8"
>> >> >Content-Transfer-Encoding: 7bit
>> >> >X-Newsreader: Microsoft CDO for Windows 2000
>> >> >Content-Class: urn:content-classes:message
>> >> >Importance: normal
>> >> >Priority: normal
>> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >> >Xref: TK2MSFTNGXA01.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:43164
>> >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >> >
>> >> >Hi!
>> >> >I'm trying to add a visibility toggle to a table group in my report.
>> The
>> >> >table has one main group and a subgroup. I want to hide initially
>> details
>> >> >from the subgroup. So I changed the visibility property of this
>> subgroup
>> >> to
>> >> >"Hidden" and then choosed that visibility can be toggled by another
>> report
>> >> >item (which is in my case a textbox containing the name of a
subgroup
>> in
>> >> the
>> >> >subgroup header). When I generated this report in Excel-format I got
2
>> >> spread
>> >> >sheets: a Document map containing links with the names o my
subgroups
>> and
>> >> a
>> >> >report without '+/-' toggle boxes. Is it something I'm doing wrong?
>> >> >
>> >> >
>> >>
>> >>
>> >
>>
>sql

Adding Viewer Controls to WinForms or Web project

With the release of the feature pack for SQL 2005 and the included Datamining Viewer Controls I was wondering three things. 1) How do you add these controls to your toolbox and 2) Are these controls installed with VS 2005 or SQL 2005 and these are just the redistributable versions for systems where VS 2005 and SQL 2005 are not installed? 3) Is there a description of the controls and what each one does?1) How do you add these controls to your toolbox

In the Winform designer, right click on the Toolbox and select 'Choose Items...' menu item. Hit the Brows button and select file 'Microsoft.AnalysisServices.Viewers.dll'. Hit the OK button to add all the viewer controls to your toolbox.

2) Are these controls installed with VS 2005 or SQL 2005 and these are just the redistributable versions for systems where VS 2005 and SQL 2005 are not installed?

The view controls are shipped with SQL 2005 as well as in its separate redistributable available for download.

3) Is there a description of the controls and what each one does?
You can find description of each individual viewer control in SQL Books online.

Adding vertical space between rows

I am trying to create a mailing labels report but can't seem to get any vertical space between the rows. I see a cellpadding setting but nothing equivalent to cellspacing. Can anyone help me out?

Thanks.Try adding a text box, turning off can increase and can decrease in properties, under advanced, choose format, and work with the 'amount of space to leave on each side of report item.
Also try adding characters into the box, and set the color to be the same as background so that it is invisible.

adding VbLf

When using the Xp_sendmail stored procedure from MS SQL 2000, I cannot use LF or CR of both otr VBnewLine in my messages.

For example

<code>
Trim(lblEmployee.Text) & " has requested a holiday. From " & CalendarPopupStartDate.SelectedDate & " till " & CalendarPopupStartDate.SelectedDate _
& "." & CARRIAGE RETURN WANTED &lblRequestedDays.Text & txtComments.Text
<code
where you find the CARRIAGE RETURN WANTED, I want to begin a new line. My email is not formated asked :(

any help?

Greetz,
Geoffyour looking for a CRLF

chr(13) & chr(10)|||yes I know. That is not the problem. The problem is that the xp_sendmail accepts a parameter @.message. this is build up from severall labels on my page. But I do not succeed in entering en CR or LF|||if your creating the message from a web page then use environment.newline to insert the CRLF|||SQL will parse it if you use CHAR(ascii)|||Yes I knwo that... I'll try to explain

When I build up a query I do this like this

Dim blabla as String = "Exec xp_sendmail @.message, @.and some others"
dim comBlaBla as sqlcommand(blabla , sqlconnection1)

----
Now when I fill up the parameter @. message and I use a char(10) or char(13) this is just printed as written in the string. I tried to use other characters that escaped these like \ and so one. Can someone give me an example of how I can add Lf or CR to a string that is passed as a parameter? Hopefully now you guys understand what I'm talking about.

Greets,
Geoff

adding vb and visual C# to Visual Studio 2005 in reporting service

Hi,
Presently visual studio 2005 in SQL server 2005 reporting services has
business intelligence project templates.
I would like to know as to how to add Visual basic and Visual C# project
templates to Visual Studio 2005.
I am new to SQL Server 2005 reporting services.
I would highly appreciate this information.
Thanks for your help.
--
SamKYou have to install those projects. However, after doing this you might have
to re-install report designer. The reason is that SQL Server 2005 comes with
a version of visual studio that it installs if no VS is present. If VS is
present it integrates with it. I have found that if you install VS (for
instance installing VB.Net which installs a full version of Visual Studio)
that you need to re-install the report designer so it integrates with it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SamK" <SamK@.discussions.microsoft.com> wrote in message
news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> Hi,
> Presently visual studio 2005 in SQL server 2005 reporting services has
> business intelligence project templates.
> I would like to know as to how to add Visual basic and Visual C# project
> templates to Visual Studio 2005.
> I am new to SQL Server 2005 reporting services.
> I would highly appreciate this information.
> Thanks for your help.
> --
> SamK|||Bruce,
Thanks for your helpful suggestion. This is what I will do.
1) uninstall the Visual Studio 2005 that got installed along with SQL server
2005 reporting services
2) install the full version of Visual Studio 2005.
3) Reinstall the reporting services.
Is this correct?
Best Regards,
SamK
"Bruce L-C [MVP]" wrote:
> You have to install those projects. However, after doing this you might have
> to re-install report designer. The reason is that SQL Server 2005 comes with
> a version of visual studio that it installs if no VS is present. If VS is
> present it integrates with it. I have found that if you install VS (for
> instance installing VB.Net which installs a full version of Visual Studio)
> that you need to re-install the report designer so it integrates with it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> > Hi,
> >
> > Presently visual studio 2005 in SQL server 2005 reporting services has
> > business intelligence project templates.
> > I would like to know as to how to add Visual basic and Visual C# project
> > templates to Visual Studio 2005.
> >
> > I am new to SQL Server 2005 reporting services.
> >
> > I would highly appreciate this information.
> > Thanks for your help.
> > --
> > SamK
>
>|||Yes. That will do what you want.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SamK" <SamK@.discussions.microsoft.com> wrote in message
news:9BEB930B-CE75-4281-9C0B-A171CCD4D035@.microsoft.com...
> Bruce,
> Thanks for your helpful suggestion. This is what I will do.
> 1) uninstall the Visual Studio 2005 that got installed along with SQL
> server
> 2005 reporting services
> 2) install the full version of Visual Studio 2005.
> 3) Reinstall the reporting services.
> Is this correct?
> Best Regards,
> SamK
>
> "Bruce L-C [MVP]" wrote:
>> You have to install those projects. However, after doing this you might
>> have
>> to re-install report designer. The reason is that SQL Server 2005 comes
>> with
>> a version of visual studio that it installs if no VS is present. If VS is
>> present it integrates with it. I have found that if you install VS (for
>> instance installing VB.Net which installs a full version of Visual
>> Studio)
>> that you need to re-install the report designer so it integrates with it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "SamK" <SamK@.discussions.microsoft.com> wrote in message
>> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
>> > Hi,
>> >
>> > Presently visual studio 2005 in SQL server 2005 reporting services has
>> > business intelligence project templates.
>> > I would like to know as to how to add Visual basic and Visual C#
>> > project
>> > templates to Visual Studio 2005.
>> >
>> > I am new to SQL Server 2005 reporting services.
>> >
>> > I would highly appreciate this information.
>> > Thanks for your help.
>> > --
>> > SamK
>>|||Bruce,
After doing all this two more problems have come up.
1) For web service identity ASPNET is not assigned. the text box is
disabled and it is blank.
2) when I try to open the report manager (http://computername/reports the
application errors out with this message. I would request your help.
Server Error in '/Reports' Application.
----
Could not load file or assembly 'CppCodeProvider, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies.
The module was expected to contain an assembly manifest.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.BadImageFormatException: Could not load file or
assembly 'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The module was
expected to contain an assembly manifest.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine
why the assembly 'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' could not be loaded.
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value
[HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind
failure logging.
To turn this feature off, remove the registry value
[HKLM\Software\Microsoft\Fusion!EnableLog].
Stack Trace:
[BadImageFormatException: Could not load file or assembly 'CppCodeProvider,
Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of
its dependencies. The module was expected to contain an assembly manifest.]
System.RuntimeTypeHandle._GetTypeByName(String name, Boolean
throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark&
stackMark, Boolean loadTypeFromPartialName) +0
System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError,
Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +72
System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError,
Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +58
System.Type.GetType(String typeName) +48
System.CodeDom.Compiler.CompilerInfo.get_IsCodeDomProviderTypeValid() +9
System.Web.Compilation.CompilationUtil.GetRecompilationHash(CompilationSection ps) +1800
System.Web.Configuration.CompilationSection.get_RecompilationHash() +68
System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +741
System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46
System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +419
System.Web.Compilation.BuildManager.Initialize() +235
System.Web.Compilation.BuildManager.InitializeBuildManager() +228
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags)
+310
[HttpException (0x80004005): Could not load file or assembly
'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The module was
expected to contain an assembly manifest.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3435007
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +252
----
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.210
--
SamK
"Bruce L-C [MVP]" wrote:
> Yes. That will do what you want.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> news:9BEB930B-CE75-4281-9C0B-A171CCD4D035@.microsoft.com...
> > Bruce,
> >
> > Thanks for your helpful suggestion. This is what I will do.
> > 1) uninstall the Visual Studio 2005 that got installed along with SQL
> > server
> > 2005 reporting services
> > 2) install the full version of Visual Studio 2005.
> > 3) Reinstall the reporting services.
> >
> > Is this correct?
> >
> > Best Regards,
> > SamK
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You have to install those projects. However, after doing this you might
> >> have
> >> to re-install report designer. The reason is that SQL Server 2005 comes
> >> with
> >> a version of visual studio that it installs if no VS is present. If VS is
> >> present it integrates with it. I have found that if you install VS (for
> >> instance installing VB.Net which installs a full version of Visual
> >> Studio)
> >> that you need to re-install the report designer so it integrates with it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> >> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> >> > Hi,
> >> >
> >> > Presently visual studio 2005 in SQL server 2005 reporting services has
> >> > business intelligence project templates.
> >> > I would like to know as to how to add Visual basic and Visual C#
> >> > project
> >> > templates to Visual Studio 2005.
> >> >
> >> > I am new to SQL Server 2005 reporting services.
> >> >
> >> > I would highly appreciate this information.
> >> > Thanks for your help.
> >> > --
> >> > SamK
> >>
> >>
> >>
>
>

adding various fonts/weights to values in a string

HI
I am creating a form that needs to have strings of text in the text box.
The strings have numbers included and the numbers need to be a different
font. The form is built in a table, so splitting the row will not work.
Example:
Textbox 10 has the following value:
8. Fax Number
The number 8 needs to be arial narrow bold 6.96 and the fax number needs to
be arrial narrow 6.96
Any help would be appreciated.
Thank youHi Susan,
One of the ways to do what you need is to place a rectangle object right in
the textbox of the table. Then place two (or more) individual textboxed
inside of the rectangle that is inside of the table cell. You can set the
font weights on the individual textboxes at that point so:
"8" will be in its own textbox and the Fax Number data field in the other,
but they can be together within a single cell. This might add a little more
work, but it should solve the problem.
Rodney Landrum
"Susan R" <SusanR@.discussions.microsoft.com> wrote in message
news:B55B1631-A886-45A0-AFA5-5533CB87C0BE@.microsoft.com...
> HI
> I am creating a form that needs to have strings of text in the text box.
> The strings have numbers included and the numbers need to be a different
> font. The form is built in a table, so splitting the row will not work.
> Example:
> Textbox 10 has the following value:
> 8. Fax Number
> The number 8 needs to be arial narrow bold 6.96 and the fax number needs
> to
> be arrial narrow 6.96
> Any help would be appreciated.
> Thank you
>sql