SSRS to PDF Blank Title 130560

system · June 6, 2014, 11:39am

Thanks Jose, that's what I needed. Got it working.

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, June 6, 2014 9:00 AM
Subject: Re: [Vantage] SSRS to PDF

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 #ygrps-yiv-162483116yiv5580174141 --

#ygrps-yiv-162483116yiv5580174141 .ygrps-yiv-162483116yiv5580174141ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141photo-title
a,
#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141photo-title a:active,
#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141photo-title a:hover,
#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141attach-table div.ygrps-yiv-162483116yiv5580174141attach-row {
clear:both;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141attach-table div.ygrps-yiv-162483116yiv5580174141attach-row div {
float:left;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141ygrp-file {
width:30px;}
#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141attach-table div.ygrps-yiv-162483116yiv5580174141attach-row div div a {
text-decoration:none;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141attach-table div.ygrps-yiv-162483116yiv5580174141attach-row div div span {
font-weight:normal;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 div.ygrps-yiv-162483116yiv5580174141ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-162483116
#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 #ygrps-yiv-162483116yiv5580174141 –
#ygrps-yiv-162483116yiv5580174141ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 #ygrps-yiv-162483116yiv5580174141ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 #ygrps-yiv-162483116yiv5580174141ygrp-mkp #ygrps-yiv-162483116yiv5580174141hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 #ygrps-yiv-162483116yiv5580174141ygrp-mkp #ygrps-yiv-162483116yiv5580174141ads {
margin-bottom:10px;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 #ygrps-yiv-162483116yiv5580174141ygrp-mkp .ygrps-yiv-162483116yiv5580174141ad {
padding:0 0;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 #ygrps-yiv-162483116yiv5580174141ygrp-mkp .ygrps-yiv-162483116yiv5580174141ad p {
margin:0;}

#ygrps-yiv-162483116 #ygrps-yiv-162483116yiv5580174141 #ygrps-yiv-162483116yiv5580174141ygrp-mkp .ygrps-yiv-162483116yiv5580174141ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-162483116

The tables that are generated are table_guid , table2_guid etc.. within the ssrs report there is dynamic sql such that

SELECT * FROM table_@param

where @param is the guid sent from the System Monitor. In order for you to run ssrs and then export it to PDF through the SSRS services you'll have to pass the table_guid param which you can get from the System Task table.

Thanks!

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Jun 6, 2014 at 8:44 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div>Has anyone successfully attached a PDF to an email using generate on a SSRS report style with button click?<br clear="none"><br clear="none">In the SysRptLst a record is created when generating the report and the FileName field is populated with something like: REPORT DATABASE: 4bf03476b11b41b2bdc0d6d8be4a695b<br clear="none">

I see in my SSRS database where it is pulling the information for the report it creates new tables that end with the same GUID as in the FileName field.

How do these tables interact with a SSRS report as far as knowing how to relate the tables, or is there a file created on the server somewhere I can use, similar to how crystal worked where a XML is created and that has all the table relationships.

Thanks for any insight,

Ted

</div> <div style="color:#fff;min-height:0;"></div>

system · June 6, 2014, 8:44am

Has anyone successfully attached a PDF to an email using generate on a SSRS report style with button click?

In the SysRptLst a record is created when generating the report and the FileName field is populated with something like: REPORT DATABASE: 4bf03476b11b41b2bdc0d6d8be4a695b

I see in my SSRS database where it is pulling the information for the report it creates new tables that end with the same GUID as in the FileName field.

How do these tables interact with a SSRS report as far as knowing how to relate the tables, or is there a file created on the server somewhere I can use, similar to how crystal worked where a XML is created and that has all the table relationships.

Thanks for any insight,

Ted

system · June 6, 2014, 9:01am

The tables that are generated are table_guid , table2_guid etc.. within the ssrs report there is dynamic sql such thatÂ

SELECT * FROM table_@paramÂ