Search results for query: *

I am trying to create a Crystal Report with multiple graphs. I use Crystal Developer Version 14.0.2.364RTM on a desktop running Windows 7. I intend to put 6 graphs on this report, 2 to a page. Each graph has it's own SQL query. None of the queries are linked to each other. I put graph 1 in...

Hi. I am using CR Developer, Version 14.0.0.364RTM. I buiilt a simple report, Report1 . Then I created another copy of it that pulls from a different source, Report2. I put Report2 in the report footer of Report1 as a subreport. The subreport touches the left margin. When I run the report in...

Hiya, I am using Crystal Reports 2008 CR Developer Ver 12.1.0.892 against an Oracle DB. Crystal is truncating all the MEMO fields to 2 characters. If I pull the memo field using SQL and not Crystal, the data is all there. When pulled with Crystal, I only get the first two characters. I've...

After updating Crsytal Reports 2008 with the latest service pack I am getting a new message when saving my reports that says "Additonal parameter values are needed before this report can be saved or viewed with data". This happens AFTER the report has run and generated new data and I click the...

I'm making my first attempt at exporting data from Crystal Reports in the XML format to be imported into Xcelsius. I'm using Crystal Reports 2008 ver 12.2.0.290. I am exporting the data using the default Crystal Reports XML schema. When I go to EXCEL (Excel2003) DATA/FROM OTHER SOURCES/FROM...

I have a report that pulls KPIs by Day for a date range entered by the user. I need to be able to exclude item on certain days during the year. The number of days and the dates to be excluded will change. I thought I would create an ExcludedDays list similar to Ken Hamady’s HolidayList, then...

LastFullWeek and LastFullMonth exist, but there is no LastFullYear? I'm sure there must be a solution for this - getting last year's data for comparisons is certainly a routine operation that happens often - but I haven't found one. I don't want LastYearYTD. I need all the data for last year...

Hi, we are having problems installing Crystal Reports XI R2 to a server running MS Server 2003 R2. The installation completes without a problem. But as soon as we try and launch Crystal we get an "access violation" error. I have read multiple posts about "access violation" but all of them...

Hi, I am trying to pull two fields called TICKET# and DESCRIPTION from an Oracle database using Crystal Reports2008. The DESCRIPTION field is in an array table. When I pull TICKET# and DESCRIPTION to the details section of my report, the DESCRIPTION comes out in multiple lines per ticket as...

I'm building a report where the initial records pulled in with SQL are year to date. I want the report to pop a parameter box when the report opens so the operator can enter a start and end date for a record range that will be a subset of the YTD records. I know how to tie parameter boxes to...

I have a report where I want the end date to be the previous day. When doing this in Crystal's record selection I tell it datadate-1. How can I pass datadate-1 in an add command so I don't need to use Crystal's record selection? Thanks!

I have reports that need to check what day of the year it is. On anything other than Jan 1 the reports will pull YTD data. If the date is Jan 1, I want the reports to pull PreviousFullYear. I have played around with DatePart but have not figured out how to do it. Thanks!

In Crystal Reports 2008 I am taking Helpdesk Tickets for YTD and grouping the tickets by category. I am summing the tickets for yesterday and the tickets for the rest of the year separately, then calculating each category’s % of the total tickets for yesterday or the remainder of the year...

I have a login and a logout field where the data is listed in seconds: LOGIN: 1,257,328,840 LOGOUT: 1,257,340,039. I need to convert these to DATETIME formats so we can check schedule adherence. I have tried DateTime({login]) an DateTimeValue({login}). Both generate an error message of "Dates...

I am using add commands to pull data from two similar but separate SQL databases. Each database contains the same three fields: submittime; score; and excluded. I want to be able to pull these fields from both databases and roll them up both separately and combined. I have created two add...

I am using Crystal XI R2 against an Oracle DB. The string in a DB field contains an ID that looks like "uswknp09". I parse the field to get just that ID. Now I need to convert that ID to a full name based on the DB table fields FIRST NAME and LAST NAME. How do I create a formula that ties...

I am trying to use the add command function of the database expert. I am using Crystal 2008 and trying pull data from an Oracle DB. I have the following SQL query that works. [select sum(a.OPEN), sum(b.CLOSED) FROM (Select SC.INCIDENTSM1.OPENED_BY AS ANALYST, Count(*) AS OPEN...

In field explorer I often right click a field in a table and use "browse data" to see what is there. However I can't find a way to determine the data type of a particular field, i.e. string, number, datetime, etc. I have looked in help and searched the FAQ and posts here at Tek Tips, but have...

Hi, I am trying to create a union query in Crystal for the first time. I’ve read numerous previous posts on union queries so I am dangerous now! They helped, but raised as many new questions for me as they answered due to my lack of knowledge. I am using CR X1 R2. I have an Oracle DB that...

I am pulling several months worth of data. The data contains multiple rows for each date. One of my objectives is to get a count of the number of Mondays, number of Tuesdays, number of Wednesdays etc. contained in my data. Since there are multiple rows of data for each date, I tried...