Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sabeeha08

    Formula

    Guys need help to calculate the following Need to calculate b4 and after, below shows the data example The idea is to find the total of stock (Which I can calculate) and then use this value at the earliest transaction hence the last transaction in this case, and add qty to the total per...
  2. sabeeha08

    Syntax

    That's correct Ibass, I have changed it to the following now and it seems to be working, not sure why the orginal did not work whileprintingrecords; numbervar a; if {@ccrsgrp} = 1 and a =1 then "Taught course part time" else if {@ccrsgrp} = 1 and a =2 then "Revision" else...
  3. sabeeha08

    Syntax

    yes it is thanks
  4. sabeeha08

    Syntax

    error, says the remaining text does not appear to be part of the formula. it actually works when i run it on crystal on it own, but when i deploy the report in our ERP apps then i get the error i calculate a distinct sum to get this value {@ccrsgrp} and if it meets the criteria i am...
  5. sabeeha08

    Syntax

    CR 8.5 Hi Can any body tell me if there is anything wrong with this syntax whileprintingrecords; numbervar a; if {@ccrsgrp} = 1 then select a case 1 : "Taught course part time" case 2 : "Revision" case 4 : "Revision" case 20 : "Distance...
  6. sabeeha08

    Drilldown options

    Any idea Ibass boss
  7. sabeeha08

    Drilldown options

    i have a main report where i get a list of customers with some data, i have also written a another report which uses pivot tables to get similar information. i have inserted the second report as sub report ( In group footer ) so that it can be used as a drilldown. My problem is that when i...
  8. sabeeha08

    Grouping

    Sorry Ian, may be i am not doing this right, but unless i summarise on paper i cant get to this position, the data you see below is what i get after summering by cust/paper/type, if i summarise on cust/type only then i cant work out what combination of type a student had for a paper, which is...
  9. sabeeha08

    Grouping

    So Ian are you saying I don't need the grouping on paper then
  10. sabeeha08

    Grouping

    HI Ian, i wonder if you can suggest what i need to do here, i have done the following on what you have suggested and am very close to the result but not there yet. i Havee grouped the data as below G1 Cust G2 Paper G3 Type i acuumulate the data using this formula and then dispaly this on 2...
  11. sabeeha08

    Grouping

    Thanks Ian and Ibass for all the help, I think this one is too complicated for me to do ( not one to give up too quickly but have spent too long on it), I may get the data exported to excel and write a macro to do it thanks guys
  12. sabeeha08

    Grouping

    Ok Ian would you able to just explain how i would go about doing this in version 8.5 in little bit of details since i have never done this before sorry for asking so many question, i really appreciate the help you guys are giving me thanks
  13. sabeeha08

    Grouping

    Thanks Ibass, for this i will need to create Views in Oracle DB and I am trying to avoid this, there are restriction to what we can do on the DB.
  14. sabeeha08

    Grouping

    Hi Ibass You did response to my post on a another account ( thank you for that) but unfortunately for some reason i could not access my account and had to create a new account. Ian has suggested an idea which i am going to attempt but seems there will be lot formulas for this. the...
  15. sabeeha08

    Grouping

    Ok Ian seems it will have to be formulas then, :( only other issue is when i have to check for the below it needs to establish if they have a combination of these types any ideas, thank you again for the help Taught course and revision FEEDER or BESPOKETAU) and (WEREV or QBREV or STDREV)
  16. sabeeha08

    Grouping

    HI Ian, Thank you very much for the quick response i will give this a try, only issue is i have 14 papers and many more method of study with a huge permutation of type. does this mean i will have to write formula's to include all possibility's thanks
  17. sabeeha08

    Grouping

    I did try to write a report which had multiple sub-reports for each method of study, but this makes the report to slow. is it possible to use the whileprintingrecords statement to some how accumulate the paper and type to do some grouping on this on the same report. Ibass my man where are you...
  18. sabeeha08

    Grouping

    Information Method of study ( needs to be calculated) Type ( data form system) Taught course part time FEEDER or INTENSIVE or BESPOKETAU or BESPOKEIN Revision WEREV or QBREV or STDREV Taught course and revision (FEEDER or BESPOKETAU) and (WEREV or QBREV or STDREV) Distance learning and...

Part and Inventory Search

Back
Top