Search results for query: *

Thanks Guys, I was hoping I might have overlooked something but I can see that the alternatives are to have a printer friendly version or to do some customisation. In this scenario reports are being delivered via sharepoint 2003 webparts using BOE XI R2 and CR XI R2. Users are navigating...

Thanks Dgillz, I can see where you're going with this but that would require a refresh of the report and the user having to click a link to goto a printer friendly version of the report. Sadly, our users wouldn't do this. They expect clicking the print icon in the CR report viewer toolbar to...

Hi, I'm pretty sure the answer to this is 'no' but my client would like to be able to display certain fields within the report but for them to be suppressed in the printout. Is there any way of suppressing fields at the time of printing? Reason for asking is that we have a lot of hyperlinks...

There are a number of FAQ's on the business objects website relating to exactly this sort of thing. I would suggest searching for 'Red X' on their website as their are a number of different scenarios where this could happen.

Probably a simple question but for the life of me I can't find the function. I'm using CR XI R2, store procedures and SQL Server 2000. I have a report with a chart in the report header which displayed revenue by month. Y axis being revenue, x axis being month. My chart looks fine and...

Discovered that a formula on the mailto hyperlink of any text object requires that any parameters used are evaluated for null. A mailto hyperlink cannot contain contain null params and connot use if-then-else statments during the generation to evaluate and replace null field valies...

Your formula is calling a shared variable and then dividing a formula field {@CalcPeriodEarned} by the value of the variable. You would need to look through the other formulas in the report until you found another reference to nTotPeriodDays to see how it is being assigned. Variable assignment...

Hi, I'm using CR XI SP2 and SQL Server 2000. I'm trying to code a mailto hyperlink on a text object. The hyperlink sits in the report footer and is a generic email address that the user can send emails to in the event that they have any enquiries about the report. As part of the email I want...

Hey, Its a simple enough question: I know in query analyser that you can use Ctrl Shift C to bulk comment T-SQL. What I don't know is if there is a hotkey to uncomment code. Anyone? Thanks Paulos

Hi, Is there a way to limit the export options available for a user browsing a cyrstal report published under XI R2? I'd like to be able to prohibit their rights to prevent them downloading the file in Crystal Reports Format, RTF and Excel Data Only. I'm even open to config changes as we need...

Hi, I have an issue with URL linking that hopefully someone can help me address. I am using Crystal Reports Server XI to publish seven reports, each with a URL to the 6 other reports. My method of linking reports works fine. My issue arises when attempting to follow a link to a report that...

Hi, I have a CE10 installation where the CMS database is run on a seperate database server, with all other services running on a dedicated CE server. I need to move the CMS database from the database server onto the CE server. I need to know the steps involved in moving the CMS database...

Hi, I'm using XI and SQL server to produce a dashboard report with a number of line graphs. I'm trying to give each line a unique series marker. The default is a square and I want to use triangles and circles as series markers on the other lines. I've been through the charting functionality...

Hi, This almost works but the parameters don't seem to be accepted. I have 3 parameters, how would the syntax change to accomodate 3 parameters on the end? Thanks

Any chance of an example?

Hi, I'm using CR XI and SQL Server. I have the following scanario: Report 1 Details Section - Hyperlink to Report 2 Report 2 Report Header & Footer - Hyperlink to Report 1 Details Section - Hyperlink to Report 3 Report 3 Report Header & Footer - Hyperlink to Report 1 Report Header & Footer...

Anyone?

Hi, I was wondering if anyone has used the ReportLinker custom function as used in the XI sample call centre report. I am attempting to link a pre-generated instance to an on-demand report, passing several parameters as I go. I was wondering if ReportLinker or on-demand sub report was the way...

So is there a syntax for being able to alter multiple columns in the same statement?

Hi, I have a table with fields containing day, month and year which I'm trying to concaternate together into a cohesive date. Can't seem to find the syntax, can anyone help? Thanks Paulos