How do i approach to make this report ?

[Raghuvir]

Hi All,

Please find the attached file for your reference. We have go a report request to make a report with exact spacing which will be used to upload into another system.

Request you to guide me on how do we approach to build this report

Regards

[MFGF]

Hi All,

Please find the attached file for your reference. We have go a report request to make a report with exact spacing which will be used to upload into another system.

Request you to guide me on how do we approach to build this report

Regards

Hi,

The basic approach is going to be a layout using table cells, sized explicitly. You're probably going to have to use a monospaced font too. The trickiest challenge you face is in converting numbers into words, but thankfully there are some really clever people on Cognoise who have figured this out already and posted up a solution. In this instance Lynn comes to your rescue:

http://www.cognoise.com/index.php/topic,25948.msg82753.html#msg82753

Cheers!

MF.

[Raghuvir]

Hi,

The basic approach is going to be a layout using table cells, sized explicitly. You're probably going to have to use a monospaced font too. The trickiest challenge you face is in converting numbers into words, but thankfully there are some really clever people on Cognoise who have figured this out already and posted up a solution. In this instance Lynn comes to your rescue:

http://www.cognoise.com/index.php/topic,25948.msg82753.html#msg82753

Cheers!

MF.

Thank you so much MFGF. Was just thinking how would i get all the values on the exact line number ?

Regards

[MFGF]

Thank you so much MFGF. Was just thinking how would i get all the values on the exact line number ?

Regards

You need to measure the spacing on the page and use explicitly sized table cells (or blocks) with the relevant padding defined to position the contents exactly where you want them to be. Size and Overflow plus Padding can be defined using various measures - including points (1/72 of an inch) so you should be able to position things exactly where you need on the page if you measure carefully.

MF.

[Raghuvir]

You need to measure the spacing on the page and use explicitly sized table cells (or blocks) with the relevant padding defined to position the contents exactly where you want them to be. Size and Overflow plus Padding can be defined using various measures - including points (1/72 of an inch) so you should be able to position things exactly where you need on the page if you measure carefully.

MF.

Will initiate the work on making the report. Will ask for your guidance if i am stuck somewhere. Hope you dont mind.

Regards

[MFGF]

Will initiate the work on making the report. Will ask for your guidance if i am stuck somewhere. Hope you dont mind.

Regards

Just post questions to Cognoise as usual. :)

MF.

[Lynn]

Cognos is not an ETL tool.

Just sayin'