locked
Free Form List Report 3 Groups RRS feed

  • Question

  • Here is another report that has me stumped.

    SQL Express 2008 R2

    Report Builder 3.0

    Report name Job Bid Schedule

    One Dataset that contains Bids

    Bids contain BidDate, BidNumber, BidCity, etc.

    I created a calculated field to get the Week Number (WeekNumber)

    I created a calculated field to get the Day of Week (DayOfWeek)

    I want my report to display as follows:

    Week - 38

                Wednesday

                            Job 1

                            Job 2

                Thursday

                            Job 1

                            Job 2

    Week - 39

    etc.

    I have no problem to get the data to display, but I cannot get the Week numbers to group correctly.  The best I can do so far is this:

    Week - 38

                Wednesday

                            Job 1

                            Job 2

    Week - 38

                Thursday

                            Job 1

                            Job 2

    Etc.

    Again, any help would be appriciated!

    Note:  I am using the List Data Region


    • Edited by WeBore Thursday, September 20, 2012 5:22 PM
    Thursday, September 20, 2012 5:21 PM

Answers

  • Hi WeBore,

    Base on your description and the screenshot, it seems that you group on weekday instead of week on the “Group Properties” window of list. I have test it on my test environment, the screenshot below are for your reference.

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    TechNet Subscriber Support
    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    • Proposed as answer by Aftab Ansari Friday, September 21, 2012 8:41 AM
    • Marked as answer by Charlie Liao Thursday, September 27, 2012 1:11 AM
    Friday, September 21, 2012 8:38 AM

All replies

  • Hi There

    Thanks for your posting. Have you created the group for week number? I have tried the sample data using list control by creating group for week number as well as Weekday. The report look like as shown in the screenshot. Is that what you after ? if that is the case then please create group both on weekday as well as week number and I hope you will get your expected results

    I hope this will help, a screenshot for your help

    Many Thanks

    Syed Qazafi Anjum

    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    Thursday, September 20, 2012 9:56 PM
  • Thank you for the quick reply.

    I was able to do it by leaving the columns in the List Data Region.  I need to delete the columns from the report.  My problem is I need to recreate a report that was written in Access. 

    This is the best that I can figure out, but need to remove the additional Week heading for the same week number

    Friday, September 21, 2012 2:10 AM
  • Hi WeBore,

    Base on your description and the screenshot, it seems that you group on weekday instead of week on the “Group Properties” window of list. I have test it on my test environment, the screenshot below are for your reference.

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    TechNet Subscriber Support
    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    • Proposed as answer by Aftab Ansari Friday, September 21, 2012 8:41 AM
    • Marked as answer by Charlie Liao Thursday, September 27, 2012 1:11 AM
    Friday, September 21, 2012 8:38 AM