准备报告的数据库结构 [英] structure of database to prepare report
问题描述
我正在尝试创建一个数据库，该数据库将从
一个（可能是两个）表中获取信息并利用该信息将
查询返回给设计的报告在Excel中。
我的一般想法是：
主要或来源或来源表很简单。这是试算平衡
（帐号作为主键，描述，金额）。
我需要表格来表示哪个帐号属于报告中的页面/行
。我不确定该报告会有多少页面，但是让我说我的Excel工作簿会有50张。我的问题
是这样的：你会推荐什么样的表结构。我看待它的方式，我可以在每个页面上列出每个页面和每一行的每一行的每个页面（每个页面用唯一的ID标识），然后有另一个表格
列出每个帐户和每个页面/行ID。我看到的另一个选项是
为每个页面设置一个单独的表格。但是我不确定我在这里看到了什么？
的好处。我的第一个本能是使用我提到的第一种方法，但是在我开始之前我想要别人的意见。
TIA
Mike
I''m attempting to create a database which will take information from
one (perhaps two) tables and utilize that information to return
queries to a report designed in Excel.
The general idea I have is this:
The "primary" or "source" table is easy. This is a trial balance
(account number as a primary key, description, amount).
I''ll need table(s) to denote which account numbers belong to which
page/line on the report. I''m not sure how many pages the report will
be, but let''s say my Excel workbook would have 50 sheets. My question
is this: What would you recommend for a table structure. The way I
see it, I could have a single table listing each page and each line on
each page (each identified by a unique id), then have another table
listing each account and each page/line id. The other option I see is
to have a separate table for each "page," but I''m not sure I see a
benefit in this. My first instinct is to use the first method I
mentioned, but I wanted someone else''s opinion before I moved on.
TIA
Mike
推荐答案
2003年11月9日20:12:26 -0800，在mailing.database.mysql
< a href =mailto：mi ******* @ hotmail.com> mi ******* @ hotmail.com （Michael Malinsky）写道：
On 9 Nov 2003 20:12:26 -0800, in mailing.database.mysql
mi*******@hotmail.com (Michael Malinsky) wrote:
|我正在尝试创建一个从
|获取信息的数据库一个（也许两个）表并利用该信息返回
|查询Excel中设计的报表。
您将使用哪种语言访问数据库？
|我的一般想法是：
|
| 主要或来源或来源表很简单。这是试算平衡
| （帐号作为主键，描述，金额）。
|
|我需要用表来表示哪个帐号属于哪个帐号？报告上的页面/行。
不，你不是。
|我不确定报告会有多少页面是的，但是让我说我的Excel工作簿将有50张。
您必须拥有当地造纸厂的股份:-)
|我的问题
|是这样的：你会推荐一个表格结构。我的方式
|看到它，我可以有一个表格列出每一页和每一行
|每个页面（每个页面由唯一的ID标识），然后有另一个表格
|列出每个帐户和每个页面/行ID。我看到的另一个选择是
|每个页面都有一个单独的表格，但我不确定我是否看到了
|受益于此。我的第一直觉是使用我的第一种方法
提到了，但在我继续之前我想要别人的意见。
| I''m attempting to create a database which will take information from
| one (perhaps two) tables and utilize that information to return
| queries to a report designed in Excel.
What language will you be using to access the database?
| The general idea I have is this:
|
| The "primary" or "source" table is easy. This is a trial balance
| (account number as a primary key, description, amount).
|
| I''ll need table(s) to denote which account numbers belong to which
| page/line on the report.
No you don''t.
| I''m not sure how many pages the report will
| be, but let''s say my Excel workbook would have 50 sheets.
You must have shares in the local paper-mill :-)
| My question
| is this: What would you recommend for a table structure. The way I
| see it, I could have a single table listing each page and each line on
| each page (each identified by a unique id), then have another table
| listing each account and each page/line id. The other option I see is
| to have a separate table for each "page," but I''m not sure I see a
| benefit in this. My first instinct is to use the first method I
| mentioned, but I wanted someone else''s opinion before I moved on.
您只需要包含原始数据的表格。将数据带到一起并对其进行排序的查询。一种将查询结果保存到
a CSV文件和Excel中的宏来格式化和设置小计的方法
分组。
我非常怀疑电子表格中的试算余额将超过32,000个单元格，所以所有这些都应该放在一张纸上。
--------- -------------------------------------------------- ----
jn****@yourpantsbigpond.net.au ：脱掉裤子回复
------------------------------------------- --------------------
All you need is the tables containing your raw data. A query to bring
the data together and sort it. A method of saving the query result to
a CSV file and a macro in Excel to format and set the Subtotals
grouping.
I seriously doubt that a trial balance would go over 32,000 cells in
the spreadsheet so all should fit on a single sheet.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
2003年11月9日20:12:26 - 0800，邮寄。 database.mysql
mi*******@hotmail.com （Michael Malinsky）写道：
On 9 Nov 2003 20:12:26 -0800, in mailing.database.mysql
mi*******@hotmail.com (Michael Malinsky) wrote:
|我正在尝试创建一个从
|获取信息的数据库一个（也许两个）表并利用该信息返回
|查询Excel中设计的报表。
您将使用哪种语言访问数据库？
|我的一般想法是：
|
| 主要或来源或来源表很简单。这是试算平衡
| （帐号作为主键，描述，金额）。
|
|我需要用表来表示哪个帐号属于哪个帐号？报告上的页面/行。
不，你不是。
|我不确定报告会有多少页面是的，但是让我说我的Excel工作簿将有50张。
您必须拥有当地造纸厂的股份:-)
|我的问题
|是这样的：你会推荐一个表格结构。我的方式
|看到它，我可以有一个表格列出每一页和每一行
|每个页面（每个页面由唯一的ID标识），然后有另一个表格
|列出每个帐户和每个页面/行ID。我看到的另一个选择是
|每个页面都有一个单独的表格，但我不确定我是否看到了
|受益于此。我的第一直觉是使用我的第一种方法
提到了，但在我继续之前我想要别人的意见。
| I''m attempting to create a database which will take information from
| one (perhaps two) tables and utilize that information to return
| queries to a report designed in Excel.
What language will you be using to access the database?
| The general idea I have is this:
|
| The "primary" or "source" table is easy. This is a trial balance
| (account number as a primary key, description, amount).
|
| I''ll need table(s) to denote which account numbers belong to which
| page/line on the report.
No you don''t.
| I''m not sure how many pages the report will
| be, but let''s say my Excel workbook would have 50 sheets.
You must have shares in the local paper-mill :-)
| My question
| is this: What would you recommend for a table structure. The way I
| see it, I could have a single table listing each page and each line on
| each page (each identified by a unique id), then have another table
| listing each account and each page/line id. The other option I see is
| to have a separate table for each "page," but I''m not sure I see a
| benefit in this. My first instinct is to use the first method I
| mentioned, but I wanted someone else''s opinion before I moved on.
您只需要包含原始数据的表格。将数据带到一起并对其进行排序的查询。一种将查询结果保存到
a CSV文件和Excel中的宏来格式化和设置小计的方法
分组。
我非常怀疑电子表格中的试算余额将超过32,000个单元格，所以所有这些都应该放在一张纸上。
--------- -------------------------------------------------- ----
jn****@yourpantsbigpond.net.au ：脱掉裤子回复
------------------------------------------- --------------------
All you need is the tables containing your raw data. A query to bring
the data together and sort it. A method of saving the query result to
a CSV file and a macro in Excel to format and set the Subtotals
grouping.
I seriously doubt that a trial balance would go over 32,000 cells in
the spreadsheet so all should fit on a single sheet.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jeff North< jn **** @ yourpantsbigpond.net.au> ;在消息新闻中写道：< 7q ******************************** @ 4ax.com>。 ..
Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<7q********************************@4ax.com>. ..
2003年11月9日20:12:26 -0800，在mailing.database.mysql
mi ******* @ hotmail.com （Michael Malinsky）写道：
On 9 Nov 2003 20:12:26 -0800, in mailing.database.mysql
mi*******@hotmail.com (Michael Malinsky) wrote:
|我正在尝试创建一个从
|获取信息的数据库一个（也许两个）表并利用该信息返回
|查询Excel中设计的报告。
您将使用什么语言访问数据库？
| I''m attempting to create a database which will take information from
| one (perhaps two) tables and utilize that information to return
| queries to a report designed in Excel.
What language will you be using to access the database?
我已经在Excel中有一个用户定义的函数来完成
数据的回溯。
I already have a user defined function in Excel to accomplish the
retreival of data.
|我的一般想法是：
|
| 主要或来源或来源表很简单。这是试算平衡
| （帐号作为主键，描述，金额）。
|
|我需要用表来表示哪个帐号属于哪个帐号？报告上的页面/行。
不，你不是。
| The general idea I have is this:
|
| The "primary" or "source" table is easy. This is a trial balance
| (account number as a primary key, description, amount).
|
| I''ll need table(s) to denote which account numbers belong to which
| page/line on the report.
No you don''t.
是的我（我认为）...来自试算表的几个帐户将
加在一起，在Excel中创建一个结果。
Yes I do (I think)...several accounts from the trial balance will be
added together to create one result in Excel.
|我不确定报告会有多少页面是的，但是让我说我的Excel工作簿会有50张。
你必须在当地的造纸厂拥有股票： - ）
| I''m not sure how many pages the report will
| be, but let''s say my Excel workbook would have 50 sheets.
You must have shares in the local paper-mill :-)
Not我的想法。 :-)
Not my idea. :-)
|我的问题
|是这样的：你会推荐一个表格结构。我的方式
|看到它，我可以有一个表格列出每一页和每一行
|每个页面（每个页面由唯一的ID标识），然后有另一个表格
|列出每个帐户和每个页面/行ID。我看到的另一个选择是
|每个页面都有一个单独的表格，但我不确定我是否看到了
|受益于此。我的第一直觉是使用我的第一种方法
提到了，但在我继续之前我想要别人的意见。
| My question
| is this: What would you recommend for a table structure. The way I
| see it, I could have a single table listing each page and each line on
| each page (each identified by a unique id), then have another table
| listing each account and each page/line id. The other option I see is
| to have a separate table for each "page," but I''m not sure I see a
| benefit in this. My first instinct is to use the first method I
| mentioned, but I wanted someone else''s opinion before I moved on.
所需要的只是包含原始数据的表格。将数据组合在一起并对其进行排序的查询。一种将查询结果保存到Excel中的CSV文件和宏来格式化和设置小计分组的方法。
All you need is the tables containing your raw data. A query to bring
the data together and sort it. A method of saving the query result to
a CSV file and a macro in Excel to format and set the Subtotals
grouping.
原始数据=试算平衡表和表格列出
报告中的页面/行，对吗？但是，我不需要第三张表格，例如，对于
例子，列出帐户100和150将合计在页面上
1行5？
我非常怀疑电子表格中的试算平衡会超过32,000个单元格，因此所有单元都应该放在一张纸上。
----------- -------------------------------------------------- -
jn****@yourpantsbigpond.net.au ：脱掉裤子回复
------------------------------------------------- --------------
Raw data = trial balance table and table listing the pages/lines in
the report, right? But don''t I need a third table that would, for
example, list that account 100 and 150 would be totaled to be on page
1 line 5?
I seriously doubt that a trial balance would go over 32,000 cells in
the spreadsheet so all should fit on a single sheet.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
这篇关于准备报告的数据库结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
