grouping or formatting issue

hey there

I have a date time field

Fields!CreatedDate.Value which I am grouping on and Counting on an ID Field

result of grouping is this

7/13/2006 12:00:00 AM 1

7/21/2006 12:00:00 AM 11

8/7/2006 12:00:00 AM 3

8/8/2006 12:00:00 AM 2

I know if I put (Month(Fields!CreatedDate.Value)

I get this result

7 1

7 11

8 3

8 2

What I really want is

July 12

August 5

how do I do this please

thanks

Hi there!
I dont know if this will resolve your issue but maybe if you try the following:

Format((Month(Fields!CreatedDate.Value)), "MMM")

If this works like I think it might then it should return:

Jul 12

Aug 5......etc

I cant test right now so I cant be sure...!?|||

Try

Monthname(Datepart("m", Fields!CreatedDate.Value))

This report function will return the "January, Feburary, March and etc...

Ham

|||

ok thanks for the replies

unfortunately not quite complete

Ham what I get then is

July 1

July 11

August 1

August 3

etc

so I need

total for July

total for August

etc

cheers

|||

thought I should put the sql

SELECT TicketNumber, CreatedDate
FROM Ticket
ORDER BY CreatedDate

grouped on created date - associated to parent group created date

count on ticketnumber

cheers

Dianne

|||

jewel,

Try

Placing the expression Monthname(Datepart("m", Fields!CreatedDate.Value)) into your group expression (edit group), this will cause the group to only consider the month when summating the values.

Ham

|||

thanks Ham

I had to put this in the group expression and the field expression to get it to work? I presume this is ok?

But yes it does work now thanks heaps for your help

jewel

Group/Details Formatting

Hello,

I am developing a report where i have one group e.g. Dealer Name and then details of that dealer.

Dealer details can have around 10 columns and where dealer name is of around 80 chars length. I need to use 10.7in*7.1in page size.

So how i can manage the formatting for dealer group, dealer details in one page.

Thanks.

Hi Amit,

It sounds like you think you can't put the "long" group name on top of the table. Is that right?

If so, try this:

set up your group on the dealer name, as you normally would, in a table now you have your column headers for each of the detail columns, as you usually would|||

Thanks!!....I added one table row and merge the cell. In Detail section for identation i added " "/Space(3)...

Group formatting question

Hi. I have 2 groups associated with a data table, one on company name, and then one on management,

Company Name Management License # Phone Southwest Bank & Trust Southern Management, LLC 123456 123-123-1234 789123 321-456-7890 838485 888-111-5555

However, I would like the table to display the information in this fashion, so that the grouped items appear as part of the details, rather than on a separate line. How can I accomplish this? Thanks in advance.

Company Name Management License # Phone Southwest Bank & Trust Southern Management, LLC 123456 123-123-1234 789123 321-456-7890 838485 888-111-5555

You can definitely do this. Did you use the wizard and a "stepped" format, by any chance, when you created this report?

Based on your second sample format, I would start by making a single group that has both expressions in it, and I would remove both those group header lines. I would put the company and management expressions directly in the detail line, and use "hide duplicates" to suppress the values after detail row #1.

HTH,

>L<

|||Thanks, Lisa. No, I did the report using the designer not the wizard. I'll try your suggestion and see what I get.
|||Hi, Lisa. Your suggestion worked like a charm. I set the group headers not to show; is there a way to see the group headers after unchecking the box that shows them? I can't seem to find a way to edit those groups after hiding them. Thanks.
|||

>> is there a way to see the group headers after unchecking

Yep. When you rightclick on an element of the table, you should have an option in the context menu that allows you to select the parent, something like "select table1". Or, if you click on the little grey square box at the top-left corner of the table (above the square row indicators on the left) you can select the table. However you do it, when the selection marquee is around the table, rather than a table element, if you rightclick and select Properties you will get into the Table Properties dialog.

You will see a Group tab in that dialog. When you select it (is this starting to sound like Zork?) you should see your group in a listbox; if you click the Edit button in that Tab with your group selected it brings you back to that Group dialog that you want.

There may be a better way. There are probably several -- although it's good to know about that Table dialog, so I want to make sure you do <s>.

My main thought right now is... why do you need the groups at all, why not eliminate them? Order your data properly, and the groups should be "natural" in this case, unless you have some aggregate functions that need them?

Alternatively, this might be a case for "details grouping" rather than "groups" -- although frankly I'm not sure I understand that "feature". You will find an example/walkthrough here http://msdn2.microsoft.com/en-us/library/ms155903.aspx . You can get to "details grouping" by rightclicking on the row indicator for the details band, or from the Table Properties dialog (there is a Details Grouping... button in the Group tab).

>L<

|||Thanks, Lisa, for the very informative and detailed explanation. It's very much appreciated

Group formatting question

Hi. I have 2 groups associated with a data table, one on company name, and then one on management,

Company Name Management License # Phone Southwest Bank & Trust Southern Management, LLC 123456 123-123-1234 789123 321-456-7890 838485 888-111-5555

However, I would like the table to display the information in this fashion, so that the grouped items appear as part of the details, rather than on a separate line. How can I accomplish this? Thanks in advance.

Company Name Management License # Phone Southwest Bank & Trust Southern Management, LLC 123456 123-123-1234 789123 321-456-7890 838485 888-111-5555

You can definitely do this. Did you use the wizard and a "stepped" format, by any chance, when you created this report?

Based on your second sample format, I would start by making a single group that has both expressions in it, and I would remove both those group header lines. I would put the company and management expressions directly in the detail line, and use "hide duplicates" to suppress the values after detail row #1.

HTH,

>L<

|||Thanks, Lisa. No, I did the report using the designer not the wizard. I'll try your suggestion and see what I get.
|||Hi, Lisa. Your suggestion worked like a charm. I set the group headers not to show; is there a way to see the group headers after unchecking the box that shows them? I can't seem to find a way to edit those groups after hiding them. Thanks.
|||

>> is there a way to see the group headers after unchecking

Yep. When you rightclick on an element of the table, you should have an option in the context menu that allows you to select the parent, something like "select table1". Or, if you click on the little grey square box at the top-left corner of the table (above the square row indicators on the left) you can select the table. However you do it, when the selection marquee is around the table, rather than a table element, if you rightclick and select Properties you will get into the Table Properties dialog.

You will see a Group tab in that dialog. When you select it (is this starting to sound like Zork?) you should see your group in a listbox; if you click the Edit button in that Tab with your group selected it brings you back to that Group dialog that you want.

There may be a better way. There are probably several -- although it's good to know about that Table dialog, so I want to make sure you do <s>.

My main thought right now is... why do you need the groups at all, why not eliminate them? Order your data properly, and the groups should be "natural" in this case, unless you have some aggregate functions that need them?

Alternatively, this might be a case for "details grouping" rather than "groups" -- although frankly I'm not sure I understand that "feature". You will find an example/walkthrough here http://msdn2.microsoft.com/en-us/library/ms155903.aspx . You can get to "details grouping" by rightclicking on the row indicator for the details band, or from the Table Properties dialog (there is a Details Grouping... button in the Group tab).

>L<

|||Thanks, Lisa, for the very informative and detailed explanation. It's very much appreciated

Group formatting question

Hi. I have 2 groups associated with a data table, one on company name, and then one on management,

Company Name Management License # Phone Southwest Bank & Trust Southern Management, LLC 123456 123-123-1234 789123 321-456-7890 838485 888-111-5555

However, I would like the table to display the information in this fashion, so that the grouped items appear as part of the details, rather than on a separate line. How can I accomplish this? Thanks in advance.

Company Name Management License # Phone Southwest Bank & Trust Southern Management, LLC 123456 123-123-1234 789123 321-456-7890 838485 888-111-5555

You can definitely do this. Did you use the wizard and a "stepped" format, by any chance, when you created this report?

Based on your second sample format, I would start by making a single group that has both expressions in it, and I would remove both those group header lines. I would put the company and management expressions directly in the detail line, and use "hide duplicates" to suppress the values after detail row #1.

HTH,

>L<

|||Thanks, Lisa. No, I did the report using the designer not the wizard. I'll try your suggestion and see what I get.
|||Hi, Lisa. Your suggestion worked like a charm. I set the group headers not to show; is there a way to see the group headers after unchecking the box that shows them? I can't seem to find a way to edit those groups after hiding them. Thanks.
|||

>> is there a way to see the group headers after unchecking

Yep. When you rightclick on an element of the table, you should have an option in the context menu that allows you to select the parent, something like "select table1". Or, if you click on the little grey square box at the top-left corner of the table (above the square row indicators on the left) you can select the table. However you do it, when the selection marquee is around the table, rather than a table element, if you rightclick and select Properties you will get into the Table Properties dialog.

You will see a Group tab in that dialog. When you select it (is this starting to sound like Zork?) you should see your group in a listbox; if you click the Edit button in that Tab with your group selected it brings you back to that Group dialog that you want.

There may be a better way. There are probably several -- although it's good to know about that Table dialog, so I want to make sure you do <s>.

My main thought right now is... why do you need the groups at all, why not eliminate them? Order your data properly, and the groups should be "natural" in this case, unless you have some aggregate functions that need them?

Alternatively, this might be a case for "details grouping" rather than "groups" -- although frankly I'm not sure I understand that "feature". You will find an example/walkthrough here http://msdn2.microsoft.com/en-us/library/ms155903.aspx . You can get to "details grouping" by rightclicking on the row indicator for the details band, or from the Table Properties dialog (there is a Details Grouping... button in the Group tab).

>L<

|||Thanks, Lisa, for the very informative and detailed explanation. It's very much appreciated