topic Numbers of Section on SAS VA Report build dynamically in SAS Visual Analytics

Numbers of Section on SAS VA Report build dynamically

anandsasbi — Fri, 22 Apr 2016 05:48:26 GMT

I have to Create a Report where Number of Section/Page will not Fixed; Number of sections on Report will be based on Parameter.

In 1st section of Report I have used multiple Drop-down control and each control has mapped to the Parameter Value. The number of section/ Page in report will be based of Parameter , I means for based on combination some parameter will decide who much page we have to display on report , it’s means Number of page not fixed or we can say I want display/choose page on report dynamically.

I need help from SAS VA Expert for build report based on above Criteria. If it’s possible in SAS VA 7.1 then please guide me how to do.

Regards,

Anand

Re: Numbers of Section on SAS VA Report build dynamically

MichelleHomes — Fri, 22 Apr 2016 06:26:01 GMT

Hi Anand,

The number of report sections in a report is a fixed number. This cannot be created dynamically via a parameter.

Perhaps if you elaborate further on your requirement and the reasoning behind this an alternative approach can be suggested.

Kind Regards,

Michelle

Re: Numbers of Section on SAS VA Report build dynamically

anandsasbi — Fri, 22 Apr 2016 11:17:03 GMT

Thanks for your reply. Please verify the attached file regarding my requrement.

Regards,

Anand

Re: Numbers of Section on SAS VA Report build dynamically

Explore_SAS — Fri, 22 Apr 2016 15:42:48 GMT

If i understand this correctly, this is nothing but an filters to your report. as long you have all these values in your dropdown filters.

your report will show data based on that.

Re: Numbers of Section on SAS VA Report build dynamically

MichelleHomes — Fri, 22 Apr 2016 15:53:37 GMT

Hi Anand,

As described above, the number of sections in a SAS VA report can not be dynamically generated.

As a work around, what you could do though is create all your reports as separate reports and have a look up table to reference those reports. This look up table can then be used with parameters in your form so that the associated report is returned when selected.

Kind Regards,

Michelle

Re: Numbers of Section on SAS VA Report build dynamically

anandsasbi — Fri, 22 Apr 2016 18:04:15 GMT

Thanks Michelle for your valuable suggestion.

If I understand correctly then I need to create a table (lookup table) where I have to enter all possible combination of parameters. When user will select the parameter from all 5 controls I will join (lookup ) these control value (parameter ) to lookup tables and based on selection I have to call individual report which I have created separately.

I have small confusion here, through Report interaction we use to call another report ( hyperlink ). Could you please guide me how can I call another report from lookup table, because here we can’t display lookup table on first report (report where all control has been define). I mean could you give me some example or reference where we have used lookup table (which will not used on report canvas) for call another report.

Thanks in advance

Regards, Anand

Re: Numbers of Section on SAS VA Report build dynamically

MichelleHomes — Fri, 22 Apr 2016 21:38:41 GMT

Hi Anand,

@RickStyll_SAS has a good example on how to hyperlink on the following thread https://communities.sas.com/t5/SAS-Visual-Analytics/Hyperlinks-in-Report-Designer/m-p/217050#M2404

Kind Regards,

Michelle

Re: Numbers of Section on SAS VA Report build dynamically

anandsasbi — Sat, 23 Apr 2016 15:58:27 GMT

I have gone through the link which you have suggested, It’s regarding External URL Link. I am not able to use this for my requirement .

I have created 10 reports and based on requirement each report has multiple sections. I have created one Lookup table with 10 records (different combination of Parameter value). Now I want to use this lookup table in Main report for call those 10 reports. I can’t display lookup table on main report. Once all parameter fill by controls (like drop down) on Main report I want to call particular report ( link) .

I am not able to create link between Main Report, Lookup Table & Target Table.

I hope you understand my requrement.

Regards,

Anand