Need to hide the first 5 and last 5 rows of my results

building reports webintelligence
1

Hi all,

I have a report where each row has a unique date and time field. I need to hide the first 5 and last 5 rows. My customer is only interested in the data that starts 5 minutes after the start time up until 5 minutes before the stop time. Any ideas how to achieve this? I have breaks and each break contains a different amount of rows so a running count and excluding the first and last 5 will not work.

Thank you~
Terri

2

Hello @terridavis33, welcome to B :mrgreen: B.

I assume that you must have a date/time filter on your data. Can you not adjust the filter to just exclude the times when you don’t want to display data?

This could be problematic if the user is prompted for a date or if the full amount of data is needed for other sections of the report.

You could put a filter on that section using variables you create that remove the five minutes from the beginning and end of the time period just for that particular section (if you have more than one section).

3

Hi John,

Thanks for responding! No filters have been applied. These are unique cases with each break so the dates and times are all different. What would that variable look like to remove 5 minutes from the beginning and end? I played with that concept but I was not successful.

4

I have to admit I’m not much of a report developer, I am primarily a system administrator.

I had thought you could create variables such as follows (for SQL Server):
StartTime + 5 = =RelativeDate([Start Time];5;MinutePeriod)
StartTime - 5 = =RelativeDate([Start Time];-5;MinutePeriod)

Then create a filter where your StartTime was between these two values but I don’t see a way to combine a report object with a variable to create a filter.

I can’t really spend much more time trying to work it out, my employer would rather I work on things for them. :grin:

Maybe some of the other users of the forum can provide you with better answers than I.

1 Like
5

Thank you so much John, that did the trick!

Much appreciated,
Terri

6

Really? Outstanding! I wasn’t too sure about it. Glad I could be of assistance.

Thank you also for marking the post as solved. :+1: