How to get patient information, page header, to appear on second page of report

  • NineIron

    SSChampion

    Points: 12515

    I have a report that works great except when it runs to a second page. I need to get the patient information, SchedProv, MRN, Name, to appear on the second page if there are too many medications to fit on one page. I have the medication data in a subreport. The ApptDate and SchedProv are used as parameters. Any thoughts? I've included some fake data.

    create table #T

    (

    SchedProv varchar(30),

    MRN varchar(30),

    ApptDate datetime,

    MedName varchar(100),

    MedDirection varchar(100),

    PatientName varchar(30)

    )

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','aaa2697','2018-10-25','Artificial Tears 0.1-0.3 % Ophthalmic Solution','INSTILL 1 DROP IN THE AFFECTED EYE(S) EVERY 2 HOURS.','Mouse, Mickey')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','aaa2697','2018-10-25','Fexofenadine HCl - 60 MG Oral Tablet','TAKE 60 MG Twice daily PRN','Mouse, Mickey')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','aaa2697','2018-10-25','Naproxen 500 MG Oral Tablet','TAKE 1 TABLET BY MOUTH EVERY 12 HOURS AS NEEDED','Mouse, Mickey')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','aaa2697','2018-10-25','Rosuvastatin Calcium 10 MG Oral Tablet','TAKE 1 TABLET AT BEDTIME','Mouse, Mickey')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','bb13662','2018-10-25','Lisinopril 5 MG Oral Tablet','TAKE 1 TABLET DAILY.','Duck, Daffy')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','bb13662','2018-10-25','Memantine HCl - 10 MG Oral Tablet','1 TAB BID','Duck, Daffy')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','bb13662','2018-10-25','Primidone 50 MG Oral Tablet','TAKE 1 TABLET IN THE MORNING','Duck, Daffy')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','bb13662','2018-10-25','Simvastatin 40 MG Oral Tablet','TAKE 1 TABLET EVERY DAY','Duck, Daffy')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Albuterol Sulfate (5 MG/ML) 0.5% Inhalation Nebulization Solution','USE 1 UNIT DOSE IN NEBULIZER EVERY 6 HOURS AS NEEDED.','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Atorvastatin Calcium 80 MG Oral Tablet','Take one tablet by mouth every day','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','BD Insulin Syr Ultrafine II 31G X 5/16" 1 ML','USE 4 TIMES A DAY','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Gabapentin 400 MG Oral Capsule','TAKE 1 CAPSULE BY MOUTH THREE TIMES DAILY','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','HumaLOG 100 UNIT/ML Subcutaneous Solution','Take 6-18 units TID premeals','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','HydroCHLOROthiazide 25 MG Oral Tablet','TAKE 1 TABLET BY MOUTH EVERY DAY','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Lantus 100 UNIT/ML Subcutaneous Solution','1 SAMPLE (LOT# - 6F216A, EXP - 5/2019)','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Lantus 100 UNIT/ML Subcutaneous Solution','Sample # 6F517A EXP: 10/2019','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Lantus 100 UNIT/ML Subcutaneous Solution','INJECT 50 UNITS UNDER THE SKIN AT BEDTIME','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Lisinopril 40 MG Oral Tablet','TAKE 1 TABLET BY MOUTH EVERY DAY','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Lisinopril 40 MG Oral Tablet','TAKE 1 TABLET BY MOUTH ONCE A DAY','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Montelukast Sodium 10 MG Oral Tablet','TAKE 1 TABLET BY MOUTH EVERY DAY','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','OneTouch Delica Lancets Fine','USE 3 TIMES DAILY DX:E11.4','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','OneTouch Verio In Vitro Strip','TEST 4 TIMES A DAY','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','OneTouch Verio w/Device Kit','USE DAILY DX: E11.4','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','ProAir HFA 108 (90 Base) MCG/ACT Inhalation Aerosol Solution','INHALE 2 PUFFS EVERY 4-6 HOURS, SPACED 60 SECONDS APART.','Mouse, Minnie')

    insert into #T(SchedProv, MRN, ApptDate, MedName, MedDirection, PatientName) values('Doctor','ss41692','2018-10-25','Symbicort 160-4.5 MCG/ACT Inhalation Aerosol','INHALE 2 PUFFS DAILY','Mouse, Minnie')

  • logitestus

    SSCrazy

    Points: 2766

    Have you tried to group the dataset in SSRS?  You can group on multiple columns for the tablix and then create a header row for the group (where the header row is the patient name, Provider, MRN, etc).  Next I would create a page break on x number of rows, say 10, and have the header repeat on each page break.

    Does this help?  Or do you need a visual break down of the steps I listed above?  BTW - Thanks for the data breakdown.

  • NineIron

    SSChampion

    Points: 12515

    thanx. I'll give it a try and if I run into any problems, I'll post back.

  • NineIron

    SSChampion

    Points: 12515

    Do I get rid of the column headers that default in?

  • NineIron

    SSChampion

    Points: 12515

    How do I create a page break?

  • logitestus

    SSCrazy

    Points: 2766

    Here is a link that I used to learn how to page break after X rows:  https://jeffprom.com/2012/05/11/ssrs-page-break-after-x-number-of-rows/

    The tablix group headers:
    1) if you want to delete the entire row, just click on any cell of the tablix then right-click on the grey-cell (see below) and select delete.  You should get a pop-up that asks if you want to delete the row only or the row and group.  Make sure to select the row only.

    2) if you want to delete the specific cell, just click on the specific cell and select delete.

  • NineIron

    SSChampion

    Points: 12515

    Thanx.

  • logitestus

    SSCrazy

    Points: 2766

    Just a curious question but did my suggestions/ideas work for you? Or did you go a different direction?

  • NineIron

    SSChampion

    Points: 12515

    I had to focus on some other stuff. Not sure when I'll get back to this.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply