Showing posts with label groups. Show all posts
Showing posts with label groups. Show all posts

Friday, March 9, 2012

Displaying Details of a group

I have two groups. I want to do this:

Group 1

Group2

Group2 Summary info

Group2 Details

Group2 Details

Group2 Details

Group2 Details

I don't know how to get the table details row to only show my group 2 details.

Thanks

Patawa,

You can do this by creating a Table that has two groupings for Group1

and Group2. From the layout described, remove the Table Header and the

Tables and grouping Footers. For the Group2 summary information, add a

second header row to the Group2 grouping and add the appropriate

aggregates. Then, you can place the detail fields in the detail section

of the Table.

Ian

Sunday, February 19, 2012

Display only the latest two consecutive years?

Hi all,

I have a Matrix with several static rows of financial information with a column group that groups the information by date:
01.02.04 12.09.03
Dividend 455,789 346,098
Profit 100,787 264,687
Deposits 89,078 76,003
Currently I have a filter on the column group that limits the information to the top two dates (Fields!dateField.Value Top N =2). What I also need is to filer the data so that only consecutive years are displayed. I have tried the filter (Year(Fields!dateField.Value) >= Year(Max(Fields!dateField.Value)) - 1), but this doesn't stop non-consecutive years being added to the Matrix. What am I missing here?
Any help you have to offer is much appreciated!
Thank you,
Stephen.

stephen,

i think that this task seems to be "database work" - just evoke the needed data by an appropriate sql-statement.

cheers
markus

|||

Thank you for your reply.

Is there any way that I can do this without altering the underlying dataset? Unfortunately, the query already returns all of the data that is required and nothing more, so limiting any of the data there would cause problems elsewhere in the report.

Stephen.

|||How about creating a second dataset with a modified query to get only the data you need. So then you have one dataset with all the dataand one with the last two years.|||That's a good idea! I will have a play around with it and will let you know how I get on.

Thanks!

Regards,

Stephen.|||

That seems to have done the trick!

Thanks!

Stephen.

Friday, February 17, 2012

display 'groups' next to each other?

I work for a non-profit agency which is slooowly computerizing itself.
We recently acquired SS 2005 and I am learning RS 2005.
My question: How can I create a report format such that the 'groups'
are adjacent to each other'
This is not the same as multi-column report, which looks like
newspapers.
I want:
Group 1
Category 1 Category 2 Category 3
Item 1 Item 22 Item 31
Item 2 Item 35 Item 41
Item 3 Item 45 Item 51
Item 4 Item 55 Item 61
Group 2
Category 1 Category 2 Category 3
Item 10 Item 322 Item 310
Item 20 Item 335 Item 410
Item 30 Item 345 Item 510
Item 40 Item 355 Item 610
Or is this not possible in RS2005 and I must use a regular HTML page
sort of thing?
Thank you, TomThis looks like two tables on one report, with different groups on,
using the same Dataset rather than one table with fancy grouping.
On Oct 24, 4:57 pm, "tlyczko" <tlyc...@.gmail.com> wrote:
> I work for a non-profit agency which is slooowly computerizing itself.
> We recently acquired SS 2005 and I am learning RS 2005.
> My question: How can I create a report format such that the 'groups'
> are adjacent to each other'
> This is not the same as multi-column report, which looks like
> newspapers.
> I want:
> Group 1
> Category 1 Category 2 Category 3
> Item 1 Item 22 Item 31
> Item 2 Item 35 Item 41
> Item 3 Item 45 Item 51
> Item 4 Item 55 Item 61
> Group 2
> Category 1 Category 2 Category 3
> Item 10 Item 322 Item 310
> Item 20 Item 335 Item 410
> Item 30 Item 345 Item 510
> Item 40 Item 355 Item 610
> Or is this not possible in RS2005 and I must use a regular HTML page
> sort of thing?
> Thank you, Tom|||I don't think so.
Tables always display data vertically, top to bottom.
I want across for one type of data (category)
then lists across (members of each category)
I'll see if I can do that though
Thanks, Tom
weelin wrote:
> This looks like two tables on one report, with different groups on,
> using the same Dataset rather than one table with fancy grouping.|||Have you looked at the Matrix control yet, compared to Table? To me it looks
like you should use a matrix, with coloum groups set to Category. You might
have to tweak your data set a bit, to get both column groups and row groups,
but matrix is still the best way to go.
Kaisa M. Lindahl Lervik
"tlyczko" <tlyczko@.gmail.com> wrote in message
news:1161705438.165317.168270@.b28g2000cwb.googlegroups.com...
>I work for a non-profit agency which is slooowly computerizing itself.
> We recently acquired SS 2005 and I am learning RS 2005.
> My question: How can I create a report format such that the 'groups'
> are adjacent to each other'
> This is not the same as multi-column report, which looks like
> newspapers.
> I want:
> Group 1
> Category 1 Category 2 Category 3
> Item 1 Item 22 Item 31
> Item 2 Item 35 Item 41
> Item 3 Item 45 Item 51
> Item 4 Item 55 Item 61
>
> Group 2
> Category 1 Category 2 Category 3
> Item 10 Item 322 Item 310
> Item 20 Item 335 Item 410
> Item 30 Item 345 Item 510
> Item 40 Item 355 Item 610
> Or is this not possible in RS2005 and I must use a regular HTML page
> sort of thing?
> Thank you, Tom
>|||Still trying this out, but it is not displaying the items under the
categories properly, they are either 'stepped,' or there are gaps in
the list rows, etc. etc., and the matrix doesn't seem to have a way of
'wrapping' the columns around, I don't want one giant
spreadsheet-looking thing, I would like a four-column sort of thing.
Thank you, Tom
P.S. I'm beginning to think it's impossible.
Kaisa M. Lindahl Lervik wrote:
> Have you looked at the Matrix control yet, compared to Table? To me it looks
> like you should use a matrix, with coloum groups set to Category. You might
> have to tweak your data set a bit, to get both column groups and row groups,
> but matrix is still the best way to go.

Tuesday, February 14, 2012

Display groups in seperate pages

Hi all
I am working on Crystal reports 8.5
I have 4 groups,need to display every group in seperate pages
Could any one pls help meright click on the report and select the "section expert" option. In this, you select your group header and on the right side tick the "new page after" option. Click on the corresponding button for the option and enter "Not OnFirstRecord".|||Thank you
it works fine