How can I remove "include report" option from the email subscripti

I don't want users to have the "include report" option when setting up an
email subscription. Is it possible? I want users to only be able to get a
link to the report to avoid attachments in the inbox.
I was expecting to be able to set it in RSReportServer.config file, but I
didn't find an option.The email delivery extension does not support this scenario. You could look
into writing your own delivery extension. Since all you want to do is email
a link it would be fairly simple to write, the hardest part would be the UI.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"JulioLe" <JulioLe@.discussions.microsoft.com> wrote in message
news:7E95C301-6D46-47E6-8E6C-CEDEC9A57CEA@.microsoft.com...
>I don't want users to have the "include report" option when setting up an
> email subscription. Is it possible? I want users to only be able to get a
> link to the report to avoid attachments in the inbox.
> I was expecting to be able to set it in RSReportServer.config file, but I
> didn't find an option.
>

How can I include two expressions in one textbox?

Here are the expresstions:
=(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
Fields!Transfer.Value + Fields!Spent.Value)
=iif(fields!Purchase.Value=0, "black", "red")
Thanks,
TrintIt appears that your expressions are doing two different things. I will
infer from this that you want the first expression to yield the value, and
the second to yield the font color.
Therefore, you would set the "Value" property to the first expression. Then
under the font settings, set the font color equal to the second expression.
Brian
"trint" <trinity.smith@.gmail.com> wrote in message
news:1122298713.103364.68910@.g14g2000cwa.googlegroups.com...
> Here are the expresstions:
> =(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
> Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
> Fields!Transfer.Value + Fields!Spent.Value)
> =iif(fields!Purchase.Value=0, "black", "red")
> Thanks,
> Trint
>|||But, how do I add a second expression?
=(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
Fields!Transfer.Value + Fields!Spent.Value) +
=iif(fields!Purchase.Value=0, "black", "red") ?
I know that doesn't work, but that is what I mean.
Thanks,
Trint|||Write this in Purchase Textbox -> Rightclick -> Expression
=(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
Fields!Transfer.Value + Fields!Spent.Value)
go to Purchase Properties, click on FontColor -> Choose Expression and write
the foll.
=iif(fields!Purchase.Value=0, "black", "red")
Hope it helps.
Girija
"trint" wrote:
> But, how do I add a second expression?
> =(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
> Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
> Fields!Transfer.Value + Fields!Spent.Value) +
> =iif(fields!Purchase.Value=0, "black", "red") ?
> I know that doesn't work, but that is what I mean.
> Thanks,
> Trint
>

how can I include Full Text Search service in my program setup silently?

heloo..

if I want to use full text search in my program, can I include Full Text Search service in my program setup silently in the same way as including SQL Express and .Net Framework to the setup project, Or I have to Install MS Sql Server 2005 on my customer computer?

Full text search is included with the SQL Server Express Advanced edition (but not SQL Server Express). You can add "ADDLOCAL=SQL_FullText " to your addlocal parameter during silent install or use "ADDLOCAL=All" to get everything.

Here's a link showing what Express and Express Advanced include:

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

Thanks,
Sam Lester (MSFT)

how can i include a timestamp on a file name in a stored procedure??

ok...i give up....

can this be done? (sql server 2000)

all i want to do is have my stored procedure output some data to a file and i want the filename to include a time stamp.

here's my current working file output code:

EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout "c:\employees.txt" -c -Usa -P'

i'd like it to be something like this:

EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout "c:\employees" + datetime + ".txt" -c -Usa -P'

but nothing seems to work.

use:

GETDATE() or GETUTCDATE()

|||

You might also want to convert to string..

EXEC .... + CONVERT(Varchar, getdate()) + ...

|||

Bah, I always forget the little things :P

3 cheers for error checking!

|||

RTernier:

Bah, I always forget the little things :P

3 cheers for error checking!

I know.. been there.. plenty of times..

|||

i just can not seem to get the syntax correct.

i've tried:

EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout "c:\employees" + CONVERT(Varchar, getdate()) + ".txt" -c -Usa -P'

error: (unknown argument '+' on command line)

and:

EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout "c:\employees' + CONVERT(Varchar, getdate()) + '.txt" -c -Usa -P'

error: (Incorrect syntax near '+')

it always chokes on the '+'

|||

try:

EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout"c:\employees" + CONVERT(VARCHAR(50), getdate()) + ".txt" -c -Usa -P'f

