Trying to have a report witjin another report, cant figure out how to do it.

hi,

i’m trying creat medical report.  all fields have 1 item, except medications can list of different medications.

i have 2 tables , record , medications.  the medction has record id points id of record table.

first created simple data souec, select * dbo.record.  then put table on report , drag firlds over.  this producs spreed sheet reeport of report fields. 

 

i cannot figure out how list medciations perting each record row.

 

i tried creating simple join id record table equaling recordid firled in medications,

well made empty report.

i’v done in access using embed reports, there way this????

hi ted,

thanks question , sandip’s suggestion. based on description, guess created report using wizard. if didn’t close design surface of report yet, click undo button rollback incorrect actions. click edit button in menu, click undo. if had closed design surface of report, re-design missed data window.

this msdn article has detail steps of how design 1 basic report, please refer it:

tutorial: creating basic table report (ssrs)

if have questions when develop report, please let know.

thanks,
sharp wang

---

please remember mark replies answers if , unmark them if provide no help.

SQL Server  >  SQL Server Reporting Services, Power View