Search results for query: *

IdoMillet, Thanks very much for your helpful reply and explanation! I will try sub-reports as you suggest. Thanks! Kevin

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

Ken, Thank you very much for your reply. I have learned much from your posts. You are Da Man and I appreciate you replying! I read the link you sent. I am exporting as Excel (97-2003), not as Excel (97-2003)Data-only. The subreport is a mirror of the main report. The only difference is...

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

Ken, I updated CR 2008 with SP3 on a Win XP machine and am having the same experience, being forced to refresh parameters again before the report will save. This annoys me,so I am interested in your statement about "rolling back to SP2". How do you do this? Are you just re-installing a clean...

Thanks Ian & LB. I appreciate the feedback

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

Bruce & Kray, Thank you both for your suggestions! I will check out Export UFL and also read about customizing the XML. Thanks for responding!

bump. Still hoping for some feedback

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

Thanks lbass. As always, your solution works perfectly.

lbass, Thanks as always for taking the time to help me. I modified the formula to DateVar Array ExcludedDays; if {DVDN.row_date} in {@ExcludedDays} then 1 else 0 but I am still getting an error message saying "a date range is required here" and highlighting {@ExcludedDays} in that...

No I cannot exclude them in the selection criteria, because certain parts of the data for that day is being used.

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

fisheromacse, Thanks very much! I will try them!

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

Visual Studios was installed first.

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

Thanks very much LBass. Once again it works perfectly. I want to be you when I grow up! :-)