Hi,

Try this .. This really works

=MONTHNAME(LEFT(format(now(),"MM-dd-yyyy"),2)) & " " & RIGHT(LEFT(format(now(),"MM-dd-yyyy"),5),2) & ", " & RIGHT(format(now(),"MM-dd-yyyy"),4)

hi,

Try script component between excel source and database destination.

In script component use a function , if '-' then null.

insert the column into database as null value..

Hi,

just give fixed no of rows for a page.. Say for example 25 records per page

=ceiling(RowNumber(nothing)/25), then

in border style property , give the expression

=iif(rownumber(nothing) = 25,"Solid","Dotted").

check your post in...

Hi,

ur expression

= RunningValue(Field!Orderamt.value,Sum,Nothing)

is correct.. confirm me about your calculated field RTTP?? i couldnt understand ur point..

Hi,

please make ur question more clear.. so that ll try to help u...

i understood that u want to find the last record for the current page in ur report ???...

Hi,

Try this link

http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx

in ssis, insert script component as transformation between ur source and destination.

if u know C# or vb.net/vb.. u can write ur own code...

Hi,

Try Log event in SSIS...

u also use script component to write logs...

dim x(0) as byte

ME.LOG("MESSAGE",0,x)

Hi,

check the attached image for your reference.

Hi,

Congrats

Hi,

i understood that u wanna get distinct order id and its records huh?

u mean ur output is 1,2,3,4?

Hi,

Just give the logo in ur right corner of the Report in its REPORT HEADER...

Hi,

The only way to solve these page breaks in print preview is to adjust the layout property and by reducing table/matrix column width..

Make sure that you aligned ur report...

Hi,

YES .. u can.. that only i have mentioned in my last reply..

first create tables like this...

table 1

header(u can give this text box as toggle for...

Hi,

a table cannot be toggled by another table's detail row.. but it can be toggled by other tables, header or footer

oh... u can do it by placing inside list also... PAGE BREAKS are for that purpose only...

FYI... Document map also used like that...