Search results for query: *

It worked perfectly LB Thanks a million!! Much appreciated!!

Thanks for you replys first of all! I use CR 10 and WinXP. Info is displayed at the group level (month). What I'm trying to achieve is what follows: Revenue in January is 100, revenue in Feb is 80 so beside Feb and 80 I need to create a formula the displays a field that contains the...

Hi, I have to calculate the variation in terms of revenue month on month so the report should look like this: Month Revenue Variation Jan 100 Feb 80 -20% Mar 70 -12.5% Apr 90 +22% May 110 +18% Jun...

Hi, This report runs successfully on the CMC and the method to call it is using a webpage I created that has a link to the report. Thanks for your reply Turkbear Regards

Hi guys: I have Crystal Enterprise Express v10 installed. IIS works as a web server. I'm trying to publish a parameter-driven report on a website that I've created. From this website I click on a link and the report should get opened but when I click on the link I get a 'Crystal Report Viewing...

Hi, I'd need to create a chart able to display bars reflecting volumes by month for a given country and then a line showing the % monthly productivity too? Anyone know if this is possible in Crystal? Many thanks

well, the BLOB field in question contains strings (no images or files) which is what I expect Crystal to return but it doesnt. The reason why I know there is a string is because if a pull a query from the database using MySQL Command Line Client I see a string on the column containing the blob...

Crystal Reports Professional v.10 Database: Remote MySQL database Connection method: ODBC conn Type of data in the BLOB: I dont know and the DBA is not telling me I dont know how to set its format to grow. So, basically I establish an odbc conn between CR and the database, choose one table...

Hi all, I'm trying to include a BLOB field in one of my reports but the field appears as empty (although I know the blob isn't) when I execute the report. CR says that BLOB fields can be inserted into reports as any other data type but doesnt seem to be working for me. Many thanks

Awesome!! Thanks a mil guys!!

Thanks for that CautionMP but 'Date()-7' only gives us the records for today - 7. In any case what I'd like to do is run a query able to give me always the numbers for the previous week regardless of the day of the week that I run the query. Any idea? Cheers

I've created a query in Access that gives me all the records for the previous month for a given section of the business by filtering on the criteria'Month(Now()) - 1' for close_date. I need to do the same but weekly but 'WEEK' is not a reserved word like MONTH'. Any idea? Cheers

Since this morning my users get the error message 'Automation server can't create object' when they try to open Crystal Enterprise to see the reports scheduled. I havent changed/installed/uninstall anything so I dont know what is going wrong. Any help please??????????? Many thanks Breixo

Well, definitely not the connections to the database server used for the CMS. On Crystal Management Console > settings > metrics I see the account activity. One of them is 'System Connection' so I can see the amount of System Connections logged on. The number of system connection logged on...

Hi guys, Does anyone know how to kill system connections in Crystal Enterprise v.10? I know how to kill user connections but I have to reboot the server every so often because the system connections reach the limit authorized by the application and nobody can logon afterwards.

I'm trying to open a Crystal Report from a browser having CE10 Express installed. I've created a virtual directory in IIS with html pages that I point to CR reports but the message "Web Component Server could not log you on to the CMS" is displayed when I try to open up the report via web. Do I...