But... I've never seen double quotes actually work in SQL. Would there be any errors on that front?

|||

Concatenation does not work very well with xp_cmdshell.

Declare a variable, do the concatenation and use the variable.

Declare @.Sqlvarchar(500)Set @.sql ='bcp "select * from CEData..employee" queryout "c:\employees" + CONVERT(VARCHAR(50), getdate()) + ".txt" -c -Usa -P'EXEC master..xp_cmdshell @.sql

|||

same ole error...

Unknown argument '+' on command line.

|||

this appeared to work....but in the end, no file exists:

declare @.james as varchar
set @.james = 'c:\employees' + CONVERT(VARCHAR(50), getdate()) + '.txt'
EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout @.james -c -Usa -P'

it runs and says "746 rows copied" but no file exists on the c drive

by the way...this works but doesn't provide a timestamp:

declare @.james as varchar
set @.james = 'c:\employees' + CONVERT(VARCHAR(50), getdate()) + '.txt'
EXEC master..xp_cmdshell 'bcp "select * from CEData..employee" queryout "c:\employees.txt" -c -Usa -P'

|||

Note: put the server name appropriately:

Declare@.Sqlvarchar(500)

Set@.sql='bcp "select * from CEData..employee" queryout "c:\employees'+CONVERT(VARCHAR(50),getdate())+'.txt" -c -Usa -P -s"ServerName"'

EXEC master..xp_cmdshell @.sql

|||

man...

sooooo close.....

i tried your suggestion, and now it runs, says "746 rows copied"...

and when i look at the file, the name is: employeesOct 24 2007 3

and has 0 bytes

so...the date is getting truncated and there is no data.

did you try this and it worked?

|||

Yes I could get it to work by changing the db/table/server names. Did you use varchar(X) like I mentioned or did you exclude the size/length part as I noticed in your earlier post?

|||

i did it exactly as you typed it

i don't know why it works for you but not me. i get a truncated filename and no data

|||

The spaces and the colon in the timestamp is whats throwing off. Try this:

Declare@.Sqlvarchar(500),@.fnamevarchar(100)

SET@.fname='c:\'+Replace(replace(CONVERT(VARCHAR(50),getdate()),' ','_'),':','_')+'.txt'

Set@.sql='bcp "select * from CEData..employee" queryout "'+@.fname+'" -c -T -S"ServerName"'

EXEC master..xp_cmdshell @.sql

How can I generate insert statements for sample data?

Hi,
I want to post a question but I want to also include a script for you guys
to create the table on your end as well as some sample data.
I used to have a tool that would take the data in a table and generate a
bunch of INSERT statements. I can't seem to locate it. Could someone please
give me a pointer on where I can find that script?
--
Thanks,
SamSam wrote:
> Hi,
> I want to post a question but I want to also include a script for you
> guys to create the table on your end as well as some sample data.
> I used to have a tool that would take the data in a table and
> generate a bunch of INSERT statements. I can't seem to locate it.
> Could someone please give me a pointer on where I can find that
> script?
www.aspfaq.com/5006
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"|||Find my post of yesterday :)
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:DF35D0A0-C291-4B03-9860-37DF09F92846@.microsoft.com...
> Hi,
> I want to post a question but I want to also include a script for you guys
> to create the table on your end as well as some sample data.
> I used to have a tool that would take the data in a table and generate a
> bunch of INSERT statements. I can't seem to locate it. Could someone
> please
> give me a pointer on where I can find that script?
> --
> Thanks,
> Sam|||To generate Insert statements from the existing data Check out
http://vyaskn.tripod.com/code.htm its really good.
Source code:: http://vyaskn.tripod.com/code/generate_inserts.txt
Best Regards
Vadivel
http://vadivel.blogspot.com
http://thinkingms.com/vadivel
"Mark Nijhof" wrote:

> Find my post of yesterday :)
>
> "Sam" <Sam@.discussions.microsoft.com> wrote in message
> news:DF35D0A0-C291-4B03-9860-37DF09F92846@.microsoft.com...
>
>|||Try www.sqlscripter.com to generate INSERT, UDPATE, Delete data scripts.
"Sam" wrote:

> Hi,
> I want to post a question but I want to also include a script for you guys
> to create the table on your end as well as some sample data.
> I used to have a tool that would take the data in a table and generate a
> bunch of INSERT statements. I can't seem to locate it. Could someone pleas
e
> give me a pointer on where I can find that script?
> --
> Thanks,
> Sam