公开(公告)号：US07707490B2

公开(公告)日：2010-04-27

申请号：US10875832

申请日：2004-06-23

申请人： Christopher Alan Hays ,  Jason David Carlson

发明人： Christopher Alan Hays ,  Jason David Carlson

IPC分类号： G06F17/16 ,  G06F17/15

CPC分类号： G06F17/246 ,  G06F17/30554

摘要： Columns and/or rows of a report can be declaratively defined as either dynamic or static. The declarative definition can be represented by any marking. If a column or row is declaratively designated as dynamic, it can be expanded into a plurality of columns or rows. If a column or row is designated as static, it remains as a single column or row to represent only the specified column or row data. Subgroups of columns and rows can also be declaratively defined as dynamic or static. A static column or row may contain no sub-columns/rows, or it may contain a plurality of static columns/rows, a plurality of dynamic columns/rows, or any combination of both. Similarly, a dynamic column or row may also contain the above combinations.

摘要翻译： 报表的列和/或行可以声明性地定义为动态或静态。 声明性定义可以由任何标记表示。 如果列或行声明性地指定为动态列，则可将其扩展为多个列或行。 如果列或行被指定为静态，则它将保留为单个列或行，以仅表示指定的列或行数据。 列和行的子组也可以声明性地定义为动态或静态。 静态列或行可以不包含子列/行，或者可以包含多个静态列/行，多个动态列/行或两者的任意组合。 类似地，动态列或行也可以包含上述组合。

公开(公告)号：US08024650B2

公开(公告)日：2011-09-20

申请号：US11396148

申请日：2006-03-31

申请人： Jason David Carlson ,  Robert Alan Meyers

发明人： Jason David Carlson ,  Robert Alan Meyers

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30539

摘要： Mechanisms are provided for drilling on data elements in arbitrary ad-hoc reports. Data elements in one ad-hoc report can be examined and then drilled on, in order to obtain other related data elements in other ad-hoc reports. Thus, in one exemplary aspect of the disclosure, when a user selects a data element in an ad-hoc report, another ad-hoc report is generated containing data elements that are obtained as a result of taking into account 1) the original query associated with data element in the ad-hoc report; 2) the context of the selection in the ad-hoc report, and 3) the granularity of the resulting query associated with the resulting ad-hoc report.

摘要翻译： 提供了在任意特别报告中对数据元素进行钻取的机制。 可以对一个特设报告中的数据元素进行检查，然后进行钻取，以便在其他特别报告中获取其他相关数据元素。 因此，在本公开的一个示例性方面，当用户在特别报告中选择数据元素时，生成包含作为考虑到的结果而获得的数据元素的另一个临时报告1）原始查询相关联 在特定报告中使用数据元素; 2）特设报告中选择的上下文，以及3）与生成的特别报告相关联的结果查询的粒度。

公开(公告)号：US20150379470A1

公开(公告)日：2015-12-31

申请号：US14752640

申请日：2015-06-26

申请人： Jason David Carlson

发明人： Jason David Carlson

IPC分类号： G06Q10/10

CPC分类号： G06Q10/10

摘要： A method of automatically re-organizing structured data in a reporting system based on screen size calculated an initial layout for data containers in a report, checks to see if any of the data containers are obscured by the right display edge, and re-arranges the data containers so that no containers are obscured. A similar process is performed on any data grids with obscured columns. Columns are removed according to importance to maintain context. Elements in a removed column are added below respective associated rows.

摘要翻译： 基于屏幕尺寸在报告系统中自动重组结构化数据的方法计算报告中的数据容器的初始布局，检查任何数据容器是否被右显示器边缘遮蔽，并重新布置 数据容器，使得没有容器被遮蔽。 对具有隐蔽列的任何数据网格执行类似的过程。 根据维护上下文的重要性删除列。 删除的列中的元素将添加到各个关联的行之下。

公开(公告)号：US07693862B2

公开(公告)日：2010-04-06

申请号：US11170418

申请日：2005-06-29

申请人： Carolyn Khanh Chau ,  Jason David Carlson ,  Robert Alan Meyers ,  Brian Lee Welcker ,  Lisa Renee Mueller ,  Aaron Stephen Meyers

发明人： Carolyn Khanh Chau ,  Jason David Carlson ,  Robert Alan Meyers ,  Brian Lee Welcker ,  Lisa Renee Mueller ,  Aaron Stephen Meyers

IPC分类号： G06F17/30

CPC分类号： G06F17/30604 ,  Y10S707/99943

摘要： A graphical user interface and method of use thereof that allows users to interact with an entity relationship model. The user interface includes zones that allow users to navigate among the entities, roles and fields to create queries that are run against the model. Clicking on an entity in the shows the available fields for the entity. Users can drag and drop entities and fields onto a design surface to quickly and easily build queries. Rules are applied when either an entity or a field is dropped onto the design surface based upon the item being dropped (either an entity or a field), the position of the drop and also the properties that are associated with the item. Entities may be grouped and filtered to sort and limit the results of the query. After query is run, the results may be displayed in a separate area to the user.

摘要翻译： 图形用户界面及其使用方法，其允许用户与实体关系模型进行交互。 用户界面包括允许用户在实体，角色和字段之间导航以创建针对模型运行的查询的区域。 单击实体中的实体将显示实体的可用字段。 用户可以将实体和字段拖放到设计界面，以便快速轻松地构建查询。 当实体或字段根据删除的项目（实体或字段），放置的位置以及与项目相关联的属性将实体或字段删除到设计表面时，将应用规则。 可以对实体进行分组和过滤，以对查询的结果进行排序和限制。 运行查询后，结果可能会显示在用户的单独区域中。