Correct Application?

[jgoodman00]

We currently have to produce a period report which contains mostly text, but with some data from a database of ours. It is currently produced from a Microsoft Word Template, but I dont like the way the user has to manually remember to refresh the linked table data.

The report is approximately 14 pages long of which approx 5 pages come directly from a SQL Server DB.

I tried creating a crystal reports report, & adding the text, but it seems to paste the text as a word document, so only a little of the data is actually printed.
Is this the expected behaviour?

Does it sound like crystal reports is the best program for producing this report, or is the word approach probably better suited due to the amount of text?




James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com

 

[blnora]

Hi

I would have thought this could be done in Crystal, but sounds like you have an error in creating your text box. It should be entirely possible to create a large text field, type your text into it, and also embed sql fields into the text as well. If you have a link to a word document, then you have moved more than simply text into your crystal report.

An alternative would be to write a Word macro which updates the data links when the document is opened.

My preference is for Crystal, as the user cannot accidentally change the report.

Good luck

Nora

 

[jgoodman00]

Ok thanks. I will take a look into Crystal more thoroughly...

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com