Search results for query: *

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...

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...

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, 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...

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...

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

Hi Can you use the alter column statement to alter more that one column at a time, I don't seem to be able to find the right syntax to do this? Thanks Paulos

Hi, We were sold on CE 10 based on the improved export functionality to Excel. CR 10 seems to have a lot more functionality that CE 10 for exporting to excel. E.g. you can turn off page headers, specifiy which section stiplifies the width of cells. I'm playing with CE 10 in a test...

Hi, We're about to upgrade from 8.5 to 10 and I've been looking through the features. I have a couple of questions: 1) In user profiles there is now an email field. I can't find any detail on it in the on-line help. Can it be used to pass the smtp email address to report schedules set to...

Hi, I have a simple crosstab report that I'm trying to export into Excel format in a scheduled job from Crystal Enterprise 8.5. The problem below doesn't appear if I use Crystal Reports 8.5 but does occur from the Enterprise output. Basically when the output is loaded in Excel there are a...

Hi, Here's my issue. I have a table that contains current discounts on products by centre. Table structure CentreNumber - branch/site/centre ProductID - Product on discount EffectiveDate - The date that discount becomes available SMOffers - contains Tier 1 discounts SDOffers - contains Tier...

I have reversed engineered a database and put some tables onto a page. I have managed to drag a relationship connector onto the page and link two tables so that the ends of the connector turn red when highlighted. The problem is that the connecting line does not visually link the two fields and...

Hi, I have a report that is grouping by month on a date/time field. The problem is that the company want to be able to report by 'billing month' rather than 'calender month'. A billing month runs the period of 24th of previous month to 25th of current month. So for example February would be...

Hi, I want to able to group by the billing month. From 25th of Previous month to 24th of current month. How do I go about creating this group and ensuring that it reflects the current month as a title. Example = Billing Month of February 2003 will be from 25th January to 24th February...

Hi, We're currently in the Beta program for C.E. 8.5 but not really getting the support that we need. A couple of questions for anyone out there in similar straights: 1) Since upgrading we have found that the limit on report instances isn't taking affect globally, some objects are limited but...