System Variable

rbuser

Hi,
I need to display 'Page No.' in my report. I used the system variable and
set it to vtPage*. It seems to go through each page to get the total number
of pages and when the report is something like 50 pages, it takes quite a
bit of time. Is there any way to speed it up?
My report does have a lot of calculations so each time I navigate to the
next page, I have to wait several seconds before it displays it but that ok
when going page by page. In the case of System Variable, it would do go
through to the last page at the start I take it.

Shanil.

nicocizik

Shanil,

If you remove the System Variable from your report, does it run faster? We
have never heard of this issue with ReportBuilder before. All a System
Variable does is compares the Report's total pages to the current page
number. There's not much else to it. If possible, please send a small
example in .zip format to support@digital-metaphors.com that demonstrates
this issue and I'll take a look at it.

--

rbuser

I discovered that it had changed the PassSetting to psTwoPass...I changed it
back to psOnePass, so works faster now - although I did read, in the Help or
here, that when using page numbering, its better to use twopass - would that
be correct?

nicocizik

Hi Shanil,

Having your report set to psTwoPass will guarentee that the page count is
correct when previewing. If it is working with psOnePass, I would stick
with it. I believe it is mainly for navigating back and forth through the
report pages.

--

rbuser

I cache pages so I think it should work even when going back and forth. I
tested it and it seems to have numbered it correctly each time so I'll stick
with the OnePass for now