want to show one group's total into another RSS

• • Reply
  nkd1083

  Member

  177 Points

  312 Posts

  want to show one group's total into another

  Sep 30, 2013 11:46 AM|nkd1083|LINK

  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."

• • Reply
  MSDN_ice

  Participant

  1061 Points

  332 Posts

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

  Oct 03, 2013 12:09 PM|MSDN_ice|LINK

  nkd1083

  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.

• • Reply
  nkd1083

  Member

  177 Points

  312 Posts

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

  Oct 04, 2013 03:11 AM|nkd1083|LINK

  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,

• • Reply
  MSDN_ice

  Participant

  1061 Points

  332 Posts

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

  Oct 07, 2013 10:52 AM|MSDN_ice|LINK

  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.

• • Reply
  jeeveshfulor...

  Participant

  1220 Points

  336 Posts

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

  Oct 19, 2013 07:38 PM|jeeveshfuloria08|LINK

  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.