SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS Language Report Properties - Where???


SSRS Language Report Properties - Where???

Author
Message
Ludo-ZX7R
Ludo-ZX7R
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1116 Visits: 789
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
mRainey
mRainey
SSC-Addicted
SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)

Group: General Forum Members
Points: 432 Visits: 117
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.
Ludo-ZX7R
Ludo-ZX7R
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1116 Visits: 789
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
mRainey
mRainey
SSC-Addicted
SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)SSC-Addicted (432 reputation)

Group: General Forum Members
Points: 432 Visits: 117
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.
Cris E
Cris E
Mr or Mrs. 500
Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)

Group: General Forum Members
Points: 573 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
Ludo-ZX7R
Ludo-ZX7R
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1116 Visits: 789
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
Abu Dina
Abu Dina
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4891 Visits: 3325
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
MMartin1
MMartin1
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11120 Visits: 2034
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.

----------------------------------------------------
How to post forum questions to get the best help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search