Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Language Report Properties - Where??? Expand / Collapse
Author
Message
Posted Monday, September 21, 2009 2:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:04 AM
Points: 216, Visits: 778
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
Posted Monday, September 21, 2009 10:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, September 22, 2009 4:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:04 AM
Points: 216, Visits: 778
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
Posted Tuesday, September 22, 2009 10:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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!

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
Posted Tuesday, September 22, 2009 10:18 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 7, 2013 8:44 AM
Points: 339, Visits: 642
(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
Posted Wednesday, September 23, 2009 1:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:04 AM
Points: 216, Visits: 778
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
Posted Monday, November 5, 2012 9:42 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
LOL.. was faced with the same problem earlier. Thanks for sharing how you found the setting!

---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1381170
Posted Tuesday, November 6, 2012 11:44 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 4:50 PM
Points: 358, Visits: 876
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 »

Add to briefcase

Permissions Expand / Collapse