How to get a Sum of rows, when i use the property max. rows p. page ?

Advertisement
November 30

Hi all.
I've got a query and get a lot of rows (amounts) back.
Now i want to have max. 21 rows per page.
So, first i used the property "max. rows p. page"=21.
But i want a have Sum-Field p.page too, which shows the sum of the amount p. page at a >fixed place (bottom, left) at the page.
this didnt work well....
Because when i have 30 rows, then the sum will shown at the second page (because the sum-field its after the repeating frame).
...Now i forgot the property and placed a function and two placeholder in the query like this:
Function:
:cp_row:=:cp_row +1;
if (mod (:cp_row,21)=0)) then :CP_pagenr:=:CP_pagenr+1;
Placeholders: cp_row, cp_pagenr
Now i want to use :CP_pagenr to change the group - but Report Builder says: I cant... because placeholder are not allowed to change a group.
So.. perhaps anyone can give me a hint how i can do this ?
Thanks a lot...

Advertisement

Replay

hello.
that sound to me as you wanted a running total. check out the metalink knwoledge base and search for running total and you will find a note on how to do that.
regards,
the oracle reports team --pw                                                                                                                                                                                                                                                                                                                                                                                                                                       

View 2 Replies

I am trying to reinstall Flash CS4 professional as the action script is not working but now I am getting an error: 2 message when I use the original CD to try and reinstall

October 11

I can't get the original disk to work on a reinstall.  I get the message AdobeColorCommonSetRGB Error: Error 2. I teach a class using this program on Macintosh computers running 10.9.5 and the action script is not working.  It will work on any progra

View All Replies

I share a macbook with my other half and we both use it for our iphones. When syncing using the new software I now have all of her and my contacts on my phone.  I don't want her contacts! How do I get rid?

October 11

I share a macbook with my other half and we both use it for our iphones. When syncing using the new software I now have all of her and my contacts on my phone.  I don't want her contacts! How do I get rid?Hi, You have 2 solutions: 1 - You can use 2 d

View All Replies

I get an error code 69889 when I use my DVD

November 30

I get an error code 69889 when I use my DVDA SanDisk what? How is it Formatted? What type of file are you trying to drag to it? Sorry for not being a better mind reader, but if it has been formatted NTFS by or for windows only? Then you will need to

View All Replies

HT4962 how i get ios 5 on my ipod 3g becuase the version is too old 4.2.1

November 30

how i get ios 5 on my ipod 3g becuase the version is too old 4.2.1Very likely since yu really have a 2G iPod. Those only go to 4.2.1. If your is an 8 or 16 GB one it is a 2G since Apple only made 32 and 64 GB 3G iPods. A 32 GB one can be either. See:

View All Replies

How do i search for a photo album when i use the search facility on my iPad or iPhone it will not find photo albums of a given name can anyone help

October 11

how do i search for a photo album when i use the search facility on my iPad or iPhone it will not find photo albums of a given name can anyone helpPhoto albums are not searched by Spotlight Search.  Go to Settings > General > Spotlight Search to see

View All Replies

The app store keeps popping up (with an app to download) while using other apps. It is getting incredibly annoying. I am currently using the QR reader app. How do I get it to stop?

November 30

The app store keeps popping up (with an app to download) while using other apps. It is getting incredibly annoying. I am currently using the QR reader app. How do I get it to stop?you can try a soft reset, or u can try to turn it off and then back on

View All Replies

I DON'T HAVE ICLOUD ON MY MAC. HOW DO I SET IT UP? WHEN I HIT THE APPLE ON THE TOP LEFT HAND CORNER & HIT SYSTEM PREFERENCES, NO ICLOUD ICON IS AVAILABLE.

November 30

I DON'T HAVE ICLOUD ON MY MAC. HOW DO I SET IT UP? WHEN I HIT THE APPLE ON THE TOP LEFT HAND CORNER & HIT SYSTEM PREFERENCES, NO ICLOUD ICON IS AVAILABLE.Which version of MacOS X do you have on your Mac? See the System requirements for iCloud service

View All Replies

I am running Elements 11 on Windows 8.  When I use the healing tool, the entire image moves with the cursor.  How do I fix???  Thanks!

November 30

I am running Elements 11 on Windows 8.  When I use the healing tool, the entire image moves with the cursor.  How do I fix???  Thanks!With the Healing Brush Tool selected, in the Tool Options, click on Clone Overlay and check Clipped.Read other 3 ans

