Report DateTime Parameters in UK date format

I have a report that I've developed that accepts several datetime parameters.
In the Report properties, I've set the report Language to English (United
Kingdom).
I am calling my report via the Web Service from an ASP.Net application. The
ASP.Net application Culture and UICulture are set for en-GB.
What is happening is that when a date is passed to one of the report
parameters (gEndDate) as "14/12/2004" (December 14), I get the following
error:
The value provided for the report parameter 'gEndDate' is not valid for its
typeI should also point out that my Visual Studio .Net 2003 environment is in
en-US and my computer is in the United States English setting.
The development environment I am testing (where I got the error) is a
Virtual PC environment set up as English UK in the Control Panel.
"AdamB" wrote:
> I have a report that I've developed that accepts several datetime parameters.
> In the Report properties, I've set the report Language to English (United
> Kingdom).
> I am calling my report via the Web Service from an ASP.Net application. The
> ASP.Net application Culture and UICulture are set for en-GB.
> What is happening is that when a date is passed to one of the report
> parameters (gEndDate) as "14/12/2004" (December 14), I get the following
> error:
> The value provided for the report parameter 'gEndDate' is not valid for its
> type
>

Report conver to PDF format issue?

Hi All:

When i am trying to save the report (http) as PDF format, how can i make sure the format is what i want?

Becuase currently what i got is that it splits the report as half by saving PDF, and each half as one page.

Any helpf will be appreciated.

Cheers

Nick

Hi Nick,

Lets assume you want A4 format, lanscape.

Go to the report properties (main menu) and select the "Layout" tab. Now fill in these vaules:

Page height: 8.27in; Page width:11.69in; All four margin fiels 0.2in.

Click OK

Now click an empty spot on your report, so your "body" will be selected and check the layout / size properties.

It's important that the size of your body in the report is smaller than your page layout, minus your margins, so this should max. be 8.27-0.4 = 7.87in by 11.69-0.4 = 11.29in

Jeroen

|||

Thanks Jeroen Alblas,

i couldn't see four margin fields in report properties.

My report can print out just fit one page but not PDF format, which splits to two pages.

Cheers

Nick

|||

I found it.

Now it's working. I can print out as PDF format perfectly

Thanks Jeroen Alblas

Report Builder Formatting Currency

Hi all

I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.

I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.

My Question is: Where do I set the culture setting?

I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated

G

under format in properties of the textbox

change it to

$ ###, ###, ###.##

|||

Thanks X

But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix

The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?

They dont give any other specifics

Thanks for the responce

G

|||

maybe set it in Connection String ?

Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us

|||

Hi

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

Still stuck

G

|||

GDavids - SAO wrote:

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

report model have Datasources link in Properties

Datasource have connection string ;]

|||

thanks giret

Where do I view this?

In Report Manager? Because I dont find it..

Thanks for the reponces

|||

http://localhost/Reports/

click on Your model name

Properties Tab:

General

DataSources

Security

|||

This gives the path to my datasource.

Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?

Report Builder Formatting Currency

Hi all

I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.

I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.

My Question is: Where do I set the culture setting?

I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated

G

under format in properties of the textbox

change it to

$ ###, ###, ###.##

|||

Thanks X

But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix

The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?

They dont give any other specifics

Thanks for the responce

G

|||

maybe set it in Connection String ?

Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us

|||

Hi

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

Still stuck

G

|||

GDavids - SAO wrote:

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

report model have Datasources link in Properties

Datasource have connection string ;]

|||

thanks giret

Where do I view this?

In Report Manager? Because I dont find it..

Thanks for the reponces

|||

http://localhost/Reports/

click on Your model name

Properties Tab:

General

DataSources

Security

|||

This gives the path to my datasource.

Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?

Report Builder - Format Point Labels

Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release? For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis. The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry

This is true. If you format a field and display this field value on the point labels on a graph the format doesn't apply. In the Report Design if you go to the Chart properties -->Data Tab -->Values Edit --> Point Labels Tab-->there is an option "Format Code" to format the point labels. This isn't available in report builder.

Is there a work around?

Thanks, Susan

|||

I found a solution for my problem. I created a NEW field in Report Builder and I used the ROUND() Math function to round this field to two digits. I still think that you should be able to format the point labels in a graph in Report Builder. This is a bug.

Thanks, Susan

Report Builder - Format Chart Y Axis

Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release? For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis. The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry

This is true. If you format a field and display this field value on the point labels on a graph the format doesn't apply. In the Report Design if you go to the Chart properties -->Data Tab -->Values Edit --> Point Labels Tab-->there is an option "Format Code" to format the point labels. This isn't available in report builder.

Is there a work around?

Thanks, Susan

|||

I found a solution for my problem. I created a NEW field in Report Builder and I used the ROUND() Math function to round this field to two digits. I still think that you should be able to format the point labels in a graph in Report Builder. This is a bug.

Thanks, Susan

Report Bodytext in various Languages?

