How do i display Values Horizonatally In Crystal Reports
-
I'm new to crystal report and currently is using CR Ver. 10 to develop my project. I would like to know how can i make my report to display data from db in horizontal with maximum of 3 rows of data per page. My sql command look something as below: select personid, personname, personfname, personlname, personmname from person_tab It should display as template below: PERSON REPORT ID | ID 1 | ID 2 | ID 3 NAME | NAME 1 | Name 2 | Name 3 FIRST NAME | First Name 1 | First Name 2 | First Name 3 LAST NAME | Last Name 1 | Last Name 2 | Last Name 3 MID NAME | Mid Name 1 | Mid Name 2 | Mid Name 3
-
I'm new to crystal report and currently is using CR Ver. 10 to develop my project. I would like to know how can i make my report to display data from db in horizontal with maximum of 3 rows of data per page. My sql command look something as below: select personid, personname, personfname, personlname, personmname from person_tab It should display as template below: PERSON REPORT ID | ID 1 | ID 2 | ID 3 NAME | NAME 1 | Name 2 | Name 3 FIRST NAME | First Name 1 | First Name 2 | First Name 3 LAST NAME | Last Name 1 | Last Name 2 | Last Name 3 MID NAME | Mid Name 1 | Mid Name 2 | Mid Name 3
you should used cross tab report type . it will available when u will add the report in own solution explorer. lets me know if any things is needed.