Reporting Services output other than PDF?

Can someone point me to a list \ description of the output formats available
with SQL Reporing Services? A structured text format in ACSII, PCL, or
something like that would be preferred. Thanks!If you look in the Reporting Services Books Online, you find this article
Exporting Reports
http://msdn2.microsoft.com/en-us/library/ms157153.aspx
It lists the standard formats and other information about exporting reports.
Kaisa M. Lindahl Lervik
"Mr. Wonderful" <MrWonderful@.discussions.microsoft.com> wrote in message
news:2FF99A10-C92E-4D2A-83B9-5A7F608647C4@.microsoft.com...
> Can someone point me to a list \ description of the output formats
> available
> with SQL Reporing Services? A structured text format in ACSII, PCL, or
> something like that would be preferred. Thanks!

Reporting Services output format

I manually build my url for my reports. In the url I build, I can specify the output format I would like it to automatically use when the report opens. However, it always first opens the dialog box to either Save, Open, or Cancel. Is there anyway to bypass this and just open it in the format I have coded in the url? Thanks.No

Every download requires the users to accept or reject it. It's a security thing...

Imagine the chaos, if any developer could create a link, that when clicked, downloaded a file to your local drive and then executed that file.|||Makes good sense. Thanks for the input mbanavige!!!sql

Reporting Services Expression

I am also having trouble with the expressions in reporting services visual studios business intelligent suite. I am tring to format a date as just the mm/dd/yyyy without the time.there are several built-in date/time functions that should help you
format(<date>, "MM/dd/yyyy")

the uppercase M is important, otherwise u will get minutes

Reporting Services Export Excel, Date format Cells

Hi,
Do you know if it's possible when exporting a report to excel, to format
dates columns as Excel Cell Dates ?
Thanks in advance, Greetings
BraulioFormat you can set it in RS too. excel cell dates ' means
Amarnath
"Braulio Diez" wrote:
> Hi,
> Do you know if it's possible when exporting a report to excel, to format
> dates columns as Excel Cell Dates ?
> Thanks in advance, Greetings
> Braulio

Reporting Services Engineering Notation

In Reporting Services, is it possible to display a field in Engineering Notation or Scientific notation? I guess can do it by adding a format code, can somebody tell me the format for those notations.

Thanks

e is the code.

By the way, you can click the ellipses (...) next to format code and see all kinds of cool codes.

Reporting Services Date Format Problem

I have a huge problem with reporting services..

For any reports I am running it interprets all of my dates as US format.

for instance I'm using the following code snippet to specify the date range of a report

CAST(@.FromYear + '-01-' + @.FromMonth AS DATETIME) AS froom MIN(allpartmaster.snlcat) AS cat, DATEADD(dd, - 1, DATEADD(mm, 1, CAST(@.ToYear + '-01-' + @.ToMonth AS DATETIME))) AS toooo

these are then used to not only limit the sql statement's return set but also as labels on the report for clairfication.

parameters are of string type but are passed the likes of

@.FromMonth = '06'

@.FromYear = '2006'

@.ToMonth = '03'

@.ToYear = '2007'

Now I run the report on my developemtn machine with out any problems the above returns

froom = '01/06/2006' the 1st of june 2006
toooo = '31/03/2007' the 31st of March 2006

now when the report is deployed and run on the server the above returns

froom = '06/01/2006' 6th of January 2006
toooo = '02/02/2007' 2nd of Feb 2007

so the dates are being displayed in the correct format for what they are.. but the actual processing of the reports on the report server is flipping them to US format initially and then back to UK format to display them.

I'm at a loss to understand why.. my browser's language settings are UK and my server's windows regional settings at UK as well...

does anyone have any ideas as to why this is happening?

I have no solution, but am experiencing a similar problem..

Using swedish datetypes in SQL Server (2007-03-06), a report will always display it in US format (06/03/2006)..

On every SQL query i use, i have to do a "convert(char(10),date,120) as date" to get it into right format..

