Need to make a formula based on something like this....
record state name
123 NC John
124 NC Bill
125 FL Mary
126 GA Bob
129 TX Susie
130 TX Dave
131 TX Mike
I am grouping records by month (field not...
I have used schedule manager and it does work. However it does NOT work for recurring reports that are scheduled. Those will have to be re-scheduled or use a third party tool or the SDK.
CRXI R2 / Oracle 10
group1 - part number
group 2 - serial number
details - all historical records that fit search critera sorted by date
Only want to show the last two records - - currrent historical record and the record prior....
I created a running total which gives me the total records...
Thank you for the reply CoSpringsGuy.... That is close to what we came up with which is now working perfectly ... I failed to mention that the data is collected in a group; what we ended up with is the following which is very close to yours and basically does the same ....
Two Formulas...
I've seen several posts and answers for 'parameter' join function to show the value in the header of a parameter field and that works very well -- but does not work with a regualr field.
How do you do display the values in a field that is NOT a parameter field. Although I'm not reporting on...
Thank you for this information. That sounds really interesting. Can you tell me the steps? I'm the admin person so there is no one else to ask... except that I'm going to be taking a BO XI Admin class in a couple of weeks so some of these types of questions will be answered.
I have...
It almost sounds like your subreport's page headers are suppressed - Have you tried not suppressing the subreport's page header in your subreports? Don't use the Report header - by design it's only going to print on the first page. I have dozens of reports that have subreports in the footer in...
As lbass and madawc mention, the variable has to appear in a section 'above' the section in which you want to use the data. The shared variable formula in the subreport also must be displayed. To make it show on the same row, go in that section and select 'underlay following section'.
If you...
That is how all of my other services that are not listed are set - to local user. And I bet the local user of that machine does not have rights to the database on the other server. I look forward to hearing back with some good news......
I had a similar issue - changing the services log on account information fixed the problem.
To see what account the crystal server services are using ... go into the central configuration manager - this shows which services are running; check the Central Management Server for example, by...
Check to be sure that the service account that is running the BO services has the rights to access that database. It could be that the 'local' service on that machine may not have the rights needed.
BO XI R1 - Windows Server 2003 R2 SP2 - SQL 2000 SP3
I have some server management questions.
How can I tell how much space 'instances' are taking up?
What is the easiest/best way to delete instances that are old? - - can I select instances by a date range to delete? Is there an auto delete...
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.