Conditional Rendering of Rows

[abhijeet364]

Hi Guru's,

Need your help in achieving the a requirement.
1) A page can display 20 pages and after every 5th row the report has to display a blank row.

2) If the data displayed in the report contains 17 rows then in the 1st page it has to display 15(divisible by 5) rows and rest two in the next page.

Looking forward for your replies

[abhijeet364]

Hi Techies,

Request you please give your valuable idea's for the above requirement.

Thanks
Abhijeet

[blom0344]

What a nasty requirement..

Perhaps generate an index on the data using a window function like rownumber(). Divide this value by 5 , round this to zeros decimals and add 1:

rownumber()  newvalue

1                    1
2                    1
3                    1
4                    1
5                    1
6                    2
7                    2
8                    2
9                    2
10                  2
11                  3
..                    ..

Use the newvalue for grouping with a subtotal line that display nothing.

You need to know the sorting order I guess..

[abhijeet364]

It's not working. Any new thought's please

[blom0344]

Did you at least understand my proposition?

[Lynn]

It's not working. Any new thought's please

I think it is only fair to explain why the suggested solution isn't working for you. I thought of the same approach before reading blom's reply.

Are we both misunderstanding your explanation of the requirement or is there some flaw in the method or are you having trouble implementing it?

[abhijeet364]

Hi Guru's

There is change in the current requirement.

1) In a page we can display maximum of 20 row's. But if the output consist of 17 rows then after 17 rows we need to display 3 blank row's. If the report output consist of 6 rows then the report need's to show 4 blank row's. The count of the row's need's to be divisible of 5 so for that reason we need to add blank row's. Looking ahead for your help

Thanks & Regards
Abhijeet

[blom0344]

We are perfectly willing to spend some of our time on technical Cognos issues, but this is not a for-free consultancy store. We offer our input and expect feedback. If you are only interested in a canned solution then hire some consultancy to do the work for you..

[MFGF]

Hi Guru's

There is change in the current requirement.

1) In a page we can display maximum of 20 row's. But if the output consist of 17 rows then after 17 rows we need to display 3 blank row's. If the report output consist of 6 rows then the report need's to show 4 blank row's. The count of the row's need's to be divisible of 5 so for that reason we need to add blank row's. Looking ahead for your help

Thanks & Regards
Abhijeet

What happened with your original requirement? Did you try the suggestions Blom0344 kindly provided? What results did you get? Why did you ignore Lynn's request to give us more detailed information? I can understand that you have a different requirement, but unless you are prepared to engage with the people trying to help you, how can you expect them to continue to provide any sort of meaningful assistance? The forum is a community, not a helpdesk. Many people on here are willing to help, but cannot do so unless you enter into the spirit of the community and contribute enough information to make any sort of dialogue meaningful.

MF.

[abhijeet364]

Hi,

Guru's, I am really sorry for not giving proper feedback. I do not consider this forum as a free consultancy forum but i rather look for techinical guidance from specialist's like you. I had faced issues with the earlier solution given by Blom when the values of the column on which i was applying the row count were repeating. A few days later there was a change in requirement. We need to display blank rows as i had explained in my earlier post. Apologise once again.

Thanks & Regards
Abhijeet

[Lynn]

Here is a similar topic and response that might help.

[abhijeet364]

Hi Lynn,

Sorry couldnt get the topic which you are referring above.

Thanks & Regards
Abhijeet

[Lynn]

Oops....here is the link

http://www.cognoise.com/community/index.php/topic,18978.msg56246.html#msg56246