BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Hello Friends,
I need to prepare VA report by double click on Cell (cell value contains Amount of multiple Account Numbers), then i need to display referenced data for that particular cell value.

Current_Bucket
================
1- Current $ 25,000
2- 30 Days $ 10,000
3- 60 Days $ 15,000

If i double click a cell value contains $ 15,000 in Source report, reference data should be display in Target report.
1 ACCEPTED SOLUTION

Accepted Solutions
DataDredge
Fluorite | Level 6

If I understand what you are asking, not sure if it's possible to pass selections between reports.  But assuming your cells are in currently a list table, and you wish to display that selected cell in another object (in the same report), select the list table, then use the actions menu (or the right side of the report designer) and select the object link to the second object.  This works for me between list tables and text items and should work for graphs etc. 

 

There is an article on this at :https://documentation.sas.com/doc/en/vacdc/8.5/vareportdata/p0qqtmobryw64un1922tyxumhv4a.htm#n0tnuk7...

 

Thers's also a video by the brilliant Teri Patsilaras from SAS that explains one way, two way and automatic links.  https://youtu.be/_J9y8I9XLaY?list=PLVBcK_IpFVi80HeTBtFZ7pubwoBBATBHE

 

Hope this helps.

 

View solution in original post

2 REPLIES 2
DataDredge
Fluorite | Level 6

If I understand what you are asking, not sure if it's possible to pass selections between reports.  But assuming your cells are in currently a list table, and you wish to display that selected cell in another object (in the same report), select the list table, then use the actions menu (or the right side of the report designer) and select the object link to the second object.  This works for me between list tables and text items and should work for graphs etc. 

 

There is an article on this at :https://documentation.sas.com/doc/en/vacdc/8.5/vareportdata/p0qqtmobryw64un1922tyxumhv4a.htm#n0tnuk7...

 

Thers's also a video by the brilliant Teri Patsilaras from SAS that explains one way, two way and automatic links.  https://youtu.be/_J9y8I9XLaY?list=PLVBcK_IpFVi80HeTBtFZ7pubwoBBATBHE

 

Hope this helps.

 

wajidkhan
SAS Employee

It helps me, but client is still using old version SAS VA 7.51, some features not available.

I have 4 Pages to link referenced data, 1st page working fine when i double click on particular cell value, but other pages not syncing data referenced cell.

 

Like :

Page-0: was_is (here i have reference cell contains Amount)

Page-1: Summary

Page-2: Summary_collections

Page-3: Summary_calls

Page-4: Reference data

 

I selected Page Links (Pages-1,2,3,4) under Actions, by double click only Page-1 reflects reference data, other pages not reflecting........

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1653 views
  • 1 like
  • 2 in conversation