Взаимодействие с отчетами SSRS с помощью гиперссылок

Передача значений параметров в теле гиперссылок

В отчетах SSRS можно передавать значения параметров непосредственно в теле гиперссылок, что очень удобно.

Весь подсвеченный код должен записываться в одну строку, здесь он разбит на несколько строк только ради удобства чтения.

В общем виде ссылка на отчет будет выглядеть следующим образом:

http://server/reportserver?/Subdir/Report+name&
rs:Command=Render¶m1=value1¶m2=value2

Если параметр – multi-value, то ему можно передать несколько значений:

http://server/reportserver?/Subdir/Report+name&
rs:Command=Render¶m1=value1¶m1=value2

Сразу оговорюсь, что по умолчанию веб-морда SSRS, которая крутится на SSIS висит по адресу http://server/reports, из нее ссылки на репорты брать не нужно, параметры передать не получится. Структуру папок на сервере можно посмотреть по линку http://server/reportserver, там лежат правильные ссылки на репорты.

Открытие целевого отчета, передав в качестве значений параметров содержимое ячеек исходного отчета

Когда возникает необходимость открыть один отчет из другого, передав целевому отчету содержимое какой либо ячейки в качестве значения параметра, мне нравится делать так, чтобы целевой отчет открывался в новом окне.
Правый клик по ячейке, которая наполняется значениями из источника данных:

В открывшемся диалоговом окне на вкладке Action нужно выбрать пункт “Go to URL” и кликнуть по кнопке Fx.

Откроется Genric Query Designer, в окне которого нужно ввести код аналогичный представленном ниже.

="javascript:void(window.open('http://server/reportserver?/Subdir/Report+name&
rs:Command=Render¶m1=" & Fields!Field_1.Value "&
param2=" & Fields!Field_2.Value & "','_blank'))"

Выгрузка отчета в формат по выбору без предварительного рендеринга в HTML коде

Если нет необходимости работать с отчетом через веб-интерфейс, можно сразу выгрузить его с сервера репортов в формате по выбору: HTML3.2, HTML4.0, MHTML, IMAGE, EXCEL, WORD, CSV, PDF, XML. Особую ценность, на мой взгляд, представляют форматы CSV, Excel и XML, а для любителей красивых картинок можно использовать и PDF 🙂

Для этого достаточно использовать параметр rs:Format, передав ему имя формата, в который нужно экспортировать отчет:

http://server/reportserver?/Subdir/Report+name&
rs:Command=Render&rs:Format=Excel¶m1=value1¶m2=value2

Относительно разнообразных служебных параметров можно почитать на MSDN: http://msdn.microsoft.com/en-us/library/ms152835.aspx

Эту замечательную фичу можно использовать, чтобы интегрировать отчеты SSRS с какими-либо бизнес приложениями.

На данный момент в SSRS отправка пользователям отчетов по расписанию реализована с помощью сервиса подписок, при всех достоинствах этого метода, у него есть один недостаток – невозможность задать произвольное имя файлу отчета. Дополнительный бонус решения, описанного выше, – возможность сформировать отчет, сохранить его под любым именем и доставить его пользователю с помощью пакета SSIS.

Dim ReportURL, ReportName As String 
ReportName = Dts.Variables("VbReportName").Value.ToString +"_" +Date(Now()) 
Dim SaveToPath As String = "\\DestinationFolder\ReportName + ".xls" 
ReportURL = "http://server/ReportServer?/reportname&rs:Command=Render&rs:Format=EXCEL" 
SaveFile(ReportURL, SaveToPath) 
Dts.Variables("VbReportName").Value = SaveToPath

Ссылки:
Префиксы параметров в ссылках на отчеты SSRS: http://msdn.microsoft.com/en-us/library/ms153579.aspx
Описание различных служебных параметров: http://msdn.microsoft.com/en-us/library/ms152835.aspx

