hi,
i would like to write a sql function which takes 3 parameters.
1. Source currency type
2. destination currency type
3. Amount to be converted
I need the dynamic rates.
Does anybody hav any idea about how to go with this.
Thanks in advance,
Vinu
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1Are you using SQL Server 2005 ? Therefore you could use Webservices to
call an currency service synchronously or async. by storing the data
in a currency table. That sure is possible with SQL 2000 but it MORE
easier with SQL 2005.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts
Sunday, March 11, 2012
Currency
hi,
i would like to write a sql function which takes 3 parameters.
1. Source currency type
2. destination currency type
3. Amount to be converted
I need the dynamic rates.
Does anybody hav any idea about how to go with this.
Thanks in advance,
Vinu
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1Are you using SQL Server 2005 ? Therefore you could use Webservices to
call an currency service synchronously or async. by storing the data
in a currency table. That sure is possible with SQL 2000 but it MORE
easier with SQL 2005.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
i would like to write a sql function which takes 3 parameters.
1. Source currency type
2. destination currency type
3. Amount to be converted
I need the dynamic rates.
Does anybody hav any idea about how to go with this.
Thanks in advance,
Vinu
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1Are you using SQL Server 2005 ? Therefore you could use Webservices to
call an currency service synchronously or async. by storing the data
in a currency table. That sure is possible with SQL 2000 but it MORE
easier with SQL 2005.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
Thursday, March 8, 2012
Culture problem with datepicker in report parameters
Hi,
on the server of a customer I determined the following problem: The customer
installed an English operating system (Windows server 2003) with English SQL
server 2005. I go from a German Client on a report about http://
<servername>/reports (report managers) to calendars in the report parameters
with German format of date as expected there. So far, so well. I turn into
however http:// more <servername>/reportserver on report, are indicated now
everything correctly in the report parameters on German represented indicate
(Tooltips, "Bericht anzeigen" (show report). etc.), only the calendar
strangely enough is in the English format of date. I have tested the same
configuration (likewise with English operating system and English Sql
server; german Client) on a virtual server, and can not reproduce the
problem here. Someone an idea, why I do not get the calendar at the customer
in accordance with the language settings of the client as expected?
Thanks and regards,
StefanHello Stefan,
I would like to know what's the server Regional Setting.
Also, please applied the latest service pack to your server and let me know
the result.
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.|||Hello Wei Lu,
the Regional Setting of the Server is German.
I will ask the customer, if they have installed the latest service pack. As
far as I know, they have installed SP2.
Thanks and regards,
Stefan Dirks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> schrieb im Newsbeitrag
news:PsMLICbnHHA.1140@.TK2MSFTNGHUB02.phx.gbl...
> Hello Stefan,
> I would like to know what's the server Regional Setting.
> Also, please applied the latest service pack to your server and let me
> know
> the result.
> 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.|||Hi Wei Lu,
the customer has installed SQL Reporting Services Version 9.00.3042.00.
It's strange that every reporting parameter (e.g. Tooltip) is in german
except for the calendar. Is there a possibility to set the
calendar-parameter explicit to german?
I tried to set the default language of the Reports to german/User!Language
but with no effect.
Thanks Stefan
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> schrieb im Newsbeitrag
news:6tvedcQoHHA.5168@.TK2MSFTNGHUB02.phx.gbl...
> 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.
>|||Hello Stefan,
This is a known issue in the reporting Services SP2. Product team is still
working on it. I will inform you the update if any progress.
Thank you!
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 Wei Lu,
thanks for this information. I use in the meantime a ReportViewer on a
aspx-Site as a workaround.
Thanks,
Stefan
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> schrieb im Newsbeitrag
news:39vfU9ooHHA.1428@.TK2MSFTNGHUB02.phx.gbl...
> Hello Stefan,
> This is a known issue in the reporting Services SP2. Product team is still
> working on it. I will inform you the update if any progress.
> Thank you!
>
> 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.
>
on the server of a customer I determined the following problem: The customer
installed an English operating system (Windows server 2003) with English SQL
server 2005. I go from a German Client on a report about http://
<servername>/reports (report managers) to calendars in the report parameters
with German format of date as expected there. So far, so well. I turn into
however http:// more <servername>/reportserver on report, are indicated now
everything correctly in the report parameters on German represented indicate
(Tooltips, "Bericht anzeigen" (show report). etc.), only the calendar
strangely enough is in the English format of date. I have tested the same
configuration (likewise with English operating system and English Sql
server; german Client) on a virtual server, and can not reproduce the
problem here. Someone an idea, why I do not get the calendar at the customer
in accordance with the language settings of the client as expected?
Thanks and regards,
StefanHello Stefan,
I would like to know what's the server Regional Setting.
Also, please applied the latest service pack to your server and let me know
the result.
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.|||Hello Wei Lu,
the Regional Setting of the Server is German.
I will ask the customer, if they have installed the latest service pack. As
far as I know, they have installed SP2.
Thanks and regards,
Stefan Dirks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> schrieb im Newsbeitrag
news:PsMLICbnHHA.1140@.TK2MSFTNGHUB02.phx.gbl...
> Hello Stefan,
> I would like to know what's the server Regional Setting.
> Also, please applied the latest service pack to your server and let me
> know
> the result.
> 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.|||Hi Wei Lu,
the customer has installed SQL Reporting Services Version 9.00.3042.00.
It's strange that every reporting parameter (e.g. Tooltip) is in german
except for the calendar. Is there a possibility to set the
calendar-parameter explicit to german?
I tried to set the default language of the Reports to german/User!Language
but with no effect.
Thanks Stefan
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> schrieb im Newsbeitrag
news:6tvedcQoHHA.5168@.TK2MSFTNGHUB02.phx.gbl...
> 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.
>|||Hello Stefan,
This is a known issue in the reporting Services SP2. Product team is still
working on it. I will inform you the update if any progress.
Thank you!
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 Wei Lu,
thanks for this information. I use in the meantime a ReportViewer on a
aspx-Site as a workaround.
Thanks,
Stefan
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> schrieb im Newsbeitrag
news:39vfU9ooHHA.1428@.TK2MSFTNGHUB02.phx.gbl...
> Hello Stefan,
> This is a known issue in the reporting Services SP2. Product team is still
> working on it. I will inform you the update if any progress.
> Thank you!
>
> 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.
>
Friday, February 17, 2012
CSV rendering is missing first detail row
For one report we've designed, an HTML rendering will produce 3 detail
records. When this same report with the same parameters is rendered in CSV,
the first detail row is missing from the output. All other aspects of the
export seem to work as expected.
This occurs with several reports we have but not all of them. This happens
when previewing in VS.NET, RS Manager, and on our live Web site. Other
formats do not drop the first detail record.
Is there any resolution to this problem?FYI: I experienced the same problem you described. Through trial and error I
determined that what was causing the problem was that I was grouping the
Details section of the Table. To work around this I added grouping to the SQL
code and removed grouping from the report detail.
Brad
"John Demar" wrote:
> For one report we've designed, an HTML rendering will produce 3 detail
> records. When this same report with the same parameters is rendered in CSV,
> the first detail row is missing from the output. All other aspects of the
> export seem to work as expected.
> This occurs with several reports we have but not all of them. This happens
> when previewing in VS.NET, RS Manager, and on our live Web site. Other
> formats do not drop the first detail record.
> Is there any resolution to this problem?
records. When this same report with the same parameters is rendered in CSV,
the first detail row is missing from the output. All other aspects of the
export seem to work as expected.
This occurs with several reports we have but not all of them. This happens
when previewing in VS.NET, RS Manager, and on our live Web site. Other
formats do not drop the first detail record.
Is there any resolution to this problem?FYI: I experienced the same problem you described. Through trial and error I
determined that what was causing the problem was that I was grouping the
Details section of the Table. To work around this I added grouping to the SQL
code and removed grouping from the report detail.
Brad
"John Demar" wrote:
> For one report we've designed, an HTML rendering will produce 3 detail
> records. When this same report with the same parameters is rendered in CSV,
> the first detail row is missing from the output. All other aspects of the
> export seem to work as expected.
> This occurs with several reports we have but not all of them. This happens
> when previewing in VS.NET, RS Manager, and on our live Web site. Other
> formats do not drop the first detail record.
> Is there any resolution to this problem?
CSV rendering is missing first detail row
For one report we've designed, an HTML rendering will produce 3 detail
records. When this same report with the same parameters is rendered in CSV,
the first detail row is missing from the output. All other aspects of the
export seem to work as expected.
This occurs with several reports we have but not all of them. This happens
when previewing in VS.NET, RS Manager, and on our live Web site. Other
formats do not drop the first detail record.
Any ideas? I can't seem to find anyone else that has run across this
problem in the groups.I continue to have this problem and cannot find any answers. Is there a
problem with the CSV rendering extension?
"John Demar" wrote:
> For one report we've designed, an HTML rendering will produce 3 detail
> records. When this same report with the same parameters is rendered in CSV,
> the first detail row is missing from the output. All other aspects of the
> export seem to work as expected.
> This occurs with several reports we have but not all of them. This happens
> when previewing in VS.NET, RS Manager, and on our live Web site. Other
> formats do not drop the first detail record.
> Any ideas? I can't seem to find anyone else that has run across this
> problem in the groups.
>|||John,
I am also seeing the same results with the missing first line. Does anyone
know if this is a known issue or just a setting that can be set?
"John Demar" wrote:
> I continue to have this problem and cannot find any answers. Is there a
> problem with the CSV rendering extension?
> "John Demar" wrote:
> > For one report we've designed, an HTML rendering will produce 3 detail
> > records. When this same report with the same parameters is rendered in CSV,
> > the first detail row is missing from the output. All other aspects of the
> > export seem to work as expected.
> >
> > This occurs with several reports we have but not all of them. This happens
> > when previewing in VS.NET, RS Manager, and on our live Web site. Other
> > formats do not drop the first detail record.
> >
> > Any ideas? I can't seem to find anyone else that has run across this
> > problem in the groups.
> >
records. When this same report with the same parameters is rendered in CSV,
the first detail row is missing from the output. All other aspects of the
export seem to work as expected.
This occurs with several reports we have but not all of them. This happens
when previewing in VS.NET, RS Manager, and on our live Web site. Other
formats do not drop the first detail record.
Any ideas? I can't seem to find anyone else that has run across this
problem in the groups.I continue to have this problem and cannot find any answers. Is there a
problem with the CSV rendering extension?
"John Demar" wrote:
> For one report we've designed, an HTML rendering will produce 3 detail
> records. When this same report with the same parameters is rendered in CSV,
> the first detail row is missing from the output. All other aspects of the
> export seem to work as expected.
> This occurs with several reports we have but not all of them. This happens
> when previewing in VS.NET, RS Manager, and on our live Web site. Other
> formats do not drop the first detail record.
> Any ideas? I can't seem to find anyone else that has run across this
> problem in the groups.
>|||John,
I am also seeing the same results with the missing first line. Does anyone
know if this is a known issue or just a setting that can be set?
"John Demar" wrote:
> I continue to have this problem and cannot find any answers. Is there a
> problem with the CSV rendering extension?
> "John Demar" wrote:
> > For one report we've designed, an HTML rendering will produce 3 detail
> > records. When this same report with the same parameters is rendered in CSV,
> > the first detail row is missing from the output. All other aspects of the
> > export seem to work as expected.
> >
> > This occurs with several reports we have but not all of them. This happens
> > when previewing in VS.NET, RS Manager, and on our live Web site. Other
> > formats do not drop the first detail record.
> >
> > Any ideas? I can't seem to find anyone else that has run across this
> > problem in the groups.
> >
Subscribe to:
Posts (Atom)