| Author |
Topic |
|
LarryC74
Yak Posting Veteran
94 Posts |
 Posted - 2010-01-13 : 11:53:03
|
| Hi,I have a query that I want to print off each individual record but it only allows me to print one at a time.What is going on with that? is it possible to print multiple records at once?Larry |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 11:56:27
|
| how are you showing records currently? one per page or one at a time in report?SQL Server MVP |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-13 : 11:57:07
|
How do you try to print the records of your query?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-13 : 12:04:06
|
| It is only showing "one" and the record selectors at the top only say 1 of 1.I print either PDF or EXCEL but both only print 1 record. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 12:06:46
|
quote:
Originally posted by LarryC74
It is only showing "one" and the record selectors at the top only say 1 of 1.I print either PDF or EXCEL but both only print 1 record.
then that means report just has 1 page with single record. then how do you expect it to print more? i think what you need is to tweak report logic to show all records you're interested inSQL Server MVP |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-13 : 12:18:01
|
| Here is the query...(built off a view)Select *From LifeNetDatathis shows a total of 300+ records |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-13 : 12:25:43
|
| When I created the report, I took off the word "First" in front of the fields...but that didn't change anything.I tried to upload a screen shot but when I hit the button it only did this [img][\img]... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 12:26:02
|
quote:
Originally posted by LarryC74
Here is the query...(built off a view)Select *From LifeNetDatathis shows a total of 300+ records
and how many does report show?SQL Server MVP |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-13 : 12:34:36
|
quote:
Originally posted by LarryC74
When I created the report, I took off the word "First" in front of the fields...but that didn't change anything.I tried to upload a screen shot but when I hit the button it only did this [img][\img]...
Upload your screenshot to a free provider and then put the link to that file between the img-tags.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 12:38:56
|
quote:
Originally posted by LarryC74
When I created the report, I took off the word "First" in front of the fields...but that didn't change anything.I tried to upload a screen shot but when I hit the button it only did this [img][\img]...
seems like you've put expression in footer or header or have applied some kind of grouping. can you check that. in your case, expression needs to be added to detail row of containerSQL Server MVP |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-13 : 13:27:56
|
I double checked the view and there are no grouping or order by clauses...See screen shot for report layout. Below is the "From statement" in the view...Select fields....FROM dbo.Patient AS p LEFT OUTER JOIN dbo.DonorReferral AS dr ON dr.PatientId = p.Id LEFT OUTER JOIN dbo.Referral AS r ON r.Id = dr.ReferralId Join Contact c3 ON r.TakenByContactID = c3.ID LEFT OUTER JOIN approachConsent apc ON p.ID = apc.PatientID LEFT OUTER JOIN AuthorizationInfo AS ai ON ai.PatientId = apc.PatientId LEFT OUTER JOIN Contact AS c2 ON c2.Id = ai.RequestMadeBy LEFT OUTER JOIN dbo.[Authorization] AS a ON a.PatientId = p.Id LEFT OUTER JOIN dbo.IntraoperativeManagementORTeams AS im ON p.Id = im.PatientId LEFT OUTER JOIN dbo.Contact AS c ON im.OpoStaff1 = c.Id LEFT OUTER JOIN dbo.Contact AS c1 ON im.OpoStaff2 = c1.Id LEFT OUTER JOIN dbo.Organization AS ro ON ro.Id = r.ReferringOrganizationId LEFT OUTER JOIN dbo.IntraoperativeManagement AS imp ON imp.PatientId = p.Id LEFT OUTER JOIN dbo.AdmissionCourse AS ac ON ac.PatientId = p.PatientId LEFT OUTER JOIN dbo.Organization AS o ON r.ReferringOrganizationId = o.Id LEFT OUTER JOIN [Authorization] au ON au.patientID = p.ID LEFT OUTER JOIN HospitalPersonnel AS hp ON p.PatientId = hp.PatientId LEFT OUTER JOIN ApproachConsent AS ac1 ON p.Id = ac1.PatientId Left Outer Join MedicalExaminerCase MEC On MEC.patientID = p.ID |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 13:30:59
|
| what are parameters of report? is it showing details for a patient?SQL Server MVP |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-13 : 13:41:28
|
| Only a date range @From and @Toyes..it is details of a patient. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 13:45:01
|
quote:
Originally posted by LarryC74
Only a date range @From and @Toyes..it is details of a patient.
ok so coming back to your earlier question were you trying to print more than one patients detail?SQL Server MVP |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-13 : 13:53:50
|
| Yes...ideally I would like to see record 1 of 30 at the top.so if we were looking at the report, it would show me the first one then I click on next record and it changes to the next one. I would like to be able to print to PDF and it print all records in one PDF. is that possible? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 13:58:54
|
quote:
Originally posted by LarryC74
Yes...ideally I would like to see record 1 of 30 at the top.so if we were looking at the report, it would show me the first one then I click on next record and it changes to the next one. I would like to be able to print to PDF and it print all records in one PDF. is that possible?
try setting interactive height to 0 and then printingSQL Server MVP |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-13 : 14:07:13
|
| Tried that...still didn't work. Tried the ht "0" and width "0", then just the ht "0"... :( |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-13 : 14:24:16
|
| I was just playing around with a table, where I select "All" records...put a couple of fields on a report and it still doesn't show all the records. There was NO grouping, ordering or anything like that.it was:Select * From patientI am beginning to think it can't be done. :( |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-14 : 02:09:06
|
quote:
Originally posted by LarryC74
I was just playing around with a table, where I select "All" records...put a couple of fields on a report and it still doesn't show all the records. There was NO grouping, ordering or anything like that.it was:Select * From patientI am beginning to think it can't be done. :(
what do you mean by you select all records? what were values passed for parameters? |
|
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2010-01-14 : 07:44:24
|
| The only parameters that are passed are a date range.I just did that quick query to see if I was doing something different that the other query. all the records show up if I put them in a table, but what I am looking for is a PDF report for each individual record. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-14 : 09:57:57
|
quote:
Originally posted by LarryC74
The only parameters that are passed are a date range.I just did that quick query to see if I was doing something different that the other query. all the records show up if I put them in a table, but what I am looking for is a PDF report for each individual record.
ok. then what was the purpose of your original question?is it possible to print multiple records at once? |
|
|
|
Next Page
|
Print Multiple Records