Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Management - Level 9 in the Stairway to Reporting Services Expand / Collapse
Author
Message
Posted Wednesday, May 23, 2012 12:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 31, 2014 2:13 PM
Points: 8, Visits: 345
Comments posted to this topic are about the item Management - Level 9 in the Stairway to Reporting Services
Post #1304700
Posted Wednesday, May 23, 2012 12:36 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 10:46 AM
Points: 2,105, Visits: 560
Hi Jessica,

Thank you for putting all this information into one place - you have helped me a whole lot, and I'm sure plenty of other folks have benefited.

Congratulations on a job well done

Tom


Tom in Sacramento

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1305273
Posted Thursday, May 24, 2012 8:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 24, 2012 8:08 PM
Points: 1, Visits: 0

2012 comes, in order to thank everyone, characteristic, novel style, varieties, low price and good quality, and the low sale price. Thank everyone Welcome to

===== http://www.clothes6.org ====

Air jordan(1-24)shoes $30

Handbags(Coach l v f e n d i d&g) $30

Tshirts (Polo ,ed hardy,lacoste) $15

Jean(True Religion,ed hardy,coogi) $30

Sunglasses(Oakey,coach,gucci,A r m a i n i) $15

New era cap $12

Bikini (Ed hardy,polo) $20

===== http://www.clothes6.org/ ====

===== http://www.clothes6.org/ ====
Post #1306274
Posted Friday, May 25, 2012 5:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 25, 2012 5:57 PM
Points: 1, Visits: 0

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====


$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest


==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====


==== ( http://www.scnshop.com ) =====


Post #1306869
Posted Friday, June 01, 2012 6:18 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:59 AM
Points: 411, Visits: 1,394
One thing I see hardly addressed in SSRS is translations. i.e. provide the same data to different users in the same layout but all fixed texts on the report are changed into the users' preferred language. The way most people seem to go at this is to write a copy of the same report for each language and have the end user select the report in their language. There surely must be better ways to do this if the only thing that changes between the copies is the text on the labels, captions and fixed text boxes, plus the format of the dates and numbers. Can anyone of you more experienced SSRS developers share your opinions/knowledge on this topic too?

I've seen so far some examples that employ a CLR routine included in the report to lookup from a resource the translation for each text value. But since we've already got a data source, I would much rather retrieve the translations from the db and replace all fixed texts on-the-fly just before rendering the document.

I'd especially like to see some solution that -just before rendering the output document- automatically finds all texts from the report definition (rdl?), passes those texts to a procedure in the database (as an xml?), retrieves all translations available and then for each translation found replaces the fixed text by the translated text, to then have a document rendered in which all labels, header and footer texts, captions, etc. are in the end-users' language of choice. All from one and the same report definition. This scenario has some big advantages: for example we need to test the document only once to see that the report is functionally correct and need not redo it all again after yet another translation is added/changed. Same for deployment onto various environments, it only needs to be done once per environment. And no longer do we need to wait for all languages "official" translations to arrive before we can start developing, testing or even deploying the report...

Here's an excellent blog by Brian Welcker close to what I intend to get to. The main thing this solution still lacks however is finding all texts from the report definition and replace them automatically. Does anyone have some (links to) examples on how this can be done?




Posting Data Etiquette - Jeff Moden
Posting Performance Based Questions - Gail Shaw
Hidden RBAR - Jeff Moden
Cross Tabs and Pivots - Jeff Moden
Catch-all queries - Gail Shaw


If you don't have time to do it right, when will you have time to do it over?
Post #1309689
Posted Monday, April 08, 2013 12:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:27 AM
Points: 1, Visits: 49
Great job on this 9 step program!
Is the source code available anywhere???

much appreciated...
D@veE
Post #1439980
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse