Good Day, I have a Datareport designed in A3 size. Is there a way to print the report in A4 without having to re-design it again manually to fit in A4 size? I have lots of A3 size reports which needs to be converted All in A4. It would be better if there a way to autofit the report directly in A4 and print it. Thanks for Helping!

Member Avatar
Member Avatar
+0 forum 1

good day... did any anyone know how to put the filtered items in listview into a data report? TIA

Member Avatar
+0 forum 0

please i need help on making data report which the database is access 2007 with accdb format. what connection will i use and how and sample codes. thanks a lot in advance.

Member Avatar
Member Avatar
+0 forum 2

Guys! im doing a search program where in ill just search the name of the product then print it. [CODE] Private Sub txtSearch_Change() rsTransaction.Close rsTransaction.Open "select * from tblTransaction where mid$(Date,3,2) like '" & txtSearch.Text & "%'", con, 3, 2 end sub [/CODE] it is actually doing fine but i really dont know how to print that selected item on datareport? i try to do it but it print the whole table on the database to the page. i just want to make a daily report of my database :( help me please?

Member Avatar
Member Avatar
+0 forum 1

in data environment I write code[CODE]SELECT AccountInfo.incategory, Sum(AccountInfo.InAmount) AS SumOfInAmount FROM AccountInfo where Date and Date between DTFr.value and DTTo.vlaue GROUP BY AccountInfo.incategory;[/CODE] in form I write code in a command button like:[CODE]Private Sub Command2_Click() Load DataEnvironment1 With DataEnvironment1 If .Command3.State <> 0 Then .Command3.Clos .Command3 Format(DTFr.Value, "dd/mm/yyyy"), Format(DTTo.Value, "dd/mm/yyyy") End With datareport1.Show End Sub[/CODE] in this form I have two dtpicker. when I run the project , I select two date from this two dtpicker and press the button then a msg show:[CODE]compile error: argument not optional[/CODE] then highlight this [CODE] If .[COLOR="Red"]Command3.[/COLOR]State <> 0 Then .Command3.Close[/CODE] please help …

Member Avatar
+0 forum 0

The End.