date prompt problem in crosstab at time of report linking

[dipakgopale]

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

[dipakgopale]

please anyone known how to resolve this problem

[Madelyn_SAS]

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?

[dipakgopale]

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

[Madelyn_SAS]

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...

[dipakgopale]

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

if any solution please inform me

[Madelyn_SAS · Accepted solution]

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.

[dipakgopale]

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

[dipakgopale]

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 
 
 
 
 

[dipakgopale]

above procedure work properly ,

problem solve .

thank you very much.