Search results for query: *

What is the URL for calling a report in Crystal Reports Server 2008. In CE10, it was http://server/reportfolder/reportname.rpt?apsuser=username&;; apspassword=userpasswd&apsauthtype=Enterprise&DBuser0=dbusername& password0=DBpasswd&;prompt0=200505&prompt1=0001&prompt2=1&;init=actx I did not...

How do I delete CE entries in registry other than searching and deleting one by one? I want to install Crystl Reports Server 2008 and delete the CE 10 entries. Thanks!

Hi, I am new to Command object usage. I am using Crystal ver 10 and SQL Server database. I am having a report where I display values for a club for range of months selected, year selected and club selected. These are all parameters. I also need to display a summarized total of all clubs and...

I am using Crystal Reports 10. I am accepting the year1, year2(to compare against year1 data), start month, end month. I'd like the record selection to limit to transaction dates that are in the range - start month year1 to end month year1, start month year2 to end month year2. e.g Trans_date...

Pardon my ignorance on viewers. We use the Activex viewer. They say that the Activex viewer will not support interactive sorting and parameter panel. So can we just plugin the other viewers for the reports that we have? Which one would be closest? Thanks!

Hi, I am using Crystal Reports Advanced Developer v10. My table has case number, case year, date and case type. In the crosstab, rows - I display case type and columns I display count of cases for each calendar quarter. If there is no data, the column for which there is data is displayed. I...

Hi, I am using Crystal 10 developer and enterprise. I am new to stored procedure and crystal combination. I managed to design a report and use the parameters passed from crystal to the stored procedure which is my data source successfully. One of the parameters needs to accept multiple choices...

Hi, I am using Crystal Reports 10 and Crystal Enterprise 10. I designed a report to use a stored procedure as input. The problem I am facing is when I refresh the report, it shows the stored procedure field names. When I rename them, it sometimes changes them back to the stored procedure names...

Hi, I am using CR 10 and CE 10. Has anyone done scheduling reports 'Quarterly'. There is no option for the same and I had to define a calendar. It worked like a charm but I wonder why there is no 'Quarterly' selection since it is a common need. Am I missing something?

Hi, I use Crystal Reports 10 and CE 10. Database is SQl server. We have different departments and some have different databases. I have recently started getting requests from new departments for estimates to do reports. This will involve researching their database fot the first time. How do...

Hi, I am using Crystal Reports 10 and CE10. I have a transaction table that has transaction date and amount e.g 1/1/07 $1000 2/1/07 $2000 1/1/06 $1000 2/1/06 $3000 3/1/06 $1000 I display sum of current year, sum of previous year and %change for YTD. I want the data...

Hi, I am using Crystal Reports 10. I have a memo field in the database SQL server. The string can be somthing like this 'Customer requested $200. Paid customer $100. Case is resolved'. The field is Officecomments. I want to search for every $ occurence and highlight it in some way on a...

I imported all objects from CE10 to Cystal Reports Server XI after creating CMS database. I imported all objects etc. The id's changed. I asked Business Objects support and they said that new id's get generated. I find it hard to believe since I will have to put in the new id's in all my url...

I am porting the reports from CE10 to Crystal Reports Server XI. I was using the following link to access reports. What would be the corresponding link in XI...

Hi guys, I want to appear for the PMP this year. In order to get the contact hours and prepare for the exam, I was given 2 resources - 4pm.com and IIL. I would like to know which one of them or any other that you guys found useful. Did anyone just read on their own and pass the exam? Thanks!

I want to do a report as follows - We have unique case numbers. I need to display how many cases took < 24 hours, how many cases took < 48 hours and how many took > 48 hours. As you can see, the count of cases < 24 will come in all the 3 i.e < 24, < 48 and > 48. I need to display % totals for...

I am using CR10. I have startmonth and endmonth as parameters. I want to display in the Report header the months in words though I accept it as numeric i.e. 1, 2, 3, 4. I know I can use MonthName to get the month as January, February etc but how do I do it in one go in a formula? I dont want to...

I am using CR 10 and I am having a strange issue. I had this chart working since quite a few months and now all of a sudden with no change at all I am getting this error - A print time formula that modifies variables is used in a chart/map i.e @AverageResolutionforType The chart in questions...

I am using Crystal Reports Advanced Developer version 10.0 I have a grouping on Suplr Name and then a grouping on Product TYpe. Suplr 1 Totalm1 PrevyrTotalm1 Prod Type a Totalm1 PrevyrTotalm1 Prod Type b Totalm1 PrevyrTotalm1 Supr2...

O am using Crystal Reports 10. I have 2 tables suplr and prod_trans. For the selected suppliers, I want to print data from prod_trans table. Even if there is no data in the prod_trans table, I want to print zeros. I have grouped by suplr. For suppliers who have no data, I do not see them on...