Showing posts with label summary. Show all posts
Showing posts with label summary. Show all posts

Thursday, March 22, 2012

custom summary reports in mgmt studio

Is it possible to create custom summary reports and run them in management studio? I am assuming these reports are RS reports.

thanks,

Derek

Is it possible to create custom summary reports and run them in management studio?

Doubt if there is such feature.

I am assuming these reports are RS reports

SSMS installation doesn't require RS installation, so probably it's wrong assumption.

|||

This is not possible. Though this is something we're investigating for SP2. I suggest you vote on the following item in the Product Feedback Center: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=fb83d75b-424a-4c72-a735-30692a077e57

Cheers,
Dan

Sunday, March 11, 2012

Custom names for summary fields

Using Crystal Reports 8.5 I have created a report which displays a pie chart of the column totals in a report. Unfortunately the names of the summary fields are used as labels for the pie chart slices and they are ugly - things like "sum qryOrders.OrderValue". Is there a way to replace these labels with my own choice of text?From the deafening silence, the answer appears to be 'No'. In case anyone else has the same issue, here is a workaround. Suppress the display of pie slice labels. Suppress the display of the chart legend. Create your own legend box using the basic drawing tools - filled rectangles - and add your own text labels.|||For the sake of future Googlers; I too was having this problem, and I had given up when I realized that if you sort "in specified order", you can then set up your "Named Groups" such that the "Group Name" is the name that you wish to have displayed.

For example, the formula for one of my named groups is "@.Allocation" "is equal to" "International Equity", and the name of the group is "Int'l Equity".

Works like a charm, sorry I'm too late to help you.|||Well, within a couple of minutes of posting, I realized that this only works if you have only one field to show a value for. So, it's not going to work where I really need it to, but still, it's useful elsewhere.