Report Definition in Crystal

Hi, everyone -
I just had a quick query that I was hoping one of the experts out there could help me with:

I remember, when we used WinQL as our previous report generator, the software provided a "report definition" print option. This would allow me to print off a page with the fields, formulas, groupings, etc. for reports so that I could recreate my report in what we now have -- Crystal 8.5.

Now that we are changing our housing program software from a DOS-based system to a Windows-based software, the vendor is telling me that I'll have to AGAIN :eek: recreate my Crystal reports because the fields will all be different.

I'm wondering whether Crystal provides the same sort of "report definition" print option so I can print off the reports I need to recreate without having to guess at the formulas..... I've looked around Crystal and wasn't able to locate anything like this.

Thanks for the help.I'm not sure about 8.5 but in developer 10 under exports there is an option to print the report definitions.

GJ|||Hi, GJ -

UUUGGG... :blush: :blush: :blush: I guess I didn't scroll down far enough under Export. I did find it though.

Thanks for the help!!!sql

Report Builder Report Possibility?

This may not be possible, but I wanted to see what some of the experts' opinions are here.

One of our users has created a report in Report Builder. I want to take this report, post it to a folder and allow her employees to run the report.

I've put it in a folder called "Reference Line Reports" and gave browser permission to a list of users. These users are able to run the report (without having access to Report Builder or the report model).

When they try to utilize the "infinite clickthrough" functionality, I get the following error.

The permissions granted to user '<domain>\<username>' are insufficient for performing this operation. (rsAccessDenied)

If I give one of these users access to the "report builder" they no longer get the error. The problem is that we don't want them to run the report builder (giving unrestricted access). I just want to be able to give them a report builder report with the clickthrough ability.

I would like to disclaim that we have not upgraded to SP1 (or CTP SP2 yet). Has anyone seen a similar problem or know if this was something fixed in sp1?

Thank you,

Dan

The only tasks that the ReportBrowser role doesn't have compared to Report Builder are Consume reports and Manage individual subscriptions. Try creating a custom role that doesn't have Consume Reports task.|||

Hi Teo,

By the way... kudos on the "Applied Microsoft Analysis Services 2005" book.

I don't know if I was clear enough with my problem. I've removed myself from the "System User" system-level role (so I no longer have ability to see Report Builder button). I've given myself every single role/task on the "Reference Line Reports" folder. I've also given myself every single task on the Report Model.

I am still able to run the Report Builder report (posted in "Reference Line Reports"). However, when I try to utilize the "infinite drill-through" I get the error.

Once I give myself the System User system-level role (with Execute Report Definitions task) and all tasks on the report model, I am able to view the report & it's infite drillthrough. This wouldn't necessarilly work for us, however, because this also gives me the Report Builder button.

I would be ok with everyone having the report builder button, but I do not want to give everyone access to see the report model. If i have the "view models" task on the report model, users can drill through (but this allows them to create reports through report builder). If I remove the "view models" task, the permissions error appears.

Maybe my problem is trying to post a Report Builder report to the Report Manager for all users to view and drill through?

Regards,

Dan

|||Thank you. You need the Execute Report Definitions task (which System User give you by default), to be able to run Report Builder reports because the Report Builder uploads the report definitions on the fly. For your situation, why don't you secure the model itself?|||

Yep, I could probably do that. At this point, however, it is probably just easier to write the report in BIDS and post it for them.

I guess I'm just not sure why they could execute the Report Builder report, but didn't have permission to drill through.

Thanks for looking into, Teo.

Regards,

Dan

|||

The Clickthrough feature is essentially ad-hoc reporting, because the user can start with any report and continue drilling "infinitely"; hence the requirement for permission to the Execute Report Definitions task.

This is an interesting scenario, however. We will consider addressing this issue in a future release. At the very least the report author should be able to remove the Clickthrough links so users don't inadvertently click them and get an intimidating error message.

Thanks for the feedback.

|||

Bob,

I appreciate the response. I'm glad to see it's more of an unforseen scenario in as opposed to something we have done incorrectly. I think it would be helpful to be able to allow users to clickthrough a report builder report without giving them access to execute report definitions.

In this scenario, we have a user who can author reports via report builder. Once she authors them, she will either keep them in her My Reports folder or we will post them for her immediate employees. We don't want to give the immediate employees "unlimited" access to the data - just restricted to the high-level summary view the report builder report gives.

We can also avoid having to re-create reports (summary and detail level views) in BIDS that have to be manually coded to drill through.

I do understand why this scenario might not be natively supported. Thank you for at least considering this scenario (or like you stated, at least considering the suppression of the intimidating error message).

Regards,
Dan

Report Builder Query

Hi Experts,

I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.

When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.

The problem is report builder allows me to select either Policy count in the report or the amount field.

Have anyone faced this problem.

The same report works in cube browser.

Regards'

Neeraj

Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.

B.

Report Builder Query

Hi Experts,

I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.

When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.

The problem is report builder allows me to select either Policy count in the report or the amount field.

Have anyone faced this problem.

The same report works in cube browser.

Regards'

Neeraj

Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.

B.

Report Builder and confirmed dimension

Hi Experts,

I have build a cube and placed report builder on it. I have a Dimensional model with two fact table. When i try to create a report it allows me to select measures from only one fact. It doesnt allow me to create report from two different fact and two different dimensions.

Please help

Regards

Neeraj

Hi, you can't never do that in report builder, because [Report Builder] model does not work with more them one fact table.|||

I believe Loobo is correct in stating that Report Builder doesn't accept more than one measure group/fact table. Report Builder seems to be focused on more of a relational database model which does not always work well with Analysis Services.

Thanks,
Bryan Smith

|||Thank You Guys for that Insight.

Report Builder and confirmed dimension

Hi Experts,

I have build a cube and placed report builder on it. I have a Dimensional model with two fact table. When i try to create a report it allows me to select measures from only one fact. It doesnt allow me to create report from two different fact and two different dimensions.

Please help

Regards

Neeraj

Hi, you can't never do that in report builder, because [Report Builder] model does not work with more them one fact table.|||

I believe Loobo is correct in stating that Report Builder doesn't accept more than one measure group/fact table. Report Builder seems to be focused on more of a relational database model which does not always work well with Analysis Services.

Thanks,
Bryan Smith

|||Thank You Guys for that Insight.