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.

Pravin Ghadge · Answer

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

Nel · Answer

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

Pravin Ghadge · Answer

r u getting some kind of error? if no then how does ur report is looking now?

Nel · Answer

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) ;

Dhaval Patel · Answer

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

Nel · Answer

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.

Dhaval Patel · Answer

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