How to show progress bar in report column

Hi,

I have to show particular item progress status in a report column in graphical format.

For example, if item finish state is 60% then, column should display status in progress bar or similar to that.

Is this possible?

Any help would be appreciated.

Thanks

Hi,

you either make a graph showing 60 in the scale of 100 or use any thrid party tool from dundas to show gauges (or a different object)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

sql

How to setup Padding after clicking ToggleItem

I am trying to format the output result from a Recursive Group dataset.
The dataset is very simple with EmployeeID and ManagerID as recursive and
the latter being the parent id. Table structure is very simple with one
line on the detail level with EmployeeID, EmployeeName, ManagerName & Level
(using Level Function).
The report correctly returns all the records order by Level and Toggle by
EmployeeID. However, I would like to setup Padding when subsequent levels
show up after clicking the ToggleItem. Where would I set that up? Any
required scripts involved (iif...?). I would also like to setup different
color formatting for the different levels, and I assume it could be setup at
the same property setting as the Padding.
Much appreciated!
-Lawrenceyou could use Level() function to set padding and color.
For example, setting left padding to expression
=String.Format("{0}pt",Level() * 10) provides 10 points padding per level.
I would suggest using =Switch() for changing color:
=switch (Level() = 0, "Red", Level() = 1, "Blue", True, Nothing)
switch () takes a variable number of parameters in the form of (evaluation,
if true return, next evaluation ...)--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lawrence" <Lawrence@.discussions.microsoft.com> wrote in message
news:61F57876-20A5-4A81-94DB-3ABA16AD8053@.microsoft.com...
> I am trying to format the output result from a Recursive Group dataset.
> The dataset is very simple with EmployeeID and ManagerID as recursive and
> the latter being the parent id. Table structure is very simple with one
> line on the detail level with EmployeeID, EmployeeName, ManagerName &
Level
> (using Level Function).
> The report correctly returns all the records order by Level and Toggle by
> EmployeeID. However, I would like to setup Padding when subsequent levels
> show up after clicking the ToggleItem. Where would I set that up? Any
> required scripts involved (iif...?). I would also like to setup different
> color formatting for the different levels, and I assume it could be setup
at
> the same property setting as the Padding.
> Much appreciated!
> -Lawrence

how to set the default filename when exporting the report

Dear Anyone,

When exporting a report to another format, say excel; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to excel, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services as well as report builder?

Thanks,
JosephThere is no way to change the name of the export. You could set up a subscription to save the file off to a file. Not sure if that will sufficient or not for your scenario.

-Daniel|||

With Reporting Service 2005, you can create a data-driven subscription and set the FILENAME parameter.

Here is a sample query:

select'bogus - '+LEFT(DATENAME(month,getdate()),3)+' '+(CAST(DatePart(dd,GetDate())asnvarchar)+' '+CAST(DatePart(yyyy,GetDate())asnvarchar))asFILENAME

Hope this helps!

Thanks.

|||I am not sure, but I recall
Data-Driven Subscription is part of SQL Server/Report Server 2005Enterprise edition only|||

hi,

Can you help me on this issue,

My requirement is need to change the Report data file name appending with timestamp.

