Reports and Generic Inquires

I am building out a dashboard to monitor campaign activities and I can’t figure out how to connect the CRCampaign and CRActivity tables. The CRActivity table doesn’t have the CampaignID as a field. It does show the campaign, but not as expected [CampaignID, CampaignDesc].Any thoughts on how to pull this off would be appreciated! 

Does anyone know if passing variables from subreport to subreport is a possibility or passing a variable back to a subreport from a main report? Thanks  

Hello,I’m working on a report that must print the labels for a specific shipment, I have Shipment Nbr, Item ID and Lot Nbr parameters, and I would like to have the report knowing the Inventory ID or LotNbr once the Shipment Nbr value on parameter is entered.The report is working fine if I know the lots or inventory id associated to the shipment, but I would like to have those values displayed associated to the Shipment #. Do you have any guidance on it? 

I have created a sales analysis query using sales analysis.My query showing Customers - products - qty sold and amount of sales.I am trying to make the report provide total per customer, I can see that when I collapse the customers but do not see the total when taking the report to excel, any one experience on solving this issue?

How to show Google maps in a wiki and expose that Wiki on dashboard? We can add google maps script to show up in Wiki page but would like to see if we can add that wiki into dashboard Wiki component and show on the dashboard.