How to attach some extra PDF document into my report

I neet to attach ( embed ) some extra documents end of my quote form
conditionaly by Quote Products
please help :-)On Apr 18, 11:00 am, ilker tiryaki
<ilkertiry...@.discussions.microsoft.com> wrote:
> I neet to attach ( embed ) some extra documents end of my quote form
> conditionaly by Quote Products
> please help :-)
As far as I know, the only way to do this would be via an image
control; however, this would add a lot of size to the report, etc. The
best way to handle this is to access the PDF, etc from a custom web
application that also has access to the Report Server. Sorry I could
not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

How to append a new values like uniqueidentifiers, sequence numbers to data flow?

Hi,

I would like to know different possible ways in appending extra values like new uniqueidentifiers, sequence numbers, random number. Can you please tell what type of data flow components helps us ?

Append what to where? Do you want to add new columns with such vaues to a path within the data flow task?

Derived Column Transform?

Script Transform?

Row Number Transform ? (http://www.sqlis.com/default.aspx?77)

|||

yes..i want to append values to a path with in the data flow task.

If i use Derived Column Transformation, how can i generate uniqueidentifiers and sequence numbers for each row?

Thanks

Gopi

|||

For GUIDs you would need to use the script task, as there is no "New Guid" function in the expression syntax.

For sequence numbers or row numbers I assume, then again the script task is required. For an easier life you can use the cunningly named Row Number Transform I mentioned previously, which does just that, and comes as a simple MSI to install.

|||

Darren,

Thank you very much.

sql

how to add extra columns to a report that are not in select query or stored proc

Hi,

I am new to reporting.I have 10 columns coming from the sql query.I need to add 2 more columns to the same report.These 2 columns come from the values the user selected in the dropdownlist on a webpage(From where we are calling the Report).How to add these columns to the report from the webpage.Please guide me.

in the textbox use

=Parameters!parameterName.Value

|||

you create input parameters and supply the value when the rpt is launched from the web, then in the text box u place the i/p paramter inst of keeping the table field