質問する

Sparksvonrou's profile - activity

2018-09-12 01:15:39 +0200 バッジを受け取った  有名な質問 (source)
2018-02-27 18:25:13 +0200 バッジを受け取った  有名な質問 (source)
2016-07-27 18:45:02 +0200 バッジを受け取った  卓越した質問 (source)
2016-07-12 20:33:32 +0200 バッジを受け取った  有名な質問 (source)
2016-03-05 13:11:00 +0200 バッジを受け取った  卓越した質問 (source)
2016-02-09 23:09:16 +0200 バッジを受け取った  有名な質問 (source)
2015-12-04 17:42:56 +0200 バッジを受け取った  有名な質問 (source)
2015-11-01 23:26:29 +0200 バッジを受け取った  有名な質問 (source)
2015-10-08 13:23:00 +0200 バッジを受け取った  卓越した質問 (source)
2015-09-17 02:08:38 +0200 バッジを受け取った  人気の質問 (source)
2015-09-17 02:08:18 +0200 バッジを受け取った  人気の質問 (source)
2015-09-16 18:02:37 +0200 コメント付き回答 How do I view the SQL for a report so I can edit it in that view

Wanted to include a screen shot here but not sure how to. There are two different views depending on which report I try to edit.

2015-09-16 17:50:27 +0200 コメント付き回答 How do I view the SQL for a report so I can edit it in that view

I see a button at the bottom when I select edit on the report. That button is called design mode on/off Clicking that changes a fw greyed icons to be usable but nothing about SQL

2015-09-16 17:44:22 +0200 コメント付き回答 How do I view the SQL for a report so I can edit it in that view

There is no "Edit in SQL view" as listed in #4 above. When I click on Navigator it opens a small pop up window that has: Report Functions Page Header Groups Detail Page Footer...

I see no right hand panel

2015-09-16 04:06:38 +0200 質問をする How do I view the SQL for a report so I can edit it in that view

I can edit the report but do not see an option to edit it in SQL.

2015-09-16 03:54:49 +0200 コメント付き回答 How do I use input to select the criterion for a Query

I want to run the report and input which customer and which date the transactions I want reported are for. Using the current days date is fine so that could be auto and does not have to be a input.

2015-09-16 03:53:21 +0200 コメント付き回答 How do I use input to select the criterion for a Query

Ok can I use this in a report? That is what I really need to do. At them moment I have created queries for each customer number and then use that query to create the report. I have over a hundred customers and this is real cumbersome. What I am trying to do is print a report for each days transactions in a table and the report will be just for the customer I want the report for. Each transaction in the table has the customers number associated with who the transaction was for.

2015-09-16 03:48:03 +0200 質問をする How do I write a report that uses data from two tables.

I have one table that is customer info and purchase info. I created a query that is the sum of "totals" from the first table and in it is a table that has that info. When I write the report I have no problem but only one table is listed and I need the info from the second table to be available to the report also.

2015-09-16 02:22:40 +0200 バッジを受け取った  有名な質問 (source)
2015-09-12 21:54:56 +0200 バッジを受け取った  卓越した質問 (source)
2015-09-06 07:17:38 +0200 バッジを受け取った  人気の質問 (source)
2015-09-05 14:50:57 +0200 質問をする How do I use input to select the criterion for a Query

I have a table with numerous customers and their transactions entered as transactions per row. I wrote a query that I use to select a customer so I can see just their transactions. That is making their customer number the criterion for the query. What I want to do is be able to input the customer number once I start the query so I don't have to write many queries for each customer.

2015-09-01 05:40:32 +0200 バッジを受け取った  有名な質問 (source)
2015-08-30 03:06:11 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-29 15:24:56 +0200 コメント付き回答 Need help with Sum Function in Libre Base

How do I get SQL view for the report I am editing??

2015-08-29 15:24:32 +0200 コメント付き回答 Need help with Sum Function in Libre Base

Finally got the 5.0 version installed and now it complicated things. I am not longer able to use the same process I did to create my reports. I tried copying previous reports and can't find any place they go or how to paste them to create the duplicate. Also I used to be able to paste my company logo into the header and I can't do that any more either. The entire display is now graphic block instead of the previous display for editing the reports.

2015-08-28 23:06:52 +0200 バッジを受け取った  人気の質問 (source)
2015-08-28 21:55:17 +0200 バッジを受け取った  サポーター (source)
2015-08-28 16:15:15 +0200 質問をする How do I install Libre 5.0.1 on Ubuntu 14.04. LTS

I downloaded the pack and extracted it. I then went to the folder and did sudo dpkg -i *.deb The installation appeared to complete. I see no new Icons or any changes when I run the BASE and all is still the old version.

2015-08-25 18:06:52 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-25 18:06:52 +0200 バッジを受け取った  人気の質問 (source)
2015-08-25 18:06:33 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-25 18:06:33 +0200 バッジを受け取った  人気の質問 (source)
2015-08-25 17:54:33 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-25 17:54:33 +0200 バッジを受け取った  人気の質問 (source)
2015-08-21 22:04:06 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-21 21:57:29 +0200 バッジを受け取った  有名な質問 (source)
2015-07-30 10:45:26 +0200 バッジを受け取った  人気の質問 (source)
2015-07-17 22:41:27 +0200 バッジを受け取った  解説者
2015-07-17 22:41:27 +0200 コメント付き回答 Need help with Sum Function in Libre Base

Ok. I don’t see the Report Builder in the Software Center.

2015-07-17 22:39:13 +0200 コメント付き質問 Need help with Sum Function in Libre Base

Version: 4.2.8.2 Build ID: 420m0(Build:2)

2015-07-11 17:28:18 +0200 コメント付き回答 Need help with Sum Function in Libre Base

Thank you. I loaded the sample and understand now that putting the Sum function in a seperate table makes the Sum function work. For some reason the Report can not be edited or opened. Could you check that?

2015-07-10 23:55:40 +0200 コメント付き質問 Need help with Sum Function in Libre Base

Ok. Maybe I am missing something. I see this as Oracle Report Builder. I do not see that on my setup and neither do I see the function for reports.

2015-07-10 12:10:50 +0200 バッジを受け取った  卓越した質問 (source)