Hey it's great to restrict the number of rows per page

I have one problem.i need to restrict the number of pages for report.

I have 100 pages report but my client...

Haaa haaa haa haa.good joke.keep it up.

I am asking why u r doing format?

which type of format u r expecting and what is old format?

sank

Yes it's possible based on filter conditions u can.

select Matrix>>>>>Go to Matrix Properties>>>> Select Filters option>>>>>>>>>>>Then write down what u want restrict in there>>>>ok

Plz let me know if u get

Thank...

Hi

Could you please tell me what is u r requirement?

sank

Hi can you able to send screen shot?

sank

I think in Mozilla it will come like this, even i had same problem but explore it's coming fine.better to use explore.

sank

I think the expression may help for u, try this

=(Monthname(Month(DateAdd(DateInterval.Month,0,cdate(Parameters!P_Week_Ending_Date.Value))))) &" "& (Day(DateAdd(DateInterval.Day,0,cdate(Parameters!P_Week_Ending_Date.Value)))) &","& (Year(DateAdd(DateInterval.Year,0,cdate(Parameters!P_Week_Ending_Date.Value))))

Result-July/16/2010

in the above expression Instead of P_Week_Ending_Date put u r parameter filed,then it ll...

Sorry i never use script component, even i don't no the .net coding, any other why i can create?

Could u plz give me steps how to do with script component,my requirement is to create new log file every day, for that i have write down above expression.

sank

To create Dynamic txt file

"C:\Documents and Settings\projects\Desktop\logfile1"+right("0" +(dt_wstr,2)month(getdate(),2)+right("0"+(dt_wstr,2)day(getdate(),2)+(dt_wstr,4)year(getdate())+".txt"

any thing wrong this expression?,becoz when add this one to error log file connection manger it is throwing error like "property value...

Hi i have created second one( create log file dynamically by using script task date wise), now my problem is how to point the log file to txt file which...

already i have set the width 29.5 and height-19

sorry yar, when exporting to excel it's fine,when click print preview it's coming in 3 pages, i tried many way's and change the width and hight,but no use.

sank

Hey thanks for u r help ,now it's working.

thank you very much

sank

Thanks for u r reply Gayathri,

still no use,i can able to export two format both excel and pdf,when pdf the print was coming in single page,when print in excel it...