locked
want to show one group's total into another RRS feed

  • Question

  • User383567333 posted

    Hi,

    I want to show one group's total into another:

    hierarchy wise:
    topmost group: group_a
    then        :group_b
    then        :group_c
    then        :group_d



    i want to show group_d total into group_b

    ->this is normal report not matrix report
    ->not any footer and header group
    ->if  i am doing this way : =SUM(Fields!ForecastValue.Value, "group_d") then getting error "The Value expression for the textbox ‘txtbox70’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set."

    Monday, September 30, 2013 11:46 AM

All replies

  • User2075212911 posted

    hierarchy wise:
    topmost group: group_a
    then        :group_b
    then        :group_c
    then        :group_d

    Hi nkd1083,

    Would you like to provide the tables' structure and some data to us?

    According to your description, I cannot figure out what data or table will be grouped.

    Thanks.

    Thursday, October 3, 2013 12:09 PM
  • User383567333 posted

    data is like this:

    Country Region Zone State Town Data
    IN E E1 WB KO 45
    IN E E2 JH RN 12
    IN E E2 SK KH 34
    IN E E3 BG HT 76
    IN w W1 GJ SO 44
    IN w W1 HK HG 64
    IN w W2 GO DD 23
    IN w W2 DE PN 12
    IN w W3 SW SQ 67
    IN N N1 DL DG 89
    IN N N1 HR GR 65
    IN S S1 CH BH 56
    IN S S2 HY JT 34
    group_a group_b group_c group_d

    regards,

    Friday, October 4, 2013 3:11 AM
  • User2075212911 posted

    Hi nkd1083,

    Please refer to below for learning Group information in data report.

    http://msdn.microsoft.com/en-us/library/aa241736(v=vs.60).aspx

    Your issue is about multiple group, this based on the Field Format. Sorry I cannot figure it out.

    I'd like to suggest you search online : multiple group in crystal report

    Hope this helps. Thanks.

    Monday, October 7, 2013 10:52 AM
  • User-1051986203 posted

    Try to use below expression where as you want to get total from another :

    =ReportItems!textbox1.Value

    Replace above textbox1 value with your corresponding textbox name where you are getting the exact total & apply this expression to another location.

    Suppose you have textbox1 which is showing total 30, and you want to show it at another location, so by using above mentioned expession, you will get the 30 value at another location.

    Saturday, October 19, 2013 7:38 PM