Showing posts with label allis. Show all posts
Showing posts with label allis. Show all posts

Friday, March 9, 2012

Group By Row Count And Force Page Break

Hello All!

Is there a "clean" way to group rows from a table by the row count, and then force a page break each time the count hits a maximum number (say 25 rows)?

As an alternative, can you set the maximum count of rows in a table, and then force a page break if it reaches that count? (this may actually be a better solution for my needs).

Thanks!

Create a group, set the expression for grouping to "=Fix((RowNumber("table1")-1) / 25)", and set the page break at end option on. To vary the number of rows per page, change 25 to your desired value.|||This works good, except that your table footer will always be on another page. Any ideas on how to prevent this using the solution above?|||In order to get table header and footer on all pages (and no hanging footer on last page), put the table in a list and do the grouping on the list.

Friday, February 24, 2012

Group Access

Hi all
Is there a way to create a script of a database user to see all of the
objects that user has access to and what the access is for each object?
Thanks
Kevin
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Hi
You may want to look at the sysprotects table or possibly the
INFORMATION_SCHEMA.TABLE_PRIVILEGES view
John
"Kevin Hayward" wrote:

> Hi all
> Is there a way to create a script of a database user to see all of the
> objects that user has access to and what the access is for each object?
> Thanks
> Kevin
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>

Sunday, February 19, 2012

Group Access

Hi all
Is there a way to create a script of a database user to see all of the
objects that user has access to and what the access is for each object?
Thanks
Kevin
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Hi
You may want to look at the sysprotects table or possibly the
INFORMATION_SCHEMA.TABLE_PRIVILEGES view
John
"Kevin Hayward" wrote:

> Hi all
> Is there a way to create a script of a database user to see all of the
> objects that user has access to and what the access is for each object?
> Thanks
> Kevin
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>