Subreport from Cross Tab ... or something else 1

[BrendanBlackford]

Hello
CRXI on SQLServer

I have a cross tab in a report, on horizontal Departures Loc and on vertical Arrivals Loc; on summary sum of formula:
datediff("d",{ZTT;1.DepDate},{ZTT;1.ArrDate})

When I click for example the cell which is the intersection of A with B, is it possible to bring the details, as jobno,datediff("d",{ZTT;1.DepDate},{ZTT;1.ArrDate})?

Thanks

 

[lbass]

I believe you would have to create a manual crosstab with a subreport for each column instance that is linked on the column field and the row field.

-LB

 

[BrendanBlackford]

Thank you for your reply.
Now I have other issue. I have for A1 a cell. Over each cell I put an on demanding subreport without name.
A B C
1
2
3

When I oped the report, after I closed it, Crystal puts names on each subreport, like A1 - without name, B1 name - 01, C1 name - 01,02

Can you help? I tryed to put _____ but when I put the same no of characters, Crystal puts _____-01 and so on

 

[lbass]

You can either right click on the subreport->format subreport->subreport tab and remove the subreport name (first field on the screen) or you could consider having the subreport caption (the link to the on-demand subreport) be a text version of the summary that belongs in that cell.

You would need to create a formula like this for each column instance:

//{@colAdatediff}:
if {table.col} = "A" then
datediff("d",{ZTT;1.DepDate},{ZTT;1.ArrDate})

In the sub, you would have used a selection formula limiting the sub to column A. Then you can right click on the subreport->format sub->subreport->on-demand subreport caption->x+2 and enter:

totext(sum({@colAdatediff},table.groupfield}),0,"")

-LB