How to create Manual Matrix Layout in Oracle Reports ?

As salamualikum (islamic greetings), brothers and sisters. :)

  Hope you are well with the grace of Almighty Allah (swt).

 If you want to create Matrix Layout manually, then follow the bellow steps.

To make manual Matrix layout

You need two Repeating Frame

1.            Down

2.            Across

Now, From Insert Menu click, Matrix Layout.

Done. Another Frame will create in between Across and Down.

Hope you done and enjoy.

All the praises to Almighty Allah (swt)

Pray for me to Almighty Allah (swt) to keep it up and for my hereafter.

Microsoft ODBC error when connecting with Oracle Database 11gR2

As salamualikum (islamic greetings), brothers and sisters. :)

 Hope you are fine.. 

Not very useful for everybody but it's a solution if you need.

If you connection with Access with Microsoft ODBC  communication with HS file configuration (may look at How to Connect Oracle Database with Microsoft Access Database? )

using oracle Database 11g or above, you must specify Operation System (OS) User Name and Password.

Otherwise you will get error like.

Exiting hgolgon, rc=28513 at 2015/05/13-18:40:37 with error ptr FILE:hgolgon.c LINE:739 ID:Memory allocate

 So, simple solution is appropriate configuration.

Example:

CREATE PUBLIC DATABASE LINK “TESTDB”    
CONNECT TO "Administrator"      --- OS user name
IDENTIFIED BY "admin123"           --- OS password
USING 'TESTDB';

 Hope this works.. Hamid :)