Link to home
Start Free TrialLog in
Avatar of agrawal_swati
agrawal_swati

asked on

I have a main report and a subreport. My purpose is to show data (which consist of Customer_code, Premise_code and other fields) from main report and sub report.

I have a main report which consist of data like Customer_Code, Premise_Code and other fields. Same fields I have in my subreport along with main report fields I have an extra field in subreport that is User_id. My purpose is to show data in main report for one Customer_Code and Premise_code below that want to show data for same Customer_code and Premise_code from subreport. likewise I want to print whole main report and subreport data.
Eg: Here for One combination of Customer_code and Premise_code in main report , I have multiple rows in subreport. I want to show one row from Main report and its corresponding rows from subreport (by passing Customer_code and Premise_code from main report to match it from sub report) just below that main report row.
Main report: Customer_code Premise_code
                         455623                 234589
                         788945                457856
                         124526                535975
Sub report:  Customer_code Premise_code  User_ID
                         455623                 234589            AS452315
                         455623                 234589           AM060185
                         788945                457856           DF264558
                         788945                457856            KL265315
                         788945                457856            PL562659
                         788945                457856            YU729014
                         124526                535975            UI095173
                         124526                535975            TY014789

Output on Crustal report:      Customer_code      Premise_code
                                                   455623                     234589
                                                    Customer_code      Premise_code   User_ID
                                                     455623                    234589               AS452315
                                                     455623                    234589               AM060185
                                                    Customer_code      Premise_code
                                                            788945                457856
                                                     Customer_code      Premise_code     User_ID
                                                         788945                457856                 DF264558
                                                         788945                457856                 KL265315
                                                        788945                 457856                 PL562659
                                                         788945                457856                 YU729014

and so on.
Avatar of Ido Millet
Ido Millet
Flag of United States of America image
You may be able to avoid a subreport with proper joins and Grouping.
If that's not viable, insert a LINKED and set the subreport property of Suppress blank subreport.
Avatar of Ido Millet
Ido Millet
Flag of United States of America image
... Insert a LINKED subreport and ...
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of agrawal_swati
agrawal_swati

ASKER

Hi All,

The solution is not working. For first time I linked both columns at one shot then tried to see the preview but it got stuck and stop responding. After it I linked only CUST_CODE and tried to run still it is not showing the correct data. any other way like if I can put anything in field explorer?
Avatar of Mike McCracken
Mike McCracken
Can you upload the report?

mlmcc