14,494 questions
Hi CycloneN-1979,
It seems your issue is more related to crystal report. I suggest you open a thread in the SAP Crystal Reports forum so that people there will help you more effectively.
Best Regards,
Amelia
Sequential report on one page for printing
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 64%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Cyclone_N
1
Reputation point
I'm trying to recreate a crystal report for a local clinic, where the admin staff print every appointment for that day. The sheet is small and designed to fit two per A4 sheet, yet I am unable to get ms report builder to produce sequential reports on the single page (I keep getting the same data set if I simply copy and paste the data set into another column). ![74546-reportbuilder.png][1] ![74503-crystal-report.png][2] [1]: /api/attachments/74546-reportbuilder.png?platform=QnA [2]: /api/attachments/74503-crystal-report.png?platform=QnA Is there a feature I have overlooked? Crystal reports has a simple section expert that formats with multiple columns.
SQL Server Other
{count} votes
-
Olaf Helper 47,436 Reputation points2021-03-05T06:26:35.183+00:00 Sorry, but for me it is not clear what your issue is and your screenshots don't help me to understand it. May can you explain it more detailed, e.g. with some examples, please?
-
Cyclone_N 1 Reputation point
2021-03-08T22:28:39.517+00:00 Hi Olaf, thanks for your response.
The clinic I'm working for prints out a sheet for every appointment with a doctor each morning. There are usually around 80 appointments for the day. In order to save resources we print 2 appointments per page in a landscape orientation, and cut the page in half.
I'm trying to get the report to print out these appointment cards in a sequential order, with two patients per page. Currently I cannot get the details to fill out the second patient, it just fills out two of the same patient (if I have two tables) and the next page is two of the next patient.
Crystal reports had an option to "format with multiple columns", which allowed for this. I can't find a way to replicate it.
Sign in to comment
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff2021-03-05T07:07:19.53+00:00 -
Cyclone_N 1 Reputation point
2021-03-08T22:05:42.017+00:00 Thanks Amelia, but I'm not using crystal reports, I'm trying to build a re-create the report in Microsoft report builder.
The problem is every time I try to create two reports on the same page, they're the same patient and appointment rather than a sequential patient and appointment.
I either need to find out how to continue the list on the same page, or make dual tables that follow each other in a sequence.
-
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
2021-03-09T07:49:56.67+00:00 Hi @Cyclone_N ,
Thanks for your reply.
Are you using SSRS?
If so, you can open a thread in the sql-server-reporting-services forum so that people there will help you more effectively. Please provide some sample data and report along with your expected result in detail in the new thread to help people understand your scenario.Best Regards,
Amelia
Sign in to comment -