1. I created RDL
2. Opening the RDL data into my GWT application with new IE window
3. Exporting the data into excel/pdf.
4. Able to popup Download file Dialog.
5. Asking the File to save. ( Here by defualt it's giving the RDL File name only. I want to display with RDL file name with timestamp).

But what every you said , I created data-driven subscription, In Delivery Query Screen: Even i tried with A shared data source, able to validate the Command text. Finally not able to change the file name. Can you please tell what is the problem is.

best regards

bhushanam

how to set the default filename when exporting the report

Dear Anyone,

When exporting a report to another format, say excel; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to excel, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services as well as report builder?

Thanks,
JosephThere is no way to change the name of the export. You could set up a subscription to save the file off to a file. Not sure if that will sufficient or not for your scenario.

-Daniel|||

With Reporting Service 2005, you can create a data-driven subscription and set the FILENAME parameter.

Here is a sample query:

select 'bogus - ' + LEFT(DATENAME(month, getdate()),3) + ' ' + (CAST(DatePart(dd, GetDate()) as nvarchar) + ' ' + CAST(DatePart(yyyy, GetDate()) as nvarchar)) as FILENAME

Hope this helps!

Thanks.

|||I am not sure, but I recall
Data-Driven Subscription is part of SQL Server/Report Server 2005 Enterprise edition only|||

hi,

Can you help me on this issue,

My requirement is need to change the Report data file name appending with timestamp.

1. I created RDL
2. Opening the RDL data into my GWT application with new IE window
3. Exporting the data into excel/pdf.
4. Able to popup Download file Dialog.
5. Asking the File to save. ( Here by defualt it's giving the RDL File name only. I want to display with RDL file name with timestamp).

But what every you said , I created data-driven subscription, In Delivery Query Screen: Even i tried with A shared data source, able to validate the Command text. Finally not able to change the file name. Can you please tell what is the problem is.

best regards

bhushanam

how to set the default filename when exporting the report

Dear Anyone,

When exporting a report to another format, say excel; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to excel, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services as well as report builder?

Thanks,
JosephThere is no way to change the name of the export. You could set up a subscription to save the file off to a file. Not sure if that will sufficient or not for your scenario.

-Daniel|||

With Reporting Service 2005, you can create a data-driven subscription and set the FILENAME parameter.

Here is a sample query:

select 'bogus - ' + LEFT(DATENAME(month, getdate()),3) + ' ' + (CAST(DatePart(dd, GetDate()) as nvarchar) + ' ' + CAST(DatePart(yyyy, GetDate()) as nvarchar)) as FILENAME

Hope this helps!

Thanks.

|||I am not sure, but I recall
Data-Driven Subscription is part of SQL Server/Report Server 2005 Enterprise edition only

How to set PDF margins when rendering via WS

I'm rendering reports in PDF format in aspx pages by calling the ssrs
webservice. Is there a way to adjust the side margins in the PDF?
Currently the margins are a default of 1 inch on each side and I want to
reduce it to 1/2 inch on each side.
Thanks.
--
moondaddy@.nospam.nospamHello,
I suggest that you refer to the following topics in Reporting Services
Books Online:
PDF Device Information Settings
Device Information Settings
Render Method
I hope the information is helpful.
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.

How to set excel sheet name?

Is there any possibility that I can change properties of excel format
when exporting into it.? I need to have two or many sheets in that excel and
I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
How can I name them in design mode of report?
DomagojThere is no way to specify sheet names in the current version. This is on
our wishlist for a future release.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Domagoj Fabricni" <something@.pero.com> wrote in message
news:%23RZPVNAkEHA.672@.TK2MSFTNGP10.phx.gbl...
> Is there any possibility that I can change properties of excel format
> when exporting into it.? I need to have two or many sheets in that excel
and
> I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
> How can I name them in design mode of report?
> Domagoj
>|||Has control over the sheetnames been included in the SP2? I can't see the
functional enhancements list as I'm not a beta program member.
"Chris Hays [MSFT]" wrote:
> There is no way to specify sheet names in the current version. This is on
> our wishlist for a future release.
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Domagoj Fabricni" <something@.pero.com> wrote in message
> news:%23RZPVNAkEHA.672@.TK2MSFTNGP10.phx.gbl...
> > Is there any possibility that I can change properties of excel format
> > when exporting into it.? I need to have two or many sheets in that excel
> and
> > I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
> > How can I name them in design mode of report?
> >
> > Domagoj
> >
> >
>
>|||No, it is not included.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:E2E21646-9E16-44F7-AD7D-36FD4DB3301F@.microsoft.com...
> Has control over the sheetnames been included in the SP2? I can't see the
> functional enhancements list as I'm not a beta program member.
> "Chris Hays [MSFT]" wrote:
>> There is no way to specify sheet names in the current version. This is
>> on
>> our wishlist for a future release.
>> --
>> This post is provided 'AS IS' with no warranties, and confers no rights.
>> All
>> rights reserved. Some assembly required. Batteries not included. Your
>> mileage may vary. Objects in mirror may be closer than they appear. No
>> user
>> serviceable parts inside. Opening cover voids warranty. Keep out of reach
>> of
>> children under 3.
>> "Domagoj Fabricni" <something@.pero.com> wrote in message
>> news:%23RZPVNAkEHA.672@.TK2MSFTNGP10.phx.gbl...
>> > Is there any possibility that I can change properties of excel
>> > format
>> > when exporting into it.? I need to have two or many sheets in that
>> > excel
>> and
>> > I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
>> > How can I name them in design mode of report?
>> >
>> > Domagoj
>> >
>> >
>>|||You may want to check out SoftArtisians's OfficeWriter:
http://officewriter.softartisans.com/officewriter-250.aspx
--
Adrian M.
MCP
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:E2E21646-9E16-44F7-AD7D-36FD4DB3301F@.microsoft.com...
> Has control over the sheetnames been included in the SP2? I can't see the
> functional enhancements list as I'm not a beta program member.
> "Chris Hays [MSFT]" wrote:
>> There is no way to specify sheet names in the current version. This is
>> on
>> our wishlist for a future release.
>> --
>> This post is provided 'AS IS' with no warranties, and confers no rights.
>> All
>> rights reserved. Some assembly required. Batteries not included. Your
>> mileage may vary. Objects in mirror may be closer than they appear. No
>> user
>> serviceable parts inside. Opening cover voids warranty. Keep out of reach
>> of
>> children under 3.
>> "Domagoj Fabricni" <something@.pero.com> wrote in message
>> news:%23RZPVNAkEHA.672@.TK2MSFTNGP10.phx.gbl...
>> > Is there any possibility that I can change properties of excel
>> > format
>> > when exporting into it.? I need to have two or many sheets in that
>> > excel
>> and
>> > I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
>> > How can I name them in design mode of report?
>> >
>> > Domagoj
>> >
>> >
>>

How to set date format as mm/dd/yyyyThh:mm:ss.ttttZ+00:00?

Hi,
I use "For XML" statement to export xml, all are my expected. But the
datetime field value is not my expected format(e.g.
ModifiedDate="2005-05-16T16:33:33.060"), Can I force the sql server's xml
date format including timezone like as yyyy/mm/ddThh:mm:ss.ttttZ+00:00?
You would have to use CONVERT(nvarchar(40), datetimeval, 127) + N'Z' in the
select clause since SQL Server currently does not know what timezone you
could possibly want.
Best regards
Michael
"ABC" <abc@.abc.com> wrote in message
news:urvzmAilHHA.1216@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use "For XML" statement to export xml, all are my expected. But the
> datetime field value is not my expected format(e.g.
> ModifiedDate="2005-05-16T16:33:33.060"), Can I force the sql server's xml
> date format including timezone like as yyyy/mm/ddThh:mm:ss.ttttZ+00:00?
>
>

How to set date format as mm/dd/yyyyThh:mm:ss.ttttZ+00:00?

Hi,
I use "For XML" statement to export xml, all are my expected. But the
datetime field value is not my expected format(e.g.
ModifiedDate="2005-05-16T16:33:33.060"), Can I force the sql server's xml
date format including timezone like as yyyy/mm/ddThh:mm:ss.ttttZ+00:00?You would have to use CONVERT(nvarchar(40), datetimeval, 127) + N'Z' in the
select clause since SQL Server currently does not know what timezone you
could possibly want.
Best regards
Michael
"ABC" <abc@.abc.com> wrote in message
news:urvzmAilHHA.1216@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use "For XML" statement to export xml, all are my expected. But the
> datetime field value is not my expected format(e.g.
> ModifiedDate="2005-05-16T16:33:33.060"), Can I force the sql server's xml
> date format including timezone like as yyyy/mm/ddThh:mm:ss.ttttZ+00:00?
>
>

How to Send Mail to a Personal Distribution List (PDL) ?

Hi friends,

Though we can send mails to Individual addresses, I wonder what would be the Syntax to specify in the script task or Format to specify in a "To" Property of Send Mail task that I use to Send a mail to my Personal Distribution List (PDL).

Thanks

Subhash Subramanyam

You cannot do this using the SMTP Mail Task, because SMTP does not have personal lists. That is a feature of your "mail box", and comes with technologies like MAPI and mail servers. You do not want MAPI I assure you, it is horrific to use in a server environment.

Really you need to get a list created at the mail server level, or just send to all people using individual addresses.

|||

Hi Friends,

Surely I accept to the ideas of experts' reply here.

Thanks to dipendra baghel, who found a custom component "nsoftware send email task".

But solution for the Send Mail task to work is right here: When we create a PDL, The exchange server creates a valid address which can route to list of address in PDL.(say, sdfds@. sdd.com) . This address can be fed into "To" property in Send Mail Task

Thanks to my colleagues Sunil Gidwani, Dipendra Baghel and Prashanth Tiwari for their support

Thanks

Subhash Subramanyam

|||

Thanks for your reply, Darren.

I understood here that PDL is a feature of mailbox having MAPI Technology or other Mail Servers.

So I'd rather wish that in the future verison of SSIS, Send mail task should have an option to import addresses from a csv file or address book and should help us allow grouping that help customize broadcasting (Says incase of Newsletters, Alerting the Teams etc)

Thanks

Subhash Subramanyam

|||

As you mentioned in the answer to this post, groups and mailing lists are a function of the email server, not of the task sending the mail. If you want to send to a group of people via the SMTP task, you can already either set up a group email alias on your mail server, or read an external list, and use a script to put a series of email addresses in the To: property on the SMTP task.

|||

Distribution lists can be defined in a personal MAPI "mailbox", in fact it worked for that in the old SQL Mail or DTS Send Mail task, but MAPI is absolute pants in an unattended envrionment., and I cannot stress that enough. You had to install Outlook on your server to get it, and the only version that worked reliably was Outlook 2000. MAPI is owned my the office team, and they have a different focus. They effectively broke MAPI to SMTP delivery in one release, you had to leave Outlook running on the server!

So do not wish for MAPI is my message, you would regret it!

Importing a CSV for sending mail, ma I point out that we have SSIS, see the Flat File source, the recordset desination, and the for each loop. Using those components and tasks you can drive a email list off a CSV file and mail each address. It is not the simplest method, but then SSIS is not supposed to be a bulk mailer. What about featues like unsubscribe and other list management features? Use the right tool for the job I is what I mean. If bulk mail features are too much, then just use the standard mail server itself, they all support distribution lists much better than SSIS or MAPI ever will.