You’re offline. This is a read only version of the page.
700
Hi all,
I have to create a report in which no of lines printed should be equal to total no of JOB TASKS present in the system.
I have to display the data from JOB, JOB TASK and JOB PLANNING LINE dataitems or tables.
What should be the correct structure of the data items in the code to meet the business requirements?
These tables already have the fields present to interconnect them.
Please suggest me a solution.
Thanks in advance.
For the number of lines you have to create a group and use Ceiling and RowNumber function, not sure if those functions will take the variable value instead of a fixed number.
Try to get the count of the Tasks and add that as variable to your dataset and check if the group will accept it. I doubt. Best of luck.
www.sqlchick.com/.../displaying-fixed-number-of-rows-per-ssrs-report-page.html
Yes, I am referring to no of lines displayed on the page.
And I have to link job, Job Task and job planning line.
What do you mean by rows equal to No. of job tasks? if you link job and job task it will show only the number of job tasks available. Are you referring no. of lines on the page?
Review Report 1006 Job - Planning Lines. We already have a standard report to display tasks and planning lines.
No, I don't need to start every job on new page, rather my requirement is that, the report should have rows equal to the no of job tasks.
I just need to know the correct sequence of dataitems to be implemented in the code.
I have to display the data from job, Job Task and job planning line tables.
It looks like your requirement is to break the report by Job and start every job on the new page, you just need to enable page break for the Job DataItem.
Your main dataitem should be Job and then connect planning lines and task based on the Job No. and in RDLC add the page break for the Job No.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (