Hi all,
I have a transcript report which has 2 groups and details of that groups and it is using multiple column. In this students marks will be showing. My problem is even though the student took one subject or five subject i have to show five records into the details section of the report. If the student took only one subject the remaining 4 will be blank and into my table there is only the same no. of data which student took for the concerned term of study. so that it will looks like blocks according to each Term of the study. Now i am getting this as unorganized that is if there is only 2 records means there will be 2 records into the details section... so the format will not coming as blocks for each group...
So pls help to solve this problem
Thanks in advanceCreate stored procedure getting number as input parameter
If the number is 5 then select all five columns
If it is 4, select 4 columns ,etc
In the front end application
Give commands
Crrpt.DiscardSavedData
Crrpt.Database.verify
Showing posts with label details. Show all posts
Showing posts with label details. Show all posts
Monday, March 12, 2012
Wednesday, March 7, 2012
Please Please Please
Hi,
How do i sort on calculate fields?
i have a group which will show the sum of all the details. how do i sort on
the group level ?
EX:
a 55
b 22
c 100
a 55
3
4
3
45
b 22
11
11
c 100
50
50
i want output as
b 22
a 55
c 100
Pls hlep meIn the sorting value of your group, enter this expression :
=Sum(Fields!MyField.Value, "group_name")|||I am doing dynamic sorting - column headers -
and the paramter doesnt take the value of an aggregate.
any other suggestions ?
"Julich" wrote:
> In the sorting value of your group, enter this expression :
> =Sum(Fields!MyField.Value, "group_name")
>|||If dynamic sorting means specifýing the sort column via report parameter
(e.g. "SortBy"), try that as the sorting value for your group:
=Sum(Fields(Parameters!SortBy.Value).Value, "group_name")
"RP" wrote:
> I am doing dynamic sorting - column headers -
> and the paramter doesnt take the value of an aggregate.
> any other suggestions ?
> "Julich" wrote:
> > In the sorting value of your group, enter this expression :
> >
> > =Sum(Fields!MyField.Value, "group_name")
> >
> >
How do i sort on calculate fields?
i have a group which will show the sum of all the details. how do i sort on
the group level ?
EX:
a 55
b 22
c 100
a 55
3
4
3
45
b 22
11
11
c 100
50
50
i want output as
b 22
a 55
c 100
Pls hlep meIn the sorting value of your group, enter this expression :
=Sum(Fields!MyField.Value, "group_name")|||I am doing dynamic sorting - column headers -
and the paramter doesnt take the value of an aggregate.
any other suggestions ?
"Julich" wrote:
> In the sorting value of your group, enter this expression :
> =Sum(Fields!MyField.Value, "group_name")
>|||If dynamic sorting means specifýing the sort column via report parameter
(e.g. "SortBy"), try that as the sorting value for your group:
=Sum(Fields(Parameters!SortBy.Value).Value, "group_name")
"RP" wrote:
> I am doing dynamic sorting - column headers -
> and the paramter doesnt take the value of an aggregate.
> any other suggestions ?
> "Julich" wrote:
> > In the sorting value of your group, enter this expression :
> >
> > =Sum(Fields!MyField.Value, "group_name")
> >
> >
Subscribe to:
Posts (Atom)