BookmarkSubscribeRSS Feed
Foxit
Fluorite | Level 6

Hi,

We're generating reports within a specified date range using section filters. When we navigate to reports using Report Linking feature the filters do not apply.

We're using Cross Tab Reports using Infomaps and a Teradata source, is there a solution for this problem??

TIA,

Ramesh

6 REPLIES 6
Madelyn_SAS
SAS Super FREQ

Does your target report have prompts for date range? That is how you can pass the currently selected date in the source report to the target report.

Foxit
Fluorite | Level 6

We currently have a report with two sections. The first section uses a section filter to restrict the report to a certain date range (ex, Mar 05 - Mar 06). With report linking we're navigating to another section in the same report which should be in the same date range. We tried to use Min and Max functionalities, but it doesn't seem to work with Crosstab tables.

With prompts in the target report is it possible to pass the section filter values (user provided at run time) from the source report?

SumanSamanta
Calcite | Level 5

Even I am facing the same problem. My requirements is also same as Foxit's. Even we tried by taking min max functionalities...

But unable to bypass that.

Can anybody help?

-Suman

ajuvaba
Calcite | Level 5

Hi,

I hope that I understand the problem correctly but you have a Report where user can use filter and you would like to send the values to other Report so it opens with same filter values. is that so?

in this case you have to link the reports to each other. This link should give you the idea: http://support.sas.com/kb/41/526.html

If you don't have the possibility then you need the rights - SAS Web Report role "Advanced Report Creation: Create Report Links" should do the trick.

You can't make the link between the tabs in one report, though. What you have to do is to create new report with prompts for Date_From and Date_to and then link it to the first report. In this case new report will be opened in right date range and the user have a possibility to return to first report. It is not always what is needed but it works quite good. I'm using it in some reports. Users like it also.

Hope it helps.

Cheers,

Remo

twocanbazza
Quartz | Level 8

If I understand correctly on what you are trying to do - I think you can only link to another report passing Character values - a date is numeric...

26174 - Using SAS® Web Report Studio to pass prompt values between linked reports

Barry

NIM
Calcite | Level 5 NIM
Calcite | Level 5

Hi,

Did anyone has the answer for above question of using date prompt in report linking for crosstab??? Facing similar problem..

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 2604 views
  • 1 like
  • 6 in conversation