The problem is when the datasource is an OLAP cube.. :(

//P?r

|||ok been looking into this further....

unlike your problem my dates are being displayed in the correct format i.e. en-GB but they are being processed by the reporting server as en-US dates. Now I've been looking at the log files for reporting services on my server and the locale is listed at the top of the log file as en-US thus :

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Standard Time</TimeZone>
<Path>path removed by nobble</Path>
<SystemName>server name removed by nobble</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

so it looks like i have to change the report server's locale... any one know how to do this
|||

This is the same issues I have (in the thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1309233&SiteID=1)

Changing local for Reporting Services should do the trick - changing any other local settings sure does not seem to help.

I'll post back to this thread if I get any answers on my thread...

Trond

|||

We have just come up against this problem as well. I think it has only started since we installed SQL 2005 SP2, but I cannot be sure.

Certainly there have been no complaints for the past 6 months, we installed SP2 last Friday and the complaints started today.

|||Well I installed SP2 in a hope that it would fix it, initially on my development machine and was going to install it on my server today... glad you've saved me the trouble..

This seems to be a pretty fundamental problem with Reporting Services has no one else got a work around or solution?|||

Go to the Properties dialog of the Report and for Language property try setting the value "=User!Language" instead of English (United States) in which case you dont need to do anything in the sql server query other than just retrieving the date in whatever format it is in the database.

Shyam

|||The report is currently set to English (United Kingdom). Changing it to "=User!Language" makes no difference...
|||

a_shyam41 wrote:

Go to the Properties dialog of the Report and for Language property try setting the value "=User!Language" instead of English (United States) in which case you dont need to do anything in the sql server query other than just retrieving the date in whatever format it is in the database.

Shyam

This might solve my problem, but there has to be a way to make this a standard value (or to set the server to the right locale setting)..
There is no way i want to do this for hundreds of reports already made, and have to remember it for the hundreds of more that are about to be made..

//P?r

|||

This should solve the problem.

I am almost sure that there is no way to do it at a server level as I myself have developed 100s of globalized reports and this was my first item in the checklist.

Shyam

|||Well i've tried it again and it is still causing me a problem.. the report is now set to "=User!Language"... it works in the designer but not on the server

designer: http://img185.imageshack.us/img185/7969/untitled2ez6.jpg

server: http://img242.imageshack.us/img242/2125/untitled3gp4.jpg|||

As far I can see, the reports are not the same on your local machine (designer) and the server (which may be again your machine which I dont know).

If it is same and my solution didn't work, then the second date in the report server should have shown 03/31/2007. I dont know why it's showing 02/02/2007

Shyam

|||

a_shyam41 wrote:

This should solve the problem.

I am almost sure that there is no way to do it at a server level as I myself have developed 100s of globalized reports and this was my first item in the checklist.

Shyam

And there is no way to make Visual Studio set that as a default?

|||

check out this link

http://msdn2.microsoft.com/en-us/library/ms156493.aspx

and also this paragraph in the link:

"For Report Designer itself, the language resource that is applied to the report-authoring environment is determined by the language of the installation of Microsoft Visual Studio. For example, if you are running a Japanese version of Visual Studio, the Japanese language resource for Report Designer is used. If you are running a language version of Visual Studio that is not supported by SSRS, the neutral resource language is used instead. For more information about neutral resources, see "Operating System Language Settings" later in this topic."

So, the Language property value that you see in the Visual Studio report designer is actually the language of Visual Studio installtion. So, nothing can be done about it but to handle them manually for every report.

|||

a_shyam41 wrote:

As far I can see, the reports are not the same on your local machine (designer) and the server (which may be again your machine which I dont know).

If it is same and my solution didn't work, then the second date in the report server should have shown 03/31/2007. I dont know why it's showing 02/02/2007

Shyam

Its the same report deployed on the server, which is a different machine to my development machine.

Its showing 02/02/2007, because its taking the date passed to it 2007-01-03 as the 3rd of Jan not the 1st of March, so when it adds a month and takes away a day it gets the 2nd of Feb, which it then displays as 02/02/2007. As I said the displaying of the date in the report is fine, its the actual calculation that is incorrectly converting it into en-US format... This is my problem

Reporting Services Currency Symbol

I have added User!Language to my report which returns en-GB but the currency
format 'C' still returns the values in $ and not £
MSDN and an earlier post here mentions the help text that has this section
'you can set a locale on the report and on individual text boxes by using
the Language property'
If I right click on the field on the report and select properties there is
no Language property so I do not understand where it is talking about
Any ideas?
TIA
NeilThe Language property shows up in the VS Property window (hit F4).
Note: every report has a global language property (in the VS Property
window, select "Report" from the top drop-down box and then look for the
Language property). It seems like it is set to "en-US" in your case. You
need to set the Report-Language to "Default" and republish it to the report
server. Then at runtime, the report will be processed in the thread culture
specified in the Internet Explorer language settings.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Neil" <Neil@.discussions.microsoft.com> wrote in message
news:210F44A1-EFFB-42F8-8A72-EEE76B40D3A1@.microsoft.com...
> I have added User!Language to my report which returns en-GB but the
currency
> format 'C' still returns the values in $ and not £
> MSDN and an earlier post here mentions the help text that has this section
> 'you can set a locale on the report and on individual text boxes by using
> the Language property'
> If I right click on the field on the report and select properties there is
> no Language property so I do not understand where it is talking about
> Any ideas?
> TIA
> Neil
>|||Hi Robert,
Thanks, I had just found that myself, the confusion was caused by the text
box having 2 property windows, one was right-click and the other the bottom
right hand corner window, and the help file did not state which to use, so I
was right clicking and selecting properties which had the currency format
style 'C'
thanks
Neil.
"Robert Bruckner [MSFT]" wrote:
> The Language property shows up in the VS Property window (hit F4).
> Note: every report has a global language property (in the VS Property
> window, select "Report" from the top drop-down box and then look for the
> Language property). It seems like it is set to "en-US" in your case. You
> need to set the Report-Language to "Default" and republish it to the report
> server. Then at runtime, the report will be processed in the thread culture
> specified in the Internet Explorer language settings.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Neil" <Neil@.discussions.microsoft.com> wrote in message
> news:210F44A1-EFFB-42F8-8A72-EEE76B40D3A1@.microsoft.com...
> > I have added User!Language to my report which returns en-GB but the
> currency
> > format 'C' still returns the values in $ and not £
> >
> > MSDN and an earlier post here mentions the help text that has this section
> > 'you can set a locale on the report and on individual text boxes by using
> > the Language property'
> >
> > If I right click on the field on the report and select properties there is
> > no Language property so I do not understand where it is talking about
> >
> > Any ideas?
> >
> > TIA
> >
> > Neil
> >
>
>

Reporting Services Currency (￡)

I am trying to produce a report showing Currency in ￡ using Visual Studio 2005 reporting services.

On trying to format the textbox the only option that it seems to give you is for it to be displayed in $.

Does anyone know how i can display a number in ￡ instead of $?

Try putting something like this in your format code:

￡ ###,###,###.##

Depending on how large your numbers could get, just add #'s. It doesn't add leading 0's.

Hope this helps.

Jarret

|||

Another way to do this is to set the language property of the report to 'English (United Kingdom)', then set your fields to display with the format code of 'C' (currency). It will automatically set the default currency symbol for that language on any fields set for currency.

Jarret

Reporting Services Currency (£)

I am trying to produce a report showing Currency in ￡ using Visual Studio 2005 reporting services.

On trying to format the textbox the only option that it seems to give you is for it to be displayed in $.

Does anyone know how i can display a number in ￡ instead of $?

Try putting something like this in your format code:

￡ ###,###,###.##

Depending on how large your numbers could get, just add #'s. It doesn't add leading 0's.

Hope this helps.

Jarret

|||

Another way to do this is to set the language property of the report to 'English (United Kingdom)', then set your fields to display with the format code of 'C' (currency). It will automatically set the default currency symbol for that language on any fields set for currency.

Jarret