This topic is solved.

Btw the solution is simple, for my case, i just add in a table, go the its properties and set true for 'page break at start'

I...

Hi lynn,

Not sure if u will see this. I deployed my system using your solution to the UAT. Everything works great. The solution was efficient. However after some round of...

Hi Lynn, i finally got it!!! what a smart use of * -1 to ensure consecutive dates and same dates fall to the same group date. THANKS:-D

Lynn Pettis (1/15/2013)

First thing you need to do is to read about...

Thanks Lynn, i am reading up the articles.

Lynn i have been really trying very hard. Now i uds your solutions up to 75% i guess. However would u help me to uds your solution more by having...

KUDOS to Lynn!!! Your solutions always worked and its very efficient. I am still understanding the code(digesting a heavy meal).

Thanks!!!:)

Lynn, i am still trying. Mind explaining the difference between dense_rank() and row_number() if both using partion by?

This is rare... after 8 hrs no one replied, maybe i am too demanding or the scenario is not clear enough? Therefore i made up another example:

This is what i...

can i trim the filter to display only up to 100 char?

Hi,

heed your advice i did exactly, and it solved my problem, thanks:)

thanks! shall try that!

I met with another problem. Lets say using the same package variable ExecDate, data type : String, Default value : "Default"

So if my batch file pass a date parameters to...

Ok! thanks for the great help. will start testing out without the Consecutive column, not that i doubt u but would like to see it myself. I will heed your...

oh no, really? Then i will have to change...