Запись опубликована в рубрике Business Intelligence с метками , , . Добавьте в закладки постоянную ссылку.

64 Responses to Взаимодействие с отчетами SSRS с помощью гиперссылок

  1. Marine Radio пишет:

    Great amazing issues here. I am very happy to peer your article. Thank you a lot and i’m having a look ahead to contact you. Will you kindly drop me a mail?

  2. Exterior Home Design пишет:

    magnificent post, very informative. I ponder why the other specialists of this sector don’t realize this. You must continue your writing. I am sure, you’ve a great readers’ base already!

  3. Online Courses пишет:

    Hello very nice site!! Man .. Beautiful .. Wonderful .. I’ll bookmark your blog and take the feeds also¡KI am glad to search out numerous useful info here in the put up, we’d like work out extra strategies in this regard, thank you for sharing. . . . . .

  4. Thanks a lot for sharing this with all of us you really realize what you’re speaking about! Bookmarked. Please additionally discuss with my web site =). We will have a link trade agreement among us!

  5. Fitted Kitchens пишет:

    Hello.This post was extremely fascinating, especially since I was browsing for thoughts on this issue last Monday.

  6. travel book пишет:

    Wow! Thank you! I continuously wanted to write on my website something like that. Can I take a fragment of your post to my website?

  7. Exercise Machines пишет:

    Needed to post you that very little note to finally give thanks as before for all the breathtaking principles you have provided here. This has been simply tremendously open-handed of you to grant extensively just what many people could have marketed for an e-book in order to make some bucks for themselves, mostly seeing that you could possibly have tried it if you ever wanted. The good ideas likewise acted to be a fantastic way to fully grasp that the rest have a similar dreams much like mine to find out much more related to this matter. I am sure there are several more fun sessions up front for those who examine your site.

  8. Kitchen Tables пишет:

    Needed to draft you a little note to say thanks a lot once again with the breathtaking methods you have shared in this case. This is unbelievably generous of people like you in giving extensively all that a lot of folks would’ve made available for an ebook in making some cash for themselves, mostly since you could have done it in the event you decided. These principles likewise served to become fantastic way to fully grasp someone else have the identical zeal much like my very own to figure out significantly more related to this matter. I’m certain there are thousands of more pleasurable situations in the future for many who start reading your blog.

  9. Cardiology Doctors пишет:

    I enjoy you because of each of your efforts on this web page. Kim takes pleasure in conducting internet research and it’s easy to see why. Most of us notice all of the dynamic manner you create vital guidelines by means of this web blog and therefore foster contribution from the others about this content while our favorite child is without a doubt discovering so much. Have fun with the rest of the new year. You are always conducting a first class job.

  10. Reading Tablets пишет:

    whoah this weblog is great i like studying your articles. Stay up the good work! You understand, a lot of persons are hunting around for this info, you can help them greatly.

  11. Immune Support пишет:

    naturally like your web site but you have to test the spelling on quite a few of your posts. Many of them are rife with spelling problems and I in finding it very troublesome to inform the truth on the other hand I¡¦ll surely come again again.

  12. Online Masters Degree пишет:

    Wow, incredible weblog layout! How lengthy have you been running a blog for? you made running a blog look easy. The full look of your web site is magnificent, as well as the content!

  13. Best Mutual Funds пишет:

    Very efficiently written information. It will be beneficial to anyone who usess it, as well as me. Keep doing what you are doing – for sure i will check out more posts.

  14. Email Newsletter пишет:

    Thank you a lot for sharing this with all of us you actually understand what you’re talking about! Bookmarked. Kindly also seek advice from my site =). We will have a link exchange agreement between us!

  15. Inch Wheels пишет:

    I simply wished to thank you very much all over again. I am not sure the things that I could possibly have handled without these tips provided by you over that area of interest. It previously was a real frustrating case in my view, but noticing the specialised mode you dealt with the issue took me to leap with delight. Now i’m happy for your advice and in addition wish you recognize what a great job you are carrying out educating many others by way of your blog post. Probably you haven’t got to know all of us.

  16. Great ¡V I should definitely pronounce, impressed with your web site. I had no trouble navigating through all the tabs and related information ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your client to communicate. Excellent task..

  17. Brake Service пишет:

    I am now not certain the place you are getting your information, however great topic. I must spend a while studying more or working out more. Thanks for magnificent info I was on the lookout for this info for my mission.

  18. Home Prices пишет:

    I loved as much as you’ll receive carried out right here. The sketch is tasteful, your authored material stylish. nonetheless, you command get bought an shakiness over that you wish be delivering the following. unwell unquestionably come more formerly again since exactly the same nearly very often inside case you shield this hike.

  19. Kitchen Doors пишет:

    I would like to thank you for the efforts you have put in writing this site. I’m hoping the same high-grade site post from you in the upcoming as well. In fact your creative writing abilities has inspired me to get my own blog now. Actually the blogging is spreading its wings quickly. Your write up is a great example of it.

  20. I Mac пишет:

    Hi there, You’ve done a great job. I will certainly digg it and personally recommend to my friends. I’m confident they’ll be benefited from this web site.

  21. Software Sale пишет:

    There is clearly a lot to realize about this. I believe you made some nice points in features also.

  22. I just wanted to send a comment in order to express gratitude to you for all the awesome tactics you are writing on this website. My considerable internet search has now been recognized with excellent knowledge to exchange with my company. I ‘d point out that many of us website visitors actually are quite endowed to be in a very good network with very many perfect people with very helpful plans. I feel rather lucky to have seen your entire webpage and look forward to some more fabulous moments reading here. Thanks once more for everything.

  23. You made some decent points there. I did a search on the subject and found most guys will consent with your website.

  24. Nutrition Shakes пишет:

    Simply wish to say your article is as surprising. The clarity in your post is just spectacular and i could assume you’re an expert on this subject. Well with your permission let me to grab your feed to keep up to date with forthcoming post. Thanks a million and please keep up the rewarding work.

  25. House Appraisal пишет:

    fantastic issues altogether, you just gained a new reader. What might you recommend about your submit that you just made a few days ago? Any positive?

  26. Realty Lawyer пишет:

    I as well as my friends ended up viewing the excellent thoughts on your site while all of a sudden I got a terrible suspicion I never expressed respect to the web blog owner for those strategies. The young boys ended up warmed to study them and have in effect truly been tapping into them. Appreciate your really being indeed considerate and then for obtaining variety of superb subjects most people are really wanting to learn about. My honest apologies for not expressing gratitude to you sooner.

  27. Branding Agency пишет:

    Hey very nice website!! Man .. Beautiful .. Amazing .. I will bookmark your web site and take the feeds also¡KI’m satisfied to seek out so many useful info right here within the publish, we need work out extra strategies in this regard, thank you for sharing. . . . . .

  28. Smart Car пишет:

    As a Newbie, I am continuously browsing online for articles that can benefit me. Thank you

  29. Government Auctions пишет:

    My wife and i have been glad Chris managed to finish off his studies through the ideas he had using your web site. It’s not at all simplistic to simply be giving freely helpful tips which usually people today may have been making money from. We really discover we have got the blog owner to appreciate because of that. Most of the illustrations you have made, the straightforward website menu, the friendships you can assist to engender – it is most overwhelming, and it is letting our son and the family do think the content is excellent, and that’s exceedingly essential. Thank you for all!

  30. Bamboo Flooring пишет:

    I wish to show some appreciation to you just for bailing me out of this crisis. After exploring through the the web and coming across opinions which are not pleasant, I thought my entire life was over. Living without the presence of answers to the problems you have fixed as a result of your entire guide is a critical case, and the kind that could have badly affected my entire career if I had not discovered the website. Your own expertise and kindness in touching the whole thing was precious. I am not sure what I would’ve done if I had not discovered such a point like this. I can also at this moment look forward to my future. Thanks very much for your reliable and effective help. I won’t be reluctant to refer your web blog to any person who needs guide about this situation.

  31. Musical Colleges пишет:

    I like what you guys are up too. Such intelligent work and reporting! Keep up the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my web site 🙂

  32. Liver Cancer пишет:

    Good blog! I really love how it is simple on my eyes and the data are well written. I am wondering how I could be notified whenever a new post has been made. I have subscribed to your feed which must do the trick! Have a nice day!

  33. I simply wanted to appreciate you all over again. I’m not certain the things I might have worked on without the tips contributed by you on this concern. Entirely was the scary scenario in my opinion, but seeing the very skilled tactic you handled that took me to cry over joy. I am grateful for your advice and in addition trust you comprehend what a great job you have been undertaking training the mediocre ones using your web blog. I know that you haven’t come across any of us.

  34. Weight Loss Drops пишет:

    Generally I don’t learn article on blogs, but I would like to say that this write-up very forced me to take a look at and do it! Your writing taste has been surprised me. Thank you, quite great article.

  35. Auto Body Repair пишет:

    You made various good points there. I did a search on the subject matter and found a good number of folks will consent with your blog.

  36. Bookkeeping пишет:

    I have to show my passion for your generosity in support of those who must have guidance on this one study. Your very own commitment to passing the message across was especially productive and have consistently permitted others like me to realize their ambitions. Your new informative help means a great deal to me and substantially more to my office colleagues. Many thanks; from each one of us.

  37. Budget Planning пишет:

    Wow! This could be one particular of the most beneficial blogs We’ve ever arrive across on this subject. Actually Wonderful. I’m also an expert in this topic therefore I can understand your effort.

  38. Student Loans пишет:

    fantastic issues altogether, you just gained a new reader. What may you recommend in regards to your submit that you simply made some days in the past? Any certain?

  39. very care about my situation.

  40. Andreweneni пишет:

    Есть такая услуга – добровольное медицинское обслуживание (или ДМО).
    Она предполагает, что пациент платит небольшую сумму за абонемент и ходит на прием в течение года бесплатно.
    Однако опросы показали, что лишь 3% жителей Питера знают о такой услуге.
    Почему так происходит?
    Да потому что клиникам намного выгодней брать плату за каждое посещение.
    А если какой-нибудь сотрудник клиники попытается рассказать про добровольное медицинское обслуживание клиенту – это сулит ему увольнением.
    Эта информация уже вызвала много возмущений, сразу после того как информацию об этом рассекретил один возмущенный врач.
    Его уволили “по собственному желанию”, после того, как он посоветовал ДМО постоянному клиенту.
    Самое ужасное, что официальные положения по ДМО присутствуют в открытом доступе, просто натыкались на эту информацию только случайные люди.
    Как отстоять свои права?
    О правилах предоставления такой услуги и обязанностях частных клиник можно узнать, сделав запрос в Яндексе: “добровольное медицинское обслуживание”.
    Именно обслуживание, а не страхование.

    34j5c6h86

  41. Patrickidest пишет:

    Недостаточно тревожиться о самочувствии родного ребенка – нужно делать решительные действия для его защиты. Притом поручить данный вопрос нужно исключительно опытным проверенным врачам.
    На сегодняшний день помощь индивидуального доктора по карману далеко не многим жителям России. А отправляться по каждому вопросу в поликлинику, отстаивать долгие очереди и подвергать малыша вероятности заразиться вирусами от других детей – тоже не вариант.
    К счастью, разные частные клиники предлагают программу Детского Добровольного Медицинского Обслуживания (ДМО), которая даёт возможность за несущественную сумму денег получить полис на одногодичное обслуживание у докторов.
    К сожалению, не многие осведомлены о такой услуге и продолжают лечиться народными методиками, выжидают часами в очередях и переплачивают за приемы частных педиатров.
    А программа Добровольного Медицинского Обслуживания для детей позволяет:
    ” Бесплатно получить больничный лист по уходу за ребенком;
    ” Бесплатно обследоваться у индивидуальных врачей педиатров;
    ” Бесплатно или со скидкой осуществлять лечебные процедуры и диагностику;
    ” Лечить ребенка своевременно, качественно и без очередей.
    Чтобы ознакомиться со списком клиник и условиями оказания услуг нужно вбить в поиск Яндекса или Google фразу: “Добровольное Медицинское Обслуживание”. После этого следует найти приглянувшуюся клинику и оформить договор.

    34j5c6h87

  42. kliknij strone пишет:

    Very clean web site , thanks for this post.

  43. Mobile phone пишет:

    provides products from different brands!

  44. link пишет:

    woh I love your articles , saved to my bookmarks ! .

  45. kliknij strone пишет:

    Can I simply say what a relief to search out somebody who truly knows what theyre talking about on the internet. You undoubtedly know learn how to convey a problem to gentle and make it important. More folks have to learn this and perceive this aspect of the story. I cant consider youre not more fashionable because you positively have the gift.

  46. Aliceidear пишет:

    нажимной гарнитур для дверей пвх
    как регулируется балконная дверь

    http://domadvershpingalet.icu

    ручка для деревянной балконной двери
    купить фурнитуру для пвх дверей
    двери межкомнатные купе установка

  47. Bilannonser пишет:

    The following time I read a weblog, I hope that it doesnt disappoint me as much as this one. I imply, I know it was my choice to read, however I truly thought youd have something fascinating to say. All I hear is a bunch of whining about one thing that you would repair if you happen to werent too busy in search of attention.

  48. kliknij tutaj пишет:

    I believe this internet site has got some rattling excellent information for everyone : D.

  49. CharlesLiX пишет:

    hOur company offers a wide variety of non prescription products. Look at our health site in case you want to look better with a help of health products. Our company offers herb-based supplements. Look at our health contributing portal in case you want to look healthier. Our company provides a wide variety of non prescription drugs. Visit our health website in case you want to look healthier with a help generic supplements. Our company offers supreme quality supplements. Visit our health contributing site in case you want to improve your health. Our company provides a wide variety of non prescription products. Take a look at our health site in case you want to strengthen your health with a help of general health products. Our company provides a wide variety of non prescription drugs. Look at our health portal in case you want to look better with a help of general health products.
    Our site offers a wide variety of non prescription drugs. Look at our health website in case you want to look better with a help of health products. Our company provides generic supplements. Visit our health contributing website in case you want to look better. Our company offers a wide variety of non prescription drugs. Take a look at our health site in case you want to feel better with a help of health products. Our company provides a wide variety of non prescription drugs. Visit our health portal in case you want to to feel healthier with a help of health products. Our company provides health and related products. Visit our health contributing website in case you want to look healthier.

  50. home and family пишет:

    Hello. magnificent job. I did not anticipate this. This is a great story. Thanks!

  51. Mikrokamera Wynajem пишет:

    I used to be more than happy to seek out this internet-site.I wanted to thanks to your time for this excellent learn!! I positively enjoying each little bit of it and I have you bookmarked to take a look at new stuff you blog post.

  52. polubilem to пишет:

    The subsequent time I learn a blog, I hope that it doesnt disappoint me as much as this one. I mean, I do know it was my choice to learn, but I truly thought youd have one thing interesting to say. All I hear is a bunch of whining about one thing that you could repair should you werent too busy searching for attention.

  53. arkadiusz nagiec пишет:

    It’s onerous to find educated individuals on this matter, however you sound like you already know what you’re talking about! Thanks

Добавить комментарий для Marine Radio Отменить ответ

Ваш e-mail не будет опубликован. Обязательные поля помечены *