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.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin GhadgePosted Jan 18, 2012, 3:51 AM
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
NelPosted Jan 23, 2012, 6:02 AM
The code you sent me works perfectly now.
THANK YOU very very much Pravin.
Regards
Pravin GhadgePosted Jan 20, 2012, 10:59 AM
if no then
how does ur report is looking now?
NelPosted Jan 20, 2012, 4:32 AM
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 PatelPosted Jan 18, 2012, 3:42 AM
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
NelPosted Jan 18, 2012, 2:00 AM
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 PatelPosted Jan 18, 2012, 12:17 AM
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