Databases
StackOverflow2013
Postsdbo
POSSRS Report - Specific Format
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSSRS Report - Specific Format
    primarykey
    data
    text
    <p>I have a table Project.</p> <pre><code> ProjID Proj_task 1 NIT 2.0 2 SSRS </code></pre> <p>I have table called Project_Task.</p> <pre><code> ProjID Task_DS User 1 task1 User1 1 task2 User2 1 task3 User3 2 task4 User4 2 task5 User5 2 task6 User6 </code></pre> <p>I want to generate Report in Below format. (Each project ID inforamtion should be in one Page for which i am using Insert Group )</p> <p>In Page 1:</p> <pre><code> ProjID : 1 Proj_task: NIT 2.0 -------------------- User Task_DS User1 task1 User2 task2 User3 task3 </code></pre> <p>In Page 2:</p> <pre><code> ProjID : 2 Proj_task: SSRS -------------------- User Task_DS User4 task4 User5 task5 User6 task6 </code></pre> <p>I tried creating two tables, subreports, Joining two tables &amp; creating single datasets to achive the same. I am not able to arrive at the above mentioned format. Can Anyone please help me how can i do that?</p> <p>I am getting below report foramt. I am mentioning for projectID 1 alone. It is same for ProjectID 2 also.</p> <pre><code> ProjID : 1 Proj_task: NIT 2.0 -------------------- User Task_DS User1 task1 ProjID : 1 Proj_task: NIT 2.0 -------------------- User Task_DS User2 task2 ProjID : 1 Proj_task: NIT 2.0 -------------------- User Task_DS User3 task3 </code></pre> <p>UpDated</p> <p>Page:1</p> <pre><code> ProjID Proj_task Task_DS User 1 NIT 2.0 task1 User1 1 NIT 2.0 task2 User2 1 NIT 2.0 task3 User3 </code></pre> <p>page 2</p> <pre><code> ProjID Proj_task Task_DS User 2 SSRS task4 User4 2 SSRS task5 User5 2 SSRS task6 User6 </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsk7730
    1. USsk7730
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSSRS Report - Specific Format
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload