Search options (Page 1 of 3)

Hi anybody,

can you please help me :

procedure FmReport_BtTest_OnClick (Sender: string; var Cancel: boolean);
var
    frxDBDataset1, : TfrxDBDataset;
    report : TDataSet;
begin
   SQLQuery('SELECT xy from xy where xy');
    frxDBDataset1 := TfrxDBDataset.Create(Form1);
    frxDBDataset1.UserName        := 'report';
    frxDBDataset1.CloseDataSource := True;
    frxDBDataset1.OpenDataSource  := True;
    frxDBDataset1.DataSet         := report;

    Form1.frxReport.Clear;
    Form1.frxReport.DataSets.Clear;
    Form1.frxReport.DataSets.Add(frxDBDataset1);

  //    DESIGN MODE - WORKING OK
 //  Form1.frxReport.LoadFromFile(ExtractFilePath(Application.ExeName)+'Report\test.fr3');
 //  Form1.frxReport.DesignReport;

   // OPEN REPORT IN Excel  NOT WORKING
    Form1.frxReport.LoadFromFile(ExtractFilePath(Application.ExeName)+'Report\test.fr3');
    Form1.frxReport.PrepareReport();
    Form1.frxRTFExport1.FileName := ChangeFileExt(GetTempFileName,'.xlsx');
    Form1.frxRTFExport1.ShowDialog := False;
    Form1.frxReport.Export(Form1.frxRTFexport1);

    // PREVIEW MODE  - WORKING OK
 //     frxDBDataset1.DataSet.Close;
 //    Form1.frxReport.LoadFromFile(ExtractFilePath(Application.ExeName)+'Report\test.fr3');
 //    Form1.frxReport.ShowReport;

    frxDBDataset1.Free;

end;

1.OPEN REPORT IN Excel  NOT WORKING i dont know why error message is:
"Excel cant open the file xy.xlsx becouse file format or its extension is invalid"

Please where is the problem ?
In the forum a find only open in PDF..

2.And the another question:
When the SQLQuery is too long. How can i write him on more rows ?

Thx,
Krokodil

Hi anybody,

Please can you help where is the problem.

MYSQL

Select NameList_name from NameList where NameList.id In 
(Select NameList.id from NameList where id_company =
(Select company.id From company where company_company Like "XY"))
And
(Select id_NameList from NameListGoods where id_NameListGoodsKind =
(Select NameListGoodsKind.id from NameListGoodsKind where NameListGoodsKind_NameListGoodsKind LIKE "XX"))
And
(Select id_NameList from NameListStateFrom where id_StateFrom =
(Select StateFrom.id from StateFrom where StateFrom_state Like "XXX"))
And
(Select id_NameList from NameListStateTo where id_StateTo =
( Select StateTo.id from StateTo where StateTo_state Like "XYX"));   

This returned me ""SQL Server Subquery returned more than 1 value""

I want to search in:
Select NameList_name from NameList where NameList.id
The right NameList.id penetrance
what is returned from others subquery.

Example:
Table Namelist:
ID   Name
1    a
2    b
3    c
4    d
5    e

subquery1 :
(Select NameList.id from NameList where id_company =
(Select company.id From company where company_company Like "XY"))
Return me : numbers : 1,4,5

subquery2 :
(Select id_NameList from NameListGoods where id_NameListGoodsKind =
(Select NameListGoodsKind.id from NameListGoodsKind where NameListGoodsKind_NameListGoodsKind LIKE "XX"))
Return me : numbers 2,4,3

subquery3 :
(Select id_NameList from NameListStateFrom where id_StateFrom =
(Select StateFrom.id from StateFrom where StateFrom_state Like "XXX"))
Return me : numbers 3,4,1

subquery4 :
(Select id_NameList from NameListStateTo where id_StateTo =
( Select StateTo.id from StateTo where StateTo_state Like "XYX"));
Return me : numbers 5,4,2,1

Head Query
Penetrance from this results is number 4.Then i need to show me the Name from Namelist where Namelist.id=4;

Thx for help,

Hi,

can you please help me ?

1. Load table grid from database by script - That is OK BUT ...
2. How I can  to rewrite-change, grid values in table grid , by keyboard? Then  save it,like save record ’’save table grid as object’’ with one button

Thx for tips,

Krokodil