Search found 8466 matches

by Sergey Tkachenko
Fri Mar 05, 2021 6:30 pm
Forum: Report Workshop
Topic: Cross tabulation table with day of week as header
Replies: 8
Views: 4320

Re: Cross tabulation table with day of week as header

As for the second table, it looks even more complicated. It can be built only if you prepare a table or a query with the fields: - Factory - Month - DayOfWeek - Hour - AmountSoldByThisFactoryInThisMonthAndThisDayOfWeekAndThisHour. And even then, it will not look exactly like in your example: month n...
by Sergey Tkachenko
Fri Mar 05, 2021 6:18 pm
Forum: Report Workshop
Topic: Cross tabulation table with day of week as header
Replies: 8
Views: 4320

Re: Cross tabulation table with day of week as header

Well, I remembered that RW has a very similar example, on sakila (film rental) database: "<TRichView Dir>\ReportWorkshop\Demos\Reports\MySQL\sakila\Crosstab Customers x PG Rating.rw" It displays a crosstab (customer x film rating), showing the count of films having the given rating ordered...
by Sergey Tkachenko
Fri Mar 05, 2021 11:06 am
Forum: Report Workshop
Topic: Cross tabulation table with day of week as header
Replies: 8
Views: 4320

Re: Cross tabulation table with day of week as header

Do you use SQL database? Does it support DATEPART function? If yes, "fields" can be created directly in a data query in RW. Something like: select DATEPART(hour, TimeOfSale) as HourOfSale, DATEPART(weekday, TimeOfSale) as WeekDayOfSale ... Otherwise, I can make improvements in RW. Currentl...
by Sergey Tkachenko
Thu Mar 04, 2021 10:01 pm
Forum: Report Workshop
Topic: Cross tabulation table with day of week as header
Replies: 8
Views: 4320

Re: Cross tabulation table with day of week as header

Well, probably something may be done regarding (factory x days of week) crosstab. Cell in crosstab may contain sub-reports. So, when we found what some factory has invoices in the specified day of week (that gives us a specific crosstab cell), in this cell we can execute a data query that calculates...
by Sergey Tkachenko
Thu Mar 04, 2021 9:32 pm
Forum: Report Workshop
Topic: Cross tabulation table with day of week as header
Replies: 8
Views: 4320

Re: Cross tabulation table with day of week as header

RW can create a crosstab where rows correspond to invoices, columns to days of weeks. Something like this: invcrosstab.png Working hours can be added too. However, it is simple to implement only if you use SQL with DATEPART() function. Otherwise, some modification in RW are needed to allow matching ...
by Sergey Tkachenko
Tue Mar 02, 2021 5:30 pm
Forum: RVMedia
Topic: RvMedia UseData save example help
Replies: 1
Views: 1274

Re: RvMedia UseData save example help

Sorry, please explain what you want to implement with more details.

Do you want RVMedia to read GPS info from USB? Sorry, it is not supported and not planned.
Do you read GPS info yourself and want to add it as a text on video? Or something else?
by Sergey Tkachenko
Fri Feb 26, 2021 7:51 am
Forum: RVMedia
Topic: Can you give us a clue when the next RVMeda update will be released?
Replies: 1
Views: 1327

Re: Can you give us a clue when the next RVMeda update will be released?

Probably end of this Spring, but I am not sure.
It will include one of:
- FMX for Linux
- ONVIF
- reading sound from videos using FFmpeg/GStreamer
- streaming in standard formats using FFmpeg/GSteamer
by Sergey Tkachenko
Tue Feb 23, 2021 3:03 pm
Forum: Support
Topic: block edit after print
Replies: 9
Views: 8968

Re: block edit after print

Unfortunately, these protection options cannot be saved in RTF
by Sergey Tkachenko
Fri Feb 19, 2021 9:29 am
Forum: Support
Topic: RTl with LTR alignment at the end of a line problem
Replies: 6
Views: 8276

Re: RTl with LTR alignment at the end of a line problem

I sent modified TRichView files to the email in your profile. It includes changes in saving text BiDiMode in DocX, and some other changes.
Replace the files in TRichView\Source\
by Sergey Tkachenko
Thu Feb 18, 2021 5:36 pm
Forum: Support
Topic: block edit after print
Replies: 9
Views: 8968

Re: block edit after print

In which format do you save?
These protection options can be stored only in RVF format.
by Sergey Tkachenko
Thu Feb 18, 2021 8:29 am
Forum: Support
Topic: block edit after print
Replies: 9
Views: 8968

Re: block edit after print

Use one more text protection option, rvprParaStartProtect, it protects from Enter. There are no visual differences in protected text. You can use TRVStyle.OnDrawStyleText to modify text drawing, if its protection is not empty. For example, you can draw a border around it. For TSRichViewEdit, assign ...
by Sergey Tkachenko
Wed Feb 17, 2021 9:14 am
Forum: Support
Topic: block edit after print
Replies: 9
Views: 8968

Re: block edit after print

By the way, if you use incremental printing feature, and want to allow to enter text to the end of the last line, it may be not good. Obviously, you cannot use it for centered, right-aligned and distributed paragraphs (if the last line is distributed as well), because new text in the last line will ...
by Sergey Tkachenko
Wed Feb 17, 2021 9:08 am
Forum: Support
Topic: block edit after print
Replies: 9
Views: 8968

Re: block edit after print

As for me, the only simple and reliable solution is moving the printed part to a read-only TRichViewEdit or in TRichView, and to allow entering the rest of text in a separate editor. Seriously, consider using this method. If you still want to use a single editor, it may be not very simple. I can des...
by Sergey Tkachenko
Mon Feb 15, 2021 4:53 pm
Forum: Support
Topic: RTl with LTR alignment at the end of a line problem
Replies: 6
Views: 8276

Re: RTl with LTR alignment at the end of a line problem

I fixed it only DocX. Currently, I do not know how to fix it in RTF.
If you want, I can send changed units to you.
by Sergey Tkachenko
Sat Feb 13, 2021 6:39 pm
Forum: Support
Topic: GetSelText -A -W
Replies: 2
Views: 5792

Re: GetSelText -A -W

When getting a text of selected fragment, most non-text items (such as footnotes) are not included. If you want to get selected text with all non-text items (for footnotes, it will be not a number but all footnote text inside []) you can use SaveTextToStream/SaveTextToStreamW to save text to a strea...