View All Replies

How to get data from a USB-UIRT device using Labview?

October 11

How to get data from a USB-UIRT device using Labview? I'm trying to get data from a USB-UIRT device, is it posible with Labview? I really appreciate your help,  thanksYou may want to contact the developer of the device for the API and DLL. http://65.

View All Replies

How to get Folder or document service permissions  by using  KM API's

November 30

Hi, Any help how to get Folder or document service permissions  by using  KM API's   Any help or hint is greatly appreciated. Thanks, Costa.Hi, I have tested it here and it works for me (this code lists the service permissions settings for folder /do

View All Replies

How can i buy music off itunes when i forgot the answers to my security questions?

November 30

how can i buy music off itunes when i forgot the answers to my security questions?How to reset your Apple ID security questions Go to appleid.apple.com and click on the blue button that says 'Manage Your Apple ID'. Log in with your Apple ID and passw

View All Replies

How to get column names for a specific view in the scheme?

October 11

how to get column names for a specific view in the scheme? TIA Don't have DD on the wall anymore....or this? SQL> select text from ALL_VIEWS   2  where VIEW_NAME   3  ='EMP_VIEW'; TEXT SELECT empno,ename FROM EMP WHERE empno=10Read other 5 answers

View All Replies

IIS service not showing when I use the get-exchangeCertificate | fl cmdlet

October 11

Hello All, I just installed a 3rd party digital certificate to my Exchange 2010 via powershell then assigned the 4 services IIS, pop, smtp, imap but when I use the get-exchangecertificate | fl cmdlet the IIS service is not showing.The rest of the ser

View All Replies

In my first iPhone 5, the speaker didn't work and people could not hear me on Speaker phone when I used it. When I used the video recording it did not record sound at all only a hissing/static sound, no voice.

October 11

In my first iPhone 5, the speaker didn't work and people could not hear me on Speaker phone when I used it. When I used the video recording it did not record sound at all only a hissing/static sound, no voice. I wished for a software fix. I did a har

View All Replies

A year ago I brought a 1 TB hard drive (My Passport), I have not used it for over 4 months and now when I use the USB cord to connect it to my mac, it does not register the hard drive.  Does anyone know why this is happening?

November 30

A year ago I brought a 1 TB hard drive (My Passport), I have not used it for over 4 months and now when I use the USB cord to connect it to my mac, it does not register the hard drive.  Does anyone know why this is happening?The beeps could be caused

View All Replies

When I use the software demo capture feature and publish yellow shows as white

November 30

when I use the software capture feature, it captures the image with yellow but when i publish it, yellow shows as white.  How do I get the published view to show yellow (what is actually captured?)Try adjusting the slide quality. You will find it in

View All Replies

My macbook air wont change songs when for itunes when i use the buttons on the top of my keyboard and when i restart my computer they work for like 10 minute then stop working again. Did i change a settting? what should i do?

November 30

My macbook air wont change songs for iTunes when i use the buttons on the top of my keyboard and when i restart my computer they work for like 10 minutes then stop working again. Did i change a setting? what should i do?Hello King Cutway If you are h

View All Replies

I have a new iMac running OS 10.9 when I use the Command S shortcut it no longer saves the active document it speaks it instead.

October 11

I have a new iMac running OS 10.9.  When I use the Command S shortcut in any of my apps (numbers, text edit etc), it no longer saves the active document it speaks it instead.  How can I revert to the save shortcut function?have you looked in system p

View All Replies

I have an apple ID which I use to sign into icloud for my iPad and iPhone.But when I use the same ID for setting up iCloud on my Macbook it says INCORRECT ID or password, try again. I tried changing my passwords but it does not work for the macbook.

October 11

I have an apple ID which I use to sign into icloud for my iPad and iPhone.But when I use the same ID for setting up iCloud on my Macbook it says INCORRECT ID or password, try again. I tried changing my passwords several times but it does not work for

View All Replies

Tags:

  1. anonymous
  2. removing exeifes apple id
  3. hp g60 diskpart uefi
  4. java deconfig for old jav r12
  5. FM VIEW_MAINTENANCE_CALL.
  6. itunes login createSession
  7. mass confirm vendor
  8. mp01 mpn
  9. 8QYE
  10. whitecca
Copyrights 2019 Fcffair BigData Resource, All rights reserved