topic Re: date prompt problem in crosstab at time of report linking in SAS Web Report Studio

date prompt problem in crosstab at time of report linking

dipakgopale — Mon, 27 Apr 2015 14:21:45 GMT

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

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

dipakgopale — Mon, 27 Apr 2015 14:28:46 GMT

please anyone known how to resolve this problem

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

Madelyn_SAS — Mon, 27 Apr 2015 14:41:09 GMT

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?

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

dipakgopale — Tue, 28 Apr 2015 01:09:10 GMT

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

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

Madelyn_SAS — Tue, 28 Apr 2015 14:08:42 GMT

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 values to character prompts in a target report

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

dipakgopale — Thu, 30 Apr 2015 08:04:41 GMT

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

if any solution please inform me

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

Madelyn_SAS — Mon, 04 May 2015 18:30:44 GMT

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.

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

dipakgopale — Tue, 05 May 2015 02:07:28 GMT

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

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

dipakgopale — Tue, 05 May 2015 06:52:34 GMT

above procedure work properly ,

problem solve .

thank you very much.

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

dipakgopale — Wed, 06 May 2015 05:55:55 GMT

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