Do you have replication enabled on your target database ?

Sorry but your english is difficult to understand 🙂

Can you post a screenshot of your report layout ?

And the expression you use to display/hide the logo on your header ?

Please.

hi

Is your table inside a rectangle ?

Did you set the property KeepTogether to True ?

If so then try to put it False on all data region

This will permit the pagination...

Hi Angie

What is the expression you used for the rowvisibility ?

Is the format changed between the 2 executions ?

I mean a xls in order of an xlsx or vice versa... or maybe a csv?

Thank you for posting the code

I have another question.

Are you sure your query source does not have duplicate lines on the salesorderid ?

Hi

Sorry I don't get it clearly.

What do you want to do with your header?

Hidding it on the second page?

Hi Paul

Can you post the sql code source entry

and the structure of the destination table ?

Please.

hi

did you check if a sheet is hidden on your excel file ?

Hi

Maybe it is due to the cache ?

Did you try restarting the SSIS Services ?

Hi

Did you put the property IsSorted to True ?

The syntax is

Lookup(source_expression, destination_expression, result_expression, dataset)

In your case :

Lookup("ID" & Fields!Field2.Value,Fields!AcctNUmber.Value,Fields!AcctName.value, "AcctNames")

Where Field2 refers to the field in the main dataset

You have to put this expression on the main...

Hi

The Switch syntax is

Switch(Expression1, Value1, Expression2, Value2,...,Default Value)

I think you missed the value after each of your expressions.

Do you use 2008 or 2008R2 ?

If yes you can use the lookup function.

It will be lot easier to use a domain account

Then give the permission to the folder or shared folder

To do this you need to change the account whom is running...