Ok,
So the "genius that I is" figured it out.
If you schedule a report and then change the filters on the report in Developer but don't on the schedule you may get errorKind. Crystal is smart enough to pull in your criteria but not smart enough to update them if they change.
oh so simple...
So,
I have a report that has a supreport. When I run it in Crystal Developer it works fine. On Infoview it works fine. When I go to schedule it and run it it comes up with the following error:
Error in File X:\MyPath\: Error in formula . '{rptDailySummaryView.Balance} <> 0.00 and ' This...
The title of a book doesn't say Book at the end. But some do. World Book, etc. Titles are important in that they should describe what the report does but you need to use proper English.
For instance:
Master Pick (with out report or list would be silly)
Open Orders for MyCompany (is ok)
If...
So here was my lame, yet effective answer to this problem.
I converted my datasource to a command object.
Unioned it with a query where I distinctly grouped my yr-month's and placed a value for the file name as first alphabetically. So no matter what it came first.
Example
filename |...
lbass, The sorting on the report is irrelevant. In the Chart Expert under Data you choose what "On Change of" event makes a new bar to stack. I've chosen based on File name and then month summing up how many times the item was downloaded over time. It works well except that items don't get...
I believe that what is happening is it is not adding the group until it reaches a record with a value. So if the first file name has 2006-08 & 2006-09, then those get put first in the list. Next it continues on until it finaly hits 2006-07. Which then puts it out of order.
So,
I've built I Stacked Bar Graph and my group by is on Year-Month, so October would be 2006-10. The report data goes in perfect order... 2006-07, 2006-08, 2006-09, 2006-10 the stacked bar however appears as randomly as you can. Showing the 2006-08 data first, then 09 then, 10 and if they...
Problem Solved,
It appears that in Business Objects XI if you are working with Business Views then you must save the report you are working on at the Server. Otherwise you get the errors above. In one book it said a Business View is essentially the same as a Data Connection. Well I guess one...
Ok,
That doesn't seem like it should be that way. I would think that as a Business View user (which you'd have to have rights to see the View) you'd be able to access that data. Since you are building the Data Connections on the Server it must be the servers credentials that are being used to...
Thanks for the response!
On the Server we have a Crystal user set up that has rights to the necessary databases. When I write the report I have no way of setting whom I am connecting to the business view as. I believe that since the Business View has a way to assign rights that I should be...
I am getting the Errors: Cannot Open Database and then Unknown Database Connector when attempting to connect a report to a Business View that is using a Dynamic Data Connection (it also happens if I don't make it Dynamic). I am using Integrated Security on the Data Connection.
The Business...
I don't believe Crystal has the ability to Union from two different databases. So you would have to create a Union using a database engine that has that power.
You could use Access, set up two ODBC links and then build a Union Query then have Crystal point to that Query.
Or for even more...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.