How to make a report with vertical fields in the detail section not horizontal

Question

Hi,

I want to make a report where the fields would be placed vertically one after another, not horizontally as it is case when using the wizard for example.

Could anybody help me please?

Thank you in advance.

Answer 1

hi Nel,
Create 1 formula field as follows:

 'docnumb :' & {blagajna_jspturs.docnumb} & chr(13) &
 'Name :' & {blagajna_jspturs.Name} & chr(13) &
 'Sum :' & {blagajna_jspturs.Sum} & chr(13) &
'Currency :' & {blagajna_jspturs.Currency} & chr(13)

& drag it to the ur detail section

Answer 2

I didn't get any error, but I realised that I made mistake with the report.
The code you sent me works perfectly now.
THANK YOU very very much Pravin.
Regards

Answer 3

r u getting some kind of error?

if no then
how does ur report is looking now?

Answer 4

Thank you Pravin. I made the formula and dragged and dropped it in the details section. But it doesn't shows in the report.
Here is my code now:
'brdok :' & {blagajna_jspturs.brdok} & chr(13) &
 'data :' & {blagajna_jspturs.data} & chr(13) &
 'vp :' & {blagajna_jspturs.vp} & chr(13) &
'Imeprezime :' & {blagajna_jspturs.Imeprezime} & chr(13)&
'Iznos :' & {blagajna_jspturs.Iznos} & chr(13) &
 'valutaid :' & {blagajna_jspturs.valutaid} & chr(13) &
 'valutakurs :' & {blagajna_jspturs.valutakurs} & chr(13) &
'iznosden :' & {blagajna_jspturs.iznosden} & chr(13) &
'br_kas_izvod :' & {blagajna_jspturs.br_kas_izvod} & chr(13) &
 'br_patna_ska :' & {blagajna_jspturs.br_patna_ska} & chr(13) &
 'tip :' & {blagajna_jspturs.tip} & chr(13) ;

Answer 5

Dear Nel

Refer below link for whole description about vertical field

http://msdn.microsoft.com/en-us/library/bb395166%28v=sql.90%29.aspx

http://www.forumtopics.com/busobj/viewtopic.php?p=632394

Thanks & regards
dhaval patel

Answer 6

Dear Patel,

I want the fields to be displayed like  this:

docnumb        1
Name              Nel
Sum               1000
Currency          Eur
ValueCurr        62
Type                ssss


instead  of:

docnumb        Name        Sum        Currency        ValueCurr        Type
1                    Nel            1000        Eur                62                   ssss

I don't understand where to put this code  ({tbl.field},",",chr(13))
in the Crystal Report. Would you be so kind  please to tell me?


I have this code in the form where I call the  report.

ReportDocument Rpt = new  ReportDocument();
             Rpt.Load(@"c:\Blagajna-JSPTURS1\Blagajna-JSPTURS\CrystalReport1.rpt"); 

             crystalReportViewer1.SelectionFormula = "{blagajna_jspturs.brdok} =" +  textBox1.Text;
             crystalReportViewer1.ReportSource = Rpt;

Rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
             crystalReportViewer1.Refresh();

But I don't know how to make the report look like I describe you above, with  the fields placed vertically.

Thank you very much.

Answer 7

Dear Nel

are you want to rusult like this

row1 : 1
         2
         3
row2 : 4
         5
         6
row3 : 7
         8
         9
Using this  replace({tbl.field},",",chr(13))
i Hope it help you.

Thanks & regards
dhaval Patel