https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257861#M15428 Hi, thanks for your answer.<BR />The source data is a SAS data set and users do not have SAS license, or access to our SAS environment, so the lin wouldn't work. I understand that the ACTIVEX control allows some kind of inter activity on the charts or reports display like editing some parameters in the chart.<BR />Can the chart 'embed' somehow metadata or more specifically basic data underlying the chart? This is possible with xls charts copied into words. I was wondering if it is possible with a SAS chart displayed in HTML.<BR />Thank you very much Sun, 20 Mar 2016 18:58:59 GMT Tanguy 2016-03-20T18:58:59Z https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257846#M15425 Dear SAS community.<BR /><BR />I have built a set of combined reports with SAS EG (SAS Analytics pro). These recurrent reports are built on a monthly basis.<BR />Users need to have access to the underlying data. For example, I have created a line chart based on a data set; users would need to see the underlying data by clicking on the chart. Note the the users (around 20) do not use SAS and do not have SAS license.<BR />Do you know if it is possible to implement such a functionality whereby non SAS users have acess to underlying data of charts combined in reports (using for example ACTIVEX control)?<BR /><BR />In advance, thanks a lot for your advices. Sun, 20 Mar 2016 16:12:42 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257846#M15425 Tanguy 2016-03-20T16:12:42Z https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257848#M15426 Dear all,<BR />Just to clarify, the reports are under HTML format.<BR />Thank you Sun, 20 Mar 2016 16:16:33 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257848#M15426 Tanguy 2016-03-20T16:16:33Z https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257856#M15427 <P>You could creat a link on the chart object that redirects to the source data report?</P> Sun, 20 Mar 2016 18:08:14 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257856#M15427 Reeza 2016-03-20T18:08:14Z https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257861#M15428 Hi, thanks for your answer.<BR />The source data is a SAS data set and users do not have SAS license, or access to our SAS environment, so the lin wouldn't work. I understand that the ACTIVEX control allows some kind of inter activity on the charts or reports display like editing some parameters in the chart.<BR />Can the chart 'embed' somehow metadata or more specifically basic data underlying the chart? This is possible with xls charts copied into words. I was wondering if it is possible with a SAS chart displayed in HTML.<BR />Thank you very much Sun, 20 Mar 2016 18:58:59 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257861#M15428 Tanguy 2016-03-20T18:58:59Z https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257871#M15429 Ok. Why not create an HTML report with the raw data via a proc print or report. When click on chart link to 'report' of data. <BR /><BR />It doesn't seem to be an issue of security but process. Sun, 20 Mar 2016 20:30:45 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257871#M15429 Reeza 2016-03-20T20:30:45Z https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257876#M15430 Thanks for your quick answer.mm<BR />I created a process flow in Enterprise guide which generate automatically 90 datasets based on which 90 reports in HTML‎ are created outside the SAS server, on a shared drive where non SAS users have access.<BR /><BR />It is actually both a process and a confidentiality issue:<BR />- we cannot give access to the full database. Nevertheless, we need to give them access to the raw data underlying the chart. For example, I built a chart at country level showing the average level of capital during the last 4 quarters. The underlying‎ raw data is at bank level. Users would like to see the raw data if needed.<BR />This is also a process issue because I do not really understand how to make a link in the HTML file to‎ raw data considering that users cannot open a SAS dataset (they do not use SAS). I understood that ACTIVEX allows some kind of inter activity but I understand it does not help to solve my issue, right?<BR /><BR />Thank you<BR /> Sun, 20 Mar 2016 21:14:07 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257876#M15430 Tanguy 2016-03-20T21:14:07Z https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257877#M15431 <P>Is your requirement to provide a SAS dataset? Why not generate a listing report or csv?</P> Sun, 20 Mar 2016 21:19:39 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/HTML-report-ActiveX-Access-to-the-underlying-data-for-non-SAS/m-p/257877#M15431 Reeza 2016-03-20T21:19:39Z