1. 

   EricW, Member

   Hi

   I'm trying to link from a chart to a detail report, and I'm obviously doing something wrong..

   This code generates a report and I can click on any line and that links to a detail report:

   select 'dbr.hidecolumns', 'Contact';
   select 'dbr.report', 'sp_DBR_AT_Loggedby', '[Logged By]', 'LoggedBy=Contact', 'BillStr=(BillStr)', 'BillEnd=(BillEnd)', 'DisplayName=Logged By', 'Company=(CustID)';

   select top 10 ContactName as 'Logged By', count(Ticket) as 'Ticket Count', Contact
   From #TMPworking_tickets
   group by ContactName, Contact
   order by count(Ticket) desc;

   Which is perfect, except I'd like to display that initial summary as a bar graph, so..

   select 'dbr.hidecolumns', 'Contact';
   select 'dbr.chart', 'Bar3d', 'Top 10 Ticket Creators';
   select 'dbr.report', 'sp_DBR_AT_Loggedby', '[Logged By]', 'LoggedBy=Contact', 'BillStr=(BillStr)', 'BillEnd=(BillEnd)', 'DisplayName=Logged By', 'Company=(CustID)';

   select top 10 ContactName as 'Logged By', count(Ticket) as 'Ticket Count', Contact
   From #TMPworking_tickets
   group by ContactName, Contact
   order by count(Ticket) desc;

   Which generates a bar graph with exactly the same information, but it's no longer clickable to drilldown.

   What am I missing?

   Thanks

   Eric
2. 

   myDBR Team, Key Master

   Eric,
   You can simplify the report a bit. You do not need the dbr.hidecolumns as the chart does not have columns, and you do not need to specify the linked target as myDBR knows that when you use a linked report against a chart.

   So:

   select 'dbr.report', 'sp_DBR_AT_Loggedby', 'LoggedBy=Contact', 'BillStr=(BillStr)', 'BillEnd=(BillEnd)', 'DisplayName=Logged By', 'Company=(CustID)';
   
   select 'dbr.chart', 'Bar3d', 'Top 10 Ticket Creators';
   
   select top 10 ContactName as 'Logged By', count(Ticket) as 'Ticket Count', Contact
   
   From #TMPworking_tickets
   
   group by ContactName, Contact
   
   order by count(Ticket) desc;
   
   

   --
   myDBR Team
3. 

   EricW, Member

   woohoo!

   That's it working now, so if I want a linked chart, I should not declare the target column.

   Cool.

   Thanks much

   Eric

Reply

You must log in to post.