we need to format the bodytext on our reports in various languages.
We created a Table in SQL Server: ReportLocalizationBodytext
ID, strItem, strText, intLanguage
1, page, Seite, 1
2, page, Page, 2
etc... hundrets of entries
We created a Stored Procedure: usp_RPTS_GetBodytext
Input Parameters are:
@. intLanguageID, @.intReportID
to identify the current report and the desired Userlanguage
returned output-table of the stored procedure is:
Select strItem, strText from ReportLocalizationBodytext
where intReportID = @.intReportID and intLanguage = @.intLanguage
And now begins the headache:
Any one report contains around 20 diferent text labels which have to be
localized.
Currently we created one dataset for each text label.
E.g. the text "Page 1 of 9 pages" needs at least three labels to be
translated:
"Page", "of" and "pages"
so we have three Datasets like:
bdytxtPage, bdytxtOf and bdytxtPages
Each dataset receives the same 20 items and filters via a Report Definition
Language Datase Filter its one only text translation, like:
expression, operator, value
=Fields!strItem.Value, =, page
The final entry in the report-textbox is:
=First(Fields!strText.Value, "bdytxtPage") & Globals.PageNumber &
First(Fields!strText.Value, "bdytxtOf")
& Globals.TotalPages & First(Fields!strText.Value, "bdytxtPages")
In english there may be printed:
Page 3 of 9 pages
In German
Seite 3 von 9 Seiten
and so on
Question:
Wouldn't it be possible to create one lonely dataset e.g. Bodytext
and then derive each bdytxtText from this complete dataset rather than to go
out 20 times for each and every single word to retrieve each time the same
dataset, but filter it in a different way?Hello Henry,
I would like to suggest you to create a custom code in the reporting
service to retrive the data rather than use the Report Build in dataset to
get the data.
Writing Custom Code for Reporting Services
http://msdn2.microsoft.com/en-us/library/aa255830(sql.80).aspx
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei Lu, thank you very much,
I've been thinking in writing custom code, as I already did in the past, but
I don't know, how to program it to retrieve a table and iterate through it to
get the text I need. Please give me some advice.
Sincerily, Henry
"Wei Lu [MSFT]" wrote:
> Hello Henry,
> I would like to suggest you to create a custom code in the reporting
> service to retrive the data rather than use the Report Build in dataset to
> get the data.
> Writing Custom Code for Reporting Services
> http://msdn2.microsoft.com/en-us/library/aa255830(sql.80).aspx
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Henry,
Why do store the information in a XML document?
I have tested in my side and successfully deployed it.
Here is the XML document:
=================<?xml version="1.0" encoding="utf-8" ?>
<Text>
<BodyTexts LanguageID="1">
<BodyText strItem="page" value ="Page"></BodyText>
<BodyText strItem="pages" value ="Pages"></BodyText>
</BodyTexts>
<BodyTexts LanguageID="2">
<BodyText strItem="page" value="Seite"></BodyText>
<BodyText strItem="pages" value="Seites"></BodyText>
</BodyTexts>
</Text>
=====================
Then, I developed a custom assembly. Here is the code in C#:
=============using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
namespace XMLReportTest
{
public class XmlReportTestClass
{
private XmlDocument docx;
public XmlReportTestClass()
{
docx = new XmlDocument();
docx.Load(@."D:\DataLanguage.xml");
}
public string GetStrText(Int32 intLanguageID, string strItem)
{
XmlNode Node =docx.SelectSingleNode("/Text/BodyTexts[@.LanguageID=" +
intLanguageID.ToString() + "]");
XmlNode Node1 = Node.SelectSingleNode("./BodyText[@.strItem=\""
+ strItem + "\"]");
return Node1.Attributes["value"].Value;
}
}
}
==============
The GetStrText method will return the strText value by provide the
LanguageID and the strItem.
Then in the Report, you could add a Reference to the assembly. You could
then assign an instance name to the class and refer the instance in the
report design.
Here is the rdl file of the report
=============================<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Textbox Name="textbox2">
<Left>1.5cm</Left>
<Top>2.75cm</Top>
<ZIndex>1</ZIndex>
<Width>7.75cm</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.75cm</Height>
<Value>=Code.doc.GetStrText(2,"pages")</Value>
</Textbox>
<Textbox Name="textbox1">
<Left>1.5cm</Left>
<Top>1cm</Top>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>7.75cm</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.75cm</Height>
<Value>=Code.doc.GetStrText(1,"page")</Value>
</Textbox>
</ReportItems>
<Height>5cm</Height>
</Body>
<rd:ReportID>f3f844c0-d523-4e9a-9c50-7c22374abfe2</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<CodeModules>
<CodeModule>System.Xml, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089</CodeModule>
<CodeModule>XMLReportTest, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=null</CodeModule>
</CodeModules>
<Code />
<Width>16cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Classes>
<Class>
<ClassName>XMLReportTest.XMLReportTestClass</ClassName>
<InstanceName>doc</InstanceName>
</Class>
</Classes>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>
==================
Please note, you need to copy the assembly to some place before to deploy
it to the report server and preview in the report designer.
To deploy a custom assembly in Reporting Services
Copy your custom assembly from your build location to the report server bin
folder or the Report Designer folder. The default location of the bin
folder for the report server is C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\bin. The default location of
the Report Designer is C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies.
Deploying a Custom Assembly
http://msdn2.microsoft.com/en-gb/library/ms155034.aspx
If you do not wants to use the xml to store the information, you could
modify my assembly to retrieve the data from the database and add the
assembly to the report.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Report "code behind"

Or rather simple access top the report in markup format from Visual studio! Sometimes I have to go to windows explorer and drill down to my report and open it as a .txt file to see what I am looking for.

Why in gods name does visual studio not have it such that I can see my report in markup.

I am running local reports which might be the reason, cant complain to much over something that is free I guess

In Visual Studio you can right-click on the report name and open in XML format - if that's what you are talking about.