How can I achieve this

Hi,
I created a report to display in invoice when passed an invoice number. How
can I display multiple invoices when i pass either a date range? I am not
sure how to get multiple invoices, one after the other on different page.
ThanksOn Jun 2, 12:53 pm, Chris <C...@.discussions.microsoft.com> wrote:
> Hi,
> I created a report to display in invoice when passed an invoice number. How
> can I display multiple invoices when i pass either a date range? I am not
> sure how to get multiple invoices, one after the other on different page.
> Thanks
There are a few different options here. You can use a subreport that
will automatically print out on different pages or you can use a table/
matrix control and group on invoice number and right-click the control
-> select Properties -> select the Groups tab -> select Edit... -> and
select 'Page break at end.' Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

How can i achieve the functionality of External Procedure Transformation(Informatica) in SSIS

Hi,

I worked with informatica before and bit new to SSIS,

i have one simple question..

How can i achieve the same functionality as External Procedure Transformation (Informatica) in SSIS?

like..i want to use a DLL in my package which contains some set of business rules.

Please let me know.

Charles

Charles Luke wrote:

Hi,

I worked with informatica before and bit new to SSIS,

i have one simple question..

How can i achieve the same functionality as External Procedure Transformation (Informatica) in SSIS?

like..i want to use a DLL in my package which contains some set of business rules.

Please let me know.

Charles

Charles,

Its possible to build your own custom tasks and compoenents that implement whatever business rules you require. Go here in BOL for more info:

Integration Services Developer InfoCenter
(http://msdn2.microsoft.com/en-us/library/ms137709.aspx)

You may also wish to look at using the script component and script task. They also enable you to incorporate your own business rules however they are not as portable as custom tasks or custom components. But they ARE easier to build than custom tasks/components.

-Jamie

How can i achieve the functionality of External Procedure Transformation(Informatica) in SSI

Hi,

I worked with informatica before and bit new to SSIS,

i have one simple question..

How can i achieve the same functionality as External Procedure Transformation (Informatica) in SSIS?

like..i want to use a DLL in my package which contains some set of business rules.

Please let me know.

Charles

Charles Luke wrote:

Hi,

I worked with informatica before and bit new to SSIS,

i have one simple question..

How can i achieve the same functionality as External Procedure Transformation (Informatica) in SSIS?

like..i want to use a DLL in my package which contains some set of business rules.

Please let me know.

Charles

Charles,

Its possible to build your own custom tasks and compoenents that implement whatever business rules you require. Go here in BOL for more info:

Integration Services Developer InfoCenter
(http://msdn2.microsoft.com/en-us/library/ms137709.aspx)

You may also wish to look at using the script component and script task. They also enable you to incorporate your own business rules however they are not as portable as custom tasks or custom components. But they ARE easier to build than custom tasks/components.

-Jamie