Creating reports and dashboards | Stimulsoft community forum

Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/

Question about grouping data

https://forum.stimulsoft.com/viewtopic.php?t=3844

Page 1 of 1

Question about grouping data

Posted: Mon Dec 20, 2010 2:18 pm
by esfisher
I'm trying to print a report similar to the master-detail with groups report, and I can't seem to get the data to group together. I've tried copying everything from the example report, but the output does not group the data together. Can someone explain what is missing?

The report should group events by date.

Here is the xml data:

Code: Select all


  
    Hill Center
  
  
    1
    Tuesday, Nov 30th, 2010
    2010-11-30
  
  
    2
    Wednesday, Dec 1st, 2010
    2010-12-01
  
  
    3
    Friday, Dec 3rd, 2010
    2010-12-03
  
  
    1
    Hill Center
    Hank's Office
    Bocker, Mike - trc1
    9:30 AM - 3:00 PM
    
  
  
    1
    Hill Center
    Some Facility Name
    Bocker, Mike - trc1
    9:30 AM - 3:00 PM
    
  
  
    2
    Hill Center
    Hank's Office
    Bocker, Mike - trc1
    9:30 AM - 11:00 AM
    
  
  
    2
    Hill Center
    Hank's Office
    Bocker, Mike - trc1
    9:30 AM - 11:00 AM
    - Ray Graham will be stuffing eggs for the egg hunt on April 3. They will eat lunch clean up and depart by 1 p.m.
  
  
    2
    Hill Center
    Some Facility Name
    Bocker, Mike - trc1
    9:30 AM - 11:00 AM
    
  
  
    2
    Hill Center
    Some Facility Name
    Bocker, Mike - trc1
    9:30 AM - 11:00 AM
    - Ray Graham will be stuffing eggs for the egg hunt on April 3. They will eat lunch clean up and depart by 1 p.m.
  
  
    3
    Hill Center
    Hank's Office
    Bocker, Mike - trc1
    8:30 AM - 1:00 PM
    
  
  
    3
    Hill Center
    Some Facility Name
    Bocker, Mike - trc1
    8:30 AM - 1:00 PM
Here is the report:

Code: Select all



  
    
    
      
        headerData
        
          dateRange,System.String
          locationName,System.String
        
        
        headerData
        reportData.headerData
      
      
        dateRanges
        
          dateId,System.String
          useDate,System.String
          displayDate,System.String
        
        
        dateRanges
        reportData.dateRanges
      
      
        locationScheduleData
        
          timeRange,System.String
          eventName,System.String
          eventComments,System.String
          itemName,System.String
          dateId,System.String
        
        
        locationScheduleData
        reportData.locationScheduleData
      
    
    
      
        dateRanges
        
          dateId
        
        
        
        dateRanges
        dateRangeslocationScheduleData
        
          dateId
        
        
      
    
    
    
  
  EngineV2
  
  
    
      None;Black;2;Solid;False;4;Black
      Transparent
      
        
          Transparent
          0,0.2,7.49,0.4
          
            
              Transparent
              0,0.2,7.5,0.2
              
              Arial,8
              Center
              True
              0,0,0,0
              Text6
              
              
              {PageNofM}
              Black
            
            
              Transparent
              0,0,3.3,0.4
              
              Arial,12,Bold|Underline
              0,0,0,0
              Text10
              
              
              {headerData.locationName}
              Black
            
          
          
          PageHeaderBand1
          
          
        
        
          Bottom;Black;1;Solid;False;4;Black
          Transparent
          0,1,7.49,0.5
          
            
              Transparent
              0,0.3,1.5,0.2
              
              Arial,8
              0,0,0,0
              Text2
              
              
              Time
              Black
              Bottom
            
            
              Transparent
              1.6,0.3,4.1,0.2
              
              Arial,8
              0,0,0,0
              Text3
              
              
              Event/Program
              Black
              Bottom
            
            
              Transparent
              5.8,0.3,1.7,0.2
              
              Arial,8
              0,0,0,0
              Text4
              
              
              Room
              Black
              Bottom
            
            
              Transparent
              0,0,7.5,0.3
              
              Arial,12,Bold
              0,0,0,0
              Text1
              
              
              {locationScheduleData.dateRanges.displayDate}
              Black
            
          
          {locationScheduleData.dateRanges.dateId}
          
          GroupHeaderBand1
          
          
        
        
          Transparent
          0,1.9,7.49,0.2
          
            
              Transparent
              0,0,1.5,0.2
              
              Arial,8
              0,0,0,0
              Text5
              
              
              {locationScheduleData.timeRange}
              Black
            
            
              Transparent
              1.6,0,2,0.2
              
              Arial,8
              0,0,0,0
              Text7
              
              
              {locationScheduleData.eventName}
              Black
            
            
              Transparent
              True
              True
              3.7,0,2,0.2
              
              Arial,8,Italic
              0,0,0,0
              Text8
              
              
              {locationScheduleData.eventComments}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
            
            
              Transparent
              5.8,0,1.7,0.2
              
              Arial,8
              0,0,0,0
              Text9
              
              
              {locationScheduleData.itemName}
              Black
            
          
          
          dateRangeslocationScheduleData
          locationScheduleData
          white_row
          
          DataBand1
          color_row
          
          
          
            ASC
            dateId
          
        
        
          Transparent
          0,2.5,7.49,0.3
          
            
              Transparent
              0,0,0.6,0.2
              
              Arial,8
              0,0,0,0
              Text11
              
              
              {Count()}
              Black
            
          
          
          GroupFooterBand1
          
          
        
      
      
      ffd73b8024d9655d5761f225b090d456
      0.39,0.39,0.39,0.39
      Page1
      11.69
      8.27
      
      
        Arial,100
        [50:0:0:0]
      
    
  
  
  Report
  12/18/2010 12:51:30 PM
  12/18/2010 12:51:30 PM
  C:\Users\Eric\Adobe Flash Builder 4\ParkPro2_Flex\bin-debug\reports\locationScheduleReport.mrt
  ee0f3544aa724844a1d3f225b09047dd
  Report
  Inches
  
  CSharp
  
    
      All;Black;1;Dash;False;4;[153:153:153]
      Gainsboro
      Arial,8
      color_row
      Black
    
    
      All;Black;1;Dash;False;4;[153:153:153]
      White
      Arial,8
      white_row
      Black
    
    
      All;Black;1;Dash;False;4;Black
      Transparent
      Arial,8
      databand_list_style
      Black
    
    
      Transparent
      Arial,8
      Style1
      Black

Question about grouping data

Posted: Tue Dec 21, 2010 6:25 am
by Alex K.
Hello,

In the report you sent grouping occur by the {locationScheduleData.dateRanges.displayDate} expression but in attached data the dateRanges has no data. Also you say about the master-detail report but in this report there is only one data band. Could you, please let us know whether this is correct?

Thank you.

Question about grouping data

Posted: Tue Dec 21, 2010 1:37 pm
by esfisher
Thank you for your reply. We found the error as you did, the dateRanges should have been dateRangeData. Once changed, it worked fine.

Edit: I had a question about loading images here, but I moved it to a new thread.

Question about grouping data

Posted: Wed Dec 22, 2010 5:41 am
by Vladimir
Hello,

Currently you can only specify URL as text. We will implement support for the URL from the data source in the next prerelease build on December 28.

Thank you.

Question about grouping data

Posted: Tue Jan 04, 2011 11:05 am
by jorool
Hello

I have a report with a simple group . The condition of this group is changed dinamicaly by source code.
I'm trying to set an expression on a text component to automatically show the value of the group condition...like this:

Code: Select all

{GroupHeaderBand1.condition}
or

Code: Select all

{GroupHeaderBand1.condition.value}
or something else....
How can I do that?
Is that possible?

Question about grouping data

Posted: Wed Jan 05, 2011 2:07 am
by Vladimir
Hello,

Unfortunately, the expression parser does not support the properties of internal components. We are working on this issue. On the current moment you need to specify a data source in the text expression.

Thank you.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited