SSRS Language Report Properties - Where???

  • 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

  • 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.

  • 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

  • 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.

  • (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.

    [font="Arial"]Are you lost daddy? I asked tenderly.
    Shut up he explained.
    [/font]
    - Ring Lardner

  • 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

  • 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[/url]

    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

  • 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.

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply