in the table to change the property

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

in the table to change the property

Author

Topic

shm
Yak Posting Veteran

86 Posts

Posted - 2008-07-30 : 08:53:31

hi,
in report services-layout am taking two tables in table1 from one dataset 5 columns and in table2 from different dataset only one column.
Am joining these two tables,total it is hsolud look like 6 columns.
It has done but if the table1 column1 is larger that is the width if it has more character then the table2 column1 then the row of the table2 will not match to the table1...Is there any property to change the width of the table2 column1 if the table1 column1 is changed.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-30 : 14:28:06

Is it only because data come from two datasets that you're using two different tables? you could still use single table to display both dataset data. you only need to specify scope for fields to indicate which dataset they are coming from.If you want more details on this, please elaborate on your scenario and we can see if it can dealt with a single table.

shm
Yak Posting Veteran

86 Posts

Posted - 2008-07-31 : 00:17:08

hi ,
i tried in that way also but the data is coming wrong..in the dataset2 sum(column1) is taken..in layout table details i had given the value if i take in the single table in the table details
Sum(Fields!PLT_HRS.Value, "ProjectLogTime")..it wil come like this i don't want the sum.only columnn i should take how can i get that?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-31 : 13:08:45

quote:
Originally posted by shm

hi ,
i tried in that way also but the data is coming wrong..in the dataset2 sum(column1) is taken..in layout table details i had given the value if i take in the single table in the table details
Sum(Fields!PLT_HRS.Value, "ProjectLogTime")..it wil come like this i don't want the sum.only columnn i should take how can i get that?

didnt get that. can you explain?

shm
Yak Posting Veteran

86 Posts

Posted - 2008-08-01 : 01:14:23

hi,

ok

In DATASET1 ---

SELECT PP.PPH_PHASE_NAME,PM.PMO_MOD_NAME,CR.CRQ_CHANGE_ITEM_CODE,CR.CRQ_NUMBER,
CR.CRQ_CUST_REF_NO,REPLACE(CONVERT(VARCHAR,CR.CRQ_CREATED_DATE,106),' ','-') CRQ_CREATED_DATE,SUM(CEAV.CR_ESTIMATED_VALUE)

FROM CHANGE_REQ CR
INNER JOIN PROJECT_MODULE PM ON PM.PMO_MOD_SEQ_NO = CR.PMO_MOD_SEQ_NO
INNER JOIN PROJECT_PHASE PP ON PP.PPH_SEQ_NO = PM.PPH_SEQ_NO
INNER JOIN PROJECT P ON P.PRJ_SEQ_NO = PP.PRJ_SEQ_NO
LEFT OUTER JOIN PROJECT_TASK PT ON PT.CRQ_SEQ_NO = CR.CRQ_SEQ_NO
LEFT OUTER JOIN CR_ESTIMATED_ACTUAL_VALUES CEAV ON CEAV.CRQ_SEQ_NO = CR.CRQ_SEQ_NO

WHERE P.PRJ_SEQ_NO = @PRJ_SEQ_NO
AND PP.PPH_SEQ_NO IN (@PPH_SEQ_NO)
AND (CR.CRQ_CREATED_DATE >= @CRQ_CREATED_DATE OR @CRQ_CREATED_DATE IS NULL)
AND (CR.CRQ_SEQ_NO NOT IN
(SELECT DISTINCT CREATED_FROM_CR
FROM PROJECT_MODULE
WHERE (CREATED_FROM_CR IS NOT NULL) ) )

GROUP BY CR.CRQ_NUMBER,PP.PPH_PHASE_NAME,PM.PMO_MOD_NAME,CR.CRQ_CHANGE_ITEM_CODE,CR.CRQ_CUST_REF_NO,CRQ_CREATED_DATE
ORDER BY CR.CRQ_NUMBER,PP.PPH_PHASE_NAME,PM.PMO_MOD_NAME,CR.CRQ_CHANGE_ITEM_CODE,CR.CRQ_CUST_REF_NO,CRQ_CREATED_DATE

DATASET2---

SELECT PP.PPH_PHASE_NAME AS PHASENAME,PM.PMO_MOD_NAME AS MODULENAME,CR.CRQ_CHANGE_ITEM_CODE AS CRNAME,
CR.CRQ_NUMBER AS CRNO,CR.CRQ_CUST_REF_NO AS CUSTREFNO, REPLACE(CONVERT(VARCHAR,CR.CRQ_CREATED_DATE,106),' ','-') CRQ_CREATED_DATE,
SUM(PLT_HRS) ACTUAL_HRS

FROM CHANGE_REQ CR
INNER JOIN PROJECT_MODULE PM ON PM.PMO_MOD_SEQ_NO = CR.PMO_MOD_SEQ_NO
INNER JOIN PROJECT_PHASE PP ON PP.PPH_SEQ_NO = PM.PPH_SEQ_NO
INNER JOIN PROJECT P ON P.PRJ_SEQ_NO = PP.PRJ_SEQ_NO
LEFT OUTER JOIN PROJECT_TASK PT ON PT.CRQ_SEQ_NO = CR.CRQ_SEQ_NO
LEFT OUTER JOIN PROJECT_LOG_TIME PLT ON PLT.PLT_OBJECT = PT.PTK_SEQ_NO

WHERE P.PRJ_SEQ_NO = @PRJ_SEQ_NO
AND PP.PPH_SEQ_NO IN (@PPH_SEQ_NO)
AND (CR.CRQ_CREATED_DATE >= @CRQ_CREATED_DATE OR @CRQ_CREATED_DATE IS NULL)

GROUP BY CR.CRQ_NUMBER,PP.PPH_PHASE_NAME,PM.PMO_MOD_NAME,CR.CRQ_CHANGE_ITEM_CODE,CR.CRQ_CUST_REF_NO,CRQ_CREATED_DATE
ORDER BY CR.CRQ_NUMBER,PP.PPH_PHASE_NAME,PM.PMO_MOD_NAME,CR.CRQ_CHANGE_ITEM_CODE,CR.CRQ_CUST_REF_NO,CRQ_CREATED_DATE

as above in the dataset2 only one column actual_hrs is taken in the table2..it should match with the dataset1..the data is coming correct but in the dataset1 if the phasename or any other column length is more then the actual_hrs column wil vary..i tried to put the actual_hrs in the dataset1 but am nt getting the correct data..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-04 : 14:20:29

How are tables CR_ESTIMATED_ACTUAL_VALUES & PROJECT_LOG_TIME related to PROJECT_TASK? are they 1:1 relation or 1 to many?

shm
Yak Posting Veteran

86 Posts

Posted - 2008-08-05 : 00:19:56

hi,

the main table is change_req - crq_seq_no is pk,in the cr_estimated_actual_values and in project_task crq_seq_no is fk,in the project_log_time there is a column plt_object which is fk is refered to ptk_seq_no from the project_task.it is one to many...i tried to do it in the one query but the sum(plt_hrs) the data is coming wrong.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources