Showing posts with label customized. Show all posts
Showing posts with label customized. Show all posts

Monday, March 12, 2012

how to use international date formats from US English environment

I am creating several different versions of essentialy the same report, each
version customized to suit the country for which it's being desgned (i.e US
English, Australian English, German, French, Hebrew, etc.).
How do get a German date format to show up in the German report, and an
Australina date format to show up on the Australian report, etc.?
All reports are being designed on a US English Windows XP workstation and
are being served by a US English Windows 2000 web server.
I am using reporting services SP1.Please read this posting and follow the MSDN links contained in it:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=25f15450-369f-4086-9fa8-f3141dac1fef&sloc=en-us
You might also want to read this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=5840e256-e991-49e9-921e-784efefd274a&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Koenig" <mkoenig> wrote in message
news:uHSJhKvfEHA.2928@.TK2MSFTNGP10.phx.gbl...
> I am creating several different versions of essentialy the same report,
each
> version customized to suit the country for which it's being desgned (i.e
US
> English, Australian English, German, French, Hebrew, etc.).
> How do get a German date format to show up in the German report, and an
> Australina date format to show up on the Australian report, etc.?
> All reports are being designed on a US English Windows XP workstation and
> are being served by a US English Windows 2000 web server.
> I am using reporting services SP1.
>

Friday, March 9, 2012

how to use GetReportParameters for a parameter with dependencies?

try to develop a customized report with personal UI.

can use GetReportParameters to get all parameters. but can not find a way to get the paramter with dependencies.

there is a perference from http://www.odetocode.com/Articles/123.aspx. I made my own code, but it never works.

any helps? thanks.

--

Dim vs() As ParameterValue = Nothing

vs(0) = New ParameterValue

vs(0).Name = pName ' dependency' name

vs(0).Value = pValue ' dependency' value

Dim ps() As ReportParameter = rs.GetReportParameters(report, Nothing, True, vs, Nothing)

When calling GetParameters you want to pass in the parameter values you have. If a dependency is satisfied by that set then the return value should have the values for the dependent parameter populated.

how to use GetReportParameters for a parameter with dependencies?

try to develop a customized report with personal UI.

can use GetReportParameters to get all parameters. but can not find a way to get the paramter with dependencies.

there is a perference from http://www.odetocode.com/Articles/123.aspx. I made my own code, but it never works.

any helps? thanks.

--

Dim vs() As ParameterValue = Nothing

vs(0) = New ParameterValue

vs(0).Name = pName ' dependency' name

vs(0).Value = pValue ' dependency' value

Dim ps() As ReportParameter = rs.GetReportParameters(report, Nothing, True, vs, Nothing)

When calling GetParameters you want to pass in the parameter values you have. If a dependency is satisfied by that set then the return value should have the values for the dependent parameter populated.