Traditional web-based reporting with SAS BI tools

date prompt problem in crosstab at time of report linking

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

date prompt problem in crosstab at time of report linking

i have summary report and detail report,detail report having date prompt ,this prompt get date from summary report using report linking .

but at time of linking (summary report to detail report ) date variable not found in summary report only in cross tab object.

but its properly work in other object like bar chat,line chart etc.

so whats the problem for cross tab for report linking date prompt


Accepted Solutions
Solution
‎05-04-2015 02:30 PM
SAS Super FREQ
Posts: 384

Re: date prompt problem in crosstab at time of report linking


The following workaround has worked for other customers:

In the information map for the source report, make a copy of the Date data item. Edit the expression to use the PUT function and include the desired format like this:

PUT(<<PRDSAL2.DATE>>,DATE9.)


Change the Expression Type to Character.

Add this data item to the source report but hide it in the crosstab. When you create your link, associate this hidden copy of the Date data item with the prompt in the target report.

View solution in original post


All Replies
Contributor
Posts: 24

Re: date prompt problem in crosstab at time of report linking

please anyone known how to resolve this problem

SAS Super FREQ
Posts: 384

Re: date prompt problem in crosstab at time of report linking

Can you please provide more details about the problem? Are you getting an error when you follow the link from the crosstab to the target report?

Contributor
Posts: 24

Re: date prompt problem in crosstab at time of report linking

po.png

in this postingdate promt not get any date variable from summary report

SAS Super FREQ
Posts: 384

Re: date prompt problem in crosstab at time of report linking

Based on the screen shot, you are most likely encountering the behavior described in this SAS note:

45476 - In SAS® Web Report Studio, linked crosstabulation tables can pass only formatted character v...

Contributor
Posts: 24

Re: date prompt problem in crosstab at time of report linking


yes, this promt not get any variable(date,char,numeric)

if any solution please inform me

Solution
‎05-04-2015 02:30 PM
SAS Super FREQ
Posts: 384

Re: date prompt problem in crosstab at time of report linking


The following workaround has worked for other customers:

In the information map for the source report, make a copy of the Date data item. Edit the expression to use the PUT function and include the desired format like this:

PUT(<<PRDSAL2.DATE>>,DATE9.)


Change the Expression Type to Character.

Add this data item to the source report but hide it in the crosstab. When you create your link, associate this hidden copy of the Date data item with the prompt in the target report.

Contributor
Posts: 24

Re: date prompt problem in crosstab at time of report linking

i create exression,change type,hide data item from cross tab but linking time not found this new ceated data item in prompt.
still problem not solve

Contributor
Posts: 24

Re: date prompt problem in crosstab at time of report linking

i report we apply sutotal on column, report generate subtotal for all column but i want selected/wanted column subtotal

so how it can esolve

suppose i have one example



   
 
 
 
 
 
 
 
 
 
 
 





in tis sreenshot get all column subtotal,but i dont want product subtotal so how it resolve this 
 
 
 
 





Contributor
Posts: 24

Re: date prompt problem in crosstab at time of report linking

above procedure work properly ,

problem solve .

thank you very much.

Post a Question
Discussion Stats
  • 9 replies
  • 1004 views
  • 1 like
  • 2 in conversation