Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts

Monday, March 19, 2012

Got an error when applying Template to the Report

Hi All,
I produced a report in Crystal V9,the report which i got was WITHOUT template.

The Report i generated was the Statndard report.

Now i want to apply template for this report.

For this i clicked on the "Template Expert Button", selected the "Block(Blue)"[Pre Defined Template] and clicked on OK Button

Now i got an error saying "Could Not Apply Template to Document"

How to Handle this error

I want to apply the template for the report.If you are using chart or if the page is too large or small, you may get this problem

Sunday, February 19, 2012

Global and Shared variables of Crystal

I have been converting a crystal report to MSRS. Crystal allows sharing variables (called shared variables) between main reports and it's subreports. Also, it has a concept of global variables which are available throughout a report. Many decisions (e.g. hiding the footer of a report) are based on these type of variables.
How can we achieve this in MSRS ? Do we have something i can add to Report Code which works as a global variable/shared variable Or there is any worwround available in general.
Imperative to mention that i shall be using seperate datasets for subreports of CR for performance reasons as suggested in BOL.
Thanks.Variables can not be shared across multiple reports. You can pass parameters
between reports however...When you call a subreport, pass whatever
information you need as parameters.
You can also use parameters as global variables within a single report...
SP1 allows parameters to be hidden so they do not appear on the user
selection list... Create the parameter and hide it... Then use the
Parameters collection to refer to it...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"push" <push@.discussions.microsoft.com> wrote in message
news:3E941DF6-2AEE-4F24-9145-D7A5CCDDDDAB@.microsoft.com...
> I have been converting a crystal report to MSRS. Crystal allows sharing
variables (called shared variables) between main reports and it's
subreports. Also, it has a concept of global variables which are available
throughout a report. Many decisions (e.g. hiding the footer of a report) are
based on these type of variables.
> How can we achieve this in MSRS ? Do we have something i can add to Report
Code which works as a global variable/shared variable Or there is any
worwround available in general.
> Imperative to mention that i shall be using seperate datasets for
subreports of CR for performance reasons as suggested in BOL.
> Thanks.

Global access for Everyone Group

I have been tasked with taking over a Crystal XI Enterprise installation that uses the Everyone group to grant view access to all objects/folders. Where do I turn this off globally? In other words, I want the Everyone group to have no access rights to anything - so I can use created groups to administer access rights for obejcts/folders. Thanks for any help in advance.I have found the correct place for this under Settings. Thanks for your patience.