SSRS Language Report Properties

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSRS Language Report Properties - Where???

SSRS Language Report Properties - Where???

Rate Topic

Display Mode

Topic Options

Author

Message

Ludo-TRX850

Posted Monday, September 21, 2009 2:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 2:27 AM
Points: 199, Visits: 616

Hi

I have created a simple report which does not access any database or even display anything for that matter.

I just have a parameter which is a date.

When I run the report I therefore end-up with a little calendar at the top of the page.

When I select a date, in the textbox the correct format is displayed. Unfortunately when I click on the "View Report" button I get an error message.

This only happens when I select a date with a day greater than 12.

Does that make sense?

I work in the Uk and my machine is set-up as such but I have read that you can change the locale in the report itself.

My problem is that I cannot find any properties in SSRS that says "Language" apart from a field.

Please help!!!

Ludo

Post #790993

Michael R

Posted Monday, September 21, 2009 10:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 11, 2011 11:56 AM
Points: 172, Visits: 113

Hi Ludo,

First - can you post the error that you are receiving?

Second - to change the Language of the report, select the report and go to the Properties window. Under the Misc section there is a Language property.

Hope this helps. Thanks!

Michael R.

Post #791301

Ludo-TRX850

Posted Tuesday, September 22, 2009 4:45 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 2:27 AM
Points: 199, Visits: 616

Hi

Thanks for getting back to me.

I do apologise for not answering earlier but I was tied-up on another part of the project.

The error I am getting is the following one:
An error occured during local report processing.
The value provided for the report parameter 'StartDate' is not valid for its type.

Now I had a look at all the properties I can find and I can see any Misc anywhere.

1- From the Layout view, I click on the background and I have:
- Appearance
- BackgroundImage
- BorderColor
- BorderStyle
- Layout
- Size

2- When I select "Report" in the top menu then "Report Properties", I have a new window with tabs
- General
- Layout
- Code
- References
- Data Output

3- In the Solution Explorer, when I select my report under the "Reports" tab, Iget
- Location (File Name, Full Path)

What other properties should I check?!?!?

Sorry for being so thick!

Cheers

Ludo

Post #791657

Michael R

Posted Tuesday, September 22, 2009 10:02 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 11, 2011 11:56 AM
Points: 172, Visits: 113

I can understand how finding the correct "Report Properties" can be confusing, since there are so many variations! Smile

When the report is in Layout view, click on the gray box in the top left of the report (between the rulers). The box should contain a little black square when selected. Now, the Properties window (below the solution explorer) should contain the Misc section, along with many other properties.

Check out this article on MSSQLtips.com.

Enjoy!

Michael R.

Post #791945

Cris E

Posted Tuesday, September 22, 2009 10:18 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 24, 2012 10:02 AM
Points: 339, Visits: 639

(It's not exactly what you asked, but here's a related problem.)

SQL Server (and its various components, including Reporting Services) have a default date format that is assumed anytime another format is not specified. It's tied to the languages installed, and there are system stored procs that will tell you which is the default. If more than one language is installed then each user account may have its own default language (and date format). You can set the dateformat in SQL if you want, or just adjust to the default language/fomatting on your box.

There are countless blog and support pages dedicated to the topic. Just put in DEFAULT DATE FORMAT in the search box on this page. Here's one of the first ones that comes up: Changing the default date format of SQL server 2005.

Are you lost daddy? I asked tenderly.
Shut up he explained.
- Ring Lardner

Post #791960

Ludo-TRX850

Posted Wednesday, September 23, 2009 1:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 2:27 AM
Points: 199, Visits: 616

Hi

Thanks you both for your support!

I have finally found the missing properties.

When you select the layout, you have the properties on the right which has a drop-down box at the top. If I select "report", I get what I want.

I thought I was going insane!?!?!

I will also do some more reading with the info you have provided me with.

Cheers

Ludo

Post #792416

Abu Dina

Posted Monday, November 05, 2012 9:42 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:34 AM
Points: 494, Visits: 2,158

LOL.. was faced with the same problem earlier. Thanks for sharing how you found the setting!

-----------------------------------
http://www.SQL4n00bs.com

Post #1381170

mmartin1

Posted Tuesday, November 06, 2012 11:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:11 PM
Points: 193, Visits: 642

I suggest also running

dbcc useroptions

on the database(s) the report points to.
This will let you know for sure the language setting used on the target.
Regards.

Post #1381675

« Prev Topic | Next Topic »

Permissions