drill down reports

[syncdba]

Hi,
I'm trying to create a drill-down reports. Is it possible to create that on fields like.
Errors Duplicates Ready
14 17 23
16 78 90
When I double-click on 14(errors) it will show me the error details under it & if I click on 90(ready) it should show me ready detail under it.
Thanks,
CRXI.

 

[BobSuruncle]

Do the rows in your example represent Group Footers?
If so, you could create On-demand subreports in the Group Footer for each of the columns that would run to display whatever data you'd like.
On the Subreport tab of the Format Editor for each subreport, you'd click on the "On-demand Subreport Caption" button and enter a formula to display the amount.
e.g. ToText( Sum({Errors}, {YourGroupField} ) )


Bob Suruncle

 

[syncdba]

I don't want to use subreports in my drilldown report.
Is there anything (formula) I can use..
Thanks,

 

[BobSuruncle]

You can only drill-down on groups, so if you want to drill on Errors, Duplicates and Ready, they'd have to be groups on your report.
You likely wouldn't be able to put them side by side as you've shown in your example.

Bob Suruncle

 

[syncdba]

I think it should be possible. I dont have much experience in CRXI. I have created 3rd group by error_id & added details of errors in that.. On error column under format field I'm trying to write some formula under suppress(check box)like drilldowngrouplevel=3..
Nothing is working..
some more help.

 

[lbass]

You need to show some sample data at the detail level, showing the field names and how the data displays on the report. Your example does not clarify whether "error", "ready", etc. are different fields or different instances of the same field, and that matters to the solution. You also need to specify your report structure--what your groups are, etc.

-LB

 

[syncdba]

I have id,error,duplicated,ready fields from table as
ID Error Duplicates Ready
---------------------------------------
1 13 34 67
2 17 67 89
3 12 56 78
I have create a report to show errors.First I did GROUP BY on ID. & in detail section I had time,date,Typeof Error(error_details). So, On double-click on any field it will show error_details. But I want to display details for duplicates(if somebdy double click on "Duplicate" field.like 34or 67)..& same for ready field..
Like: Click on 34(duplicate record) it should display details of 34.
& click on 13(error rec.)it should display details of 1

 

[lbass]

You could create an on-demand subreport for each column where you place the details for that particular column. You would link each subreport to the main report on the ID field, and then right click on the subreport->format subreport->subreport tab->check "on demand subreport"->on demand subreport caption->x+2 and enter:

totext(count({table.field},{table.ID}),0,"")

In other words, wrap totext() around the summary you would display in the main report, so that the value becomes the caption for the subreport. If you want, you can change the link color and remove the underlining by formatting the field.

-LB