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

Loads of System Generated Procedures In publisher

Dear Friends,
I have a database which is a published for 3 subscriber with bit of
variations. now while checking i found that there are 8870 system generated
procedures in the database with name.
ap_sel_0394BA4C0A144B4DB88E9E00ED0446B3_pal or similar way.
please suggest do i need the same.
Can i clean this? How?
Best regards
Sharad
Dear Paul,
Thanks. You have guide me several times i salute you for the knowledge you
have.
now with the query you have given i got the results of 56 rows but there are
8000+ procedure do i need to delete the rest.
Thanks and best regards
Sharad.
"Sharad2005" wrote:

> Dear Friends,
> I have a database which is a published for 3 subscriber with bit of
> variations. now while checking i found that there are 8870 system generated
> procedures in the database with name.
> ap_sel_0394BA4C0A144B4DB88E9E00ED0446B3_pal or similar way.
> please suggest do i need the same.
> Can i clean this? How?
> Best regards
> Sharad