Recent content by darran6

In the CMC, find the report object (either list all objects or browse through the folders). Once you're looking at the report object, you'll have tabs such as Properties, History, Process etc. Choose Process, then Database. Put your username and password details in there. We also usually...

If you saved the report from the Crystal XI designer to BO, you need to login to the CMC and reset the database login details. The designer does not save the DB login details to the repository when you save the report(!). You can change the refresh options of the report in the CMC so that any...

Hi, BOE XI R2 and RAS SDKs. I'm developing a batch Java bursting application which will burst new instances of various reports to various users. The configuration for "who gets what" is held on our main system DB (Ingres). The Java app gets the parent report ID from the Ingres DB and then...

Madawc, We're trying to use the Crystal Report Server as the place to hold monthly/weekly/daily/on demand reports rather than emailing them to mulitple users who then store them in all sorts of locations. Some of our reports are already produced in PDF format, but others need to be maintained...

Environment: Crystal Reports Developer XI R1 (+ Crystal Reports Server XI R1) Many of our sales reports allow the user to choose a time period (either a number of months or pre-set values like year-to-date, etc.). I have a set of repository custom functions that build a date string (e.g...

Many thanks for that...

Environment: Crystal Report Server XI, Visual Basic Hi, Using the Crystal RS COM SDK, and VB 2005 Express I need to know how to check the permissions on a report (e.g. whether a user is allowed to view/schedule). I'm developing a reporting app for users to be able to see what reports they can...

Hi, You don't need to use an image at all. Use the section expert to set a background colour for each report section as required. When you export to Excel, this background colour will be maintained. Cheers, Darran

Sorry, I'm new to BO so only know about XI. Anyone else?

Yes, We use this functionality in a particular folder where users can schedule reports on demand - each user only sees their own instance(s). You have to set Advanced permissions on the folder or individual report as required. Let me know if you need more detailed info. Cheers, Darran

LB, I hadn't thought of doing it that way - not sure which involves less work. I used product as the row field, rep as the column with the specified ordering as above (after applying a topN). I created a function to show product code and name and summarised on this (nth most frequent : n=1)...

Ido, I've played around with this but can't see how I can possibly show the data in any meaningful fashion. I tried a horizontal bar chart (standard as well as stacked types) and showed sum of units sold on change of rep and product line, with the top 10 group sort on product line. It didn't...

Ido, I hadn't thought of using a graph, but unfortunately this would take up too much page space - the sales manager definitely wants a summary table so all info can be seen at a glance.

LB, I've checked with the sales manager and there will be 9 reps at the meeting.

Ido, The problem with that is each sub-report would have to be maintained individually and set to produce data for one rep at a time - I have done a similar thing with placing cross-tabs side by side for a similar effect but then I only had 4 columns of data to product whereas in this instance...