1

(3 replies, posted in Reports)

iwkom wrote:

What database are you using and how are the fields configured?

thanks for you attention and project is attached.
this is for "data" table and "data" form

2

(2 replies, posted in Script)

derek wrote:

So you want 2 copies of a print job?
If so, try
Form1.FrxReport.PrintOptions.Copies := 2;
Derek.

thanks very much for your help i will try and tell you

3

(3 replies, posted in Reports)

is there any way that if i save a field blank
in report preview in blank field show writer "null"????

field data type is integer and it's show 0 if  Field is empty

like

https://i.ibb.co/4FkgS9w/1.png

and i want like this

https://i.ibb.co/n3vdjvD/2.jpg

4

(2 replies, posted in Script)

i want a script that give automatically 2 print commands for each print job

5

(3 replies, posted in General)

sibprogsistem wrote:

Вам это нужно ?

procedure Data_OnKeyDown (Sender: TObject; var Key: Word; Shift, Alt, Ctrl: boolean);
begin
    if Key=13 then begin
    Data.SetFocusNextControl;
    Data.bSave.Default := False;
    end;
end;

procedure Info_Ctrl_OnKeyDown (Sender: string; var Key: Word; Shift, Alt, Ctrl: boolean);
begin
    if Key=13 then begin
    Info.SetFocusNextControl;
    end;
end;

procedure Form1_OnShow (Sender: TObject; Action: string);
begin
  Form1.frxReport.PreviewOptions.Buttons := pbPrint+pbLoad+pbSave+pbExport+pbZoom+pbFind+pbOutline+pbPageSetup+pbTools+pbEdit+pbNavigator+pbExportQuick+pbNoClose+pbNoFullScreen+pbNoEmail;
end;


begin
end.

not working

6

(3 replies, posted in General)

sibprogsistem wrote:

Вам это нужно ?

procedure Data_OnKeyDown (Sender: TObject; var Key: Word; Shift, Alt, Ctrl: boolean);
begin
    if Key=13 then begin
    Data.SetFocusNextControl;
    Data.bSave.Default := False;
    end;
end;

procedure Info_Ctrl_OnKeyDown (Sender: string; var Key: Word; Shift, Alt, Ctrl: boolean);
begin
    if Key=13 then begin
    Info.SetFocusNextControl;
    end;
end;

procedure Form1_OnShow (Sender: TObject; Action: string);
begin
  Form1.frxReport.PreviewOptions.Buttons := pbPrint+pbLoad+pbSave+pbExport+pbZoom+pbFind+pbOutline+pbPageSetup+pbTools+pbEdit+pbNavigator+pbExportQuick+pbNoClose+pbNoFullScreen+pbNoEmail;
end;


begin
end.

Thanks for you help i will check and tell you

7

(3 replies, posted in General)

M.V.D.B Solvers...........
i am working on a project but script is not working work only 1 script is working but i have insert 3 scripts.
https://i.ibb.co/k888jnB/D1.png

8

(30 replies, posted in General)

style menu is not working if we open a saved program directly. Style menu work only when we run application from desktop  shortcut.

9

(13 replies, posted in Reports)

ehwagner wrote:

I am not sure what you mean by

1.it means that there is no way for manually report designing.because a person that's don't know sql and pascal is M.V.D.B not for that.?????
2.in final project i will add many new fields in party table for details information.how about new fields??????
3.can we work on this project with out making Datasets???
4.if Datasets are necessary so is there any way after creating data sets can we use other fields normally in report for more detail see the image.

https://i.ibb.co/nBNvyFf/12a.png

5.when i edit your designed report  then in showing a error comes like.

https://i.ibb.co/KjHk9Hh/12b.png

10

(13 replies, posted in Reports)

ehwagner wrote:

bbrother,
See attached for a solution to your report. Select a record on the Form1 grid and click on NEW REPORT button.


Keep in mind that most all of us on the forum are volunteers and contributes whenever they can. Sometimes it may be a few days before somebody can respond. Personally I'm lucky if I can get on here once a week. I have my own clients to take care of and they come before this forum. So try to be a little patient. You'll get your answers from somebody.

good and thanks but can we use default report chekbox for more information????

11

(13 replies, posted in Reports)

ehwagner wrote:

bbrother,
See attached for a solution to your report. Select a record on the Form1 grid and click on NEW REPORT button.


Keep in mind that most all of us on the forum are volunteers and contributes whenever they can. Sometimes it may be a few days before somebody can respond. Personally I'm lucky if I can get on here once a week. I have my own clients to take care of and they come before this forum. So try to be a little patient. You'll get your answers from somebody.

thanks again and again i try and tell you.

12

(13 replies, posted in Reports)

i think the forum is helpless and thanks to all for your silence. keep the silence for better community.

derek wrote:

Hi,
If I understand your question correctly, you don't need to write any sqlquery.  Filtering a combobox based on the value of another combobox is standard MVD functionality.
Try using the 'parent combobox' property (see the screenshot in the attached example).
Derek.

hy dear derek can you help me in this project
http://myvisualdatabase.com/forum/viewtopic.php?id=7077

14

(13 replies, posted in Reports)

tcoton wrote:

There might be a bug with the implementation of the report module. I tried to redo the report with only one report on one field and this field is repeated 4 times!! Unless you write a SQL report, it is a massive headache to solve!!

For instance the table Tindola has only 2 records and the report shows 4 times the same 2 records.


Please Dmitry fix the report module !!

thanks dear for your replay and how about sql report?????

15

(13 replies, posted in Reports)

https://i.ibb.co/xSY96wj/p1-1.png

https://i.ibb.co/KF5Fnhs/p1-2.png






https://i.ibb.co/f8TwkDX/p2-1.png

https://i.ibb.co/xMvQ1QC/p2-2.png

16

(13 replies, posted in Reports)

is here any helper?????

17

(13 replies, posted in Reports)

https://i.ibb.co/vsKyDt9/p1.png


https://i.ibb.co/7NnrD5s/p2.png


https://i.ibb.co/fN56K5y/p3.png


project is attached in post one

i have a problem that's it.
i have a detailed data entry form.
but when i go to print then data is repeating automatically.
i have designed report like it.

https://i.ibb.co/ThZk13H/r1.png


but output  is repeating like it


https://i.ibb.co/j43mWgg/r2.png


and here is project with attach for all details

19

(0 replies, posted in General)

hy to all i am working on a project.
i want save data in many steps like.
help me and give your suggestions.
and i want  that ever new data entry automatic add in report detail.

20

(8 replies, posted in Reports)

problem solved thanks all.

21

(8 replies, posted in Reports)

screen shot

22

(8 replies, posted in Reports)

ehwagner wrote:

bbrother,
Welcome to MVD. There is a sum function in Fast Report to sum various columns in the detail bands of a report. If you could upload your project, it would be easier for people on this forum to provide solutions for you.

23

(8 replies, posted in Reports)

thanks but an example should better for understanding. And i will upload today my project.

24

(8 replies, posted in Reports)

M.V.D.B .in the report
i have question in two ways
1.how can we make total sum from many fields in 1 table
2.how can we make total sum form many field from many tables
thanks in advance.