Localization

Dear friends,

Is there any provision to make the SQL Server Reporting Services commands,returning from SQL query, instead of writing that directly in the report.

Best Regards,

Baburaj

YOu could either use stored procedures to decide on which query to execute or could code your own data provider within Reporting services which is able to pass just the data from any client application to the report, see this link here for more information:

http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=b8468707-56ef-4864-ac51-d83fc3273fe5

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Dear Friend/s,

The above thread was quite useful. Is there a provision to , put the code(for localization) in an SQL Query, so that the data displayed in the Report will be shown localized? The localized word lies in an XML file in the Machine. Currently I can, use that code from the Report, so that the words will get localized. But I need to include the Code as the Output of the SQL Query

Thanks and Regards,

Baburaj

|||NO, SQL Server Reporting services coding is very restricted. YOu won′t be able to access the file to do the localization, you will have to provide the information within your query results.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Localization

Dear friends,

Is there any provision to make the SQL Server Reporting Services commands,returning from SQL query, instead of writing that directly in the report.

Best Regards,

Baburaj

YOu could either use stored procedures to decide on which query to execute or could code your own data provider within Reporting services which is able to pass just the data from any client application to the report, see this link here for more information:

http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=b8468707-56ef-4864-ac51-d83fc3273fe5

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Dear Friend/s,

The above thread was quite useful. Is there a provision to , put the code(for localization) in an SQL Query, so that the data displayed in the Report will be shown localized? The localized word lies in an XML file in the Machine. Currently I can, use that code from the Report, so that the words will get localized. But I need to include the Code as the Output of the SQL Query

Thanks and Regards,

Baburaj

|||NO, SQL Server Reporting services coding is very restricted. YOu won′t be able to access the file to do the localization, you will have to provide the information within your query results.

Jens K. Suessmeyer

http://www.sqlserver2005.de

localhost

i have a path line in my code, now, i have in the path \\"computername"\sharename\... what i need to do is instead of the "computername", i need to put a variable there to pick the localhost name where the code is runing on.If you're not running a named instance, you could use
declare @.path varchar(255)
select @.path = @.@.servername + '\\sharename'
select @.path
"IT" <anonymous@.discussions.microsoft.com> wrote in message
news:25BA2799-65BB-467A-8F46-39F732B0FB36@.microsoft.com...
> i have a path line in my code, now, i have in the path
\\"computername"\sharename\... what i need to do is instead of the
"computername", i need to put a variable there to pick the localhost name
where the code is runing on.|||SQL Server should handle the word localhost and/or (local) for the server name. Did you try that? If
you want to extract the machine name, you can use the SERVERPROPERTY function (read about it in
Books Online).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"IT" <anonymous@.discussions.microsoft.com> wrote in message
news:25BA2799-65BB-467A-8F46-39F732B0FB36@.microsoft.com...
> i have a path line in my code, now, i have in the path \\"computername"\sharename\... what i need
to do is instead of the "computername", i need to put a variable there to pick the localhost name
where the code is runing on.

localhost

i have a path line in my code, now, i have in the path \\"computername"\shar
ename\... what i need to do is instead of the "computername", i need to put
a variable there to pick the localhost name where the code is runing on.If you're not running a named instance, you could use
declare @.path varchar(255)
select @.path = @.@.servername + '\\sharename'
select @.path
"IT" <anonymous@.discussions.microsoft.com> wrote in message
news:25BA2799-65BB-467A-8F46-39F732B0FB36@.microsoft.com...

quote:

---

> i have a path line in my code, now, i have in the path

---

\\"computername"\sharename\... what i need to do is instead of the
"computername", i need to put a variable there to pick the localhost name
where the code is runing on.|||SQL Server should handle the word localhost and/or (local) for the server na
me. Did you try that? If
you want to extract the machine name, you can use the SERVERPROPERTY functio
n (read about it in
Books Online).
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"IT" <anonymous@.discussions.microsoft.com> wrote in message
news:25BA2799-65BB-467A-8F46-39F732B0FB36@.microsoft.com...

quote:

---

> i have a path line in my code, now, i have in the path \\"computername"\sharename\... what
i need

---

to do is instead of the "computername", i need to put a variable there to pi
ck the localhost name
where the code is runing on.