Search results for query: *

I have a table with a key, and a previous key. I need to recursively step through the table until I have the key with no previous key (i.e the original record). Is there an sql command I can use to do this, or do I need to program? Field Names are resource_bookings.resource_bookings_id and...

I am using crystal v9.2.2.634 and enterprise Product: 9.0.1.558 I am using Oracle 10g.1.0.5.0 I am connecting using OBDC with Oracle 10g drivers

I am currently working with Oracle, on a database that was very client/data driven. Users could set up practically what they wanted for collecting information, thus we ended up with lots of duplication, and lots of tables containing labels and data. To run reports, to gather all the data, many...

I know from previous work placements that it is possible to grab data from tables without linking, if you know the table, the field, type, etc, and call using a variable or value from calling report. I don't know if this has to be done in a programming environment, or can be done from crystal...

I was reading this with interest, as I need to put default dates (actually, don't have to, it would just be nice) for users for running reports. But I run my reports through enterprise, and the solutions being discussed above don't seem to work. Despite setting default start and end dates to...

I have just done this, and it has worked a dream. Many thanks, I really did not think this was conventional functionality. David

Again, thanks Ibass. I talked to my enterprise administrator, and he is not sure you can do this with the version we are running. Product: 9.0.1.558 Is this possible. Can you give me a tip on how I go about it? Thanks David

Thanks Ibass. But I tried this and got two issues. Firstly, I know I can copy the selects, but what I really want is for if someone changes the selects in the main report, they filter down into the sub report (I have some date selects based on paramters). This is my real problem, how do I filter...

I have a main report with data filtered by select. I would like exactly the same select on my sub report. But I want my sub report to have it's selects automatically mirroring the main report selects. Do I do this with shared variables? Anyone got an example anywhere? As per usual, I'm...

I removed the () and made a calculatd field of 100 characters of the original. Both didn't work, but thankyou for trying to help anyway. Any suggestions as to where I may find a solution, or should I approach business objects? Don't forget, it works in crystal, just not in enterprise. David

I can't seem to get drill down working for a certain report, within the crystal enterprise environment. It drills down in crystal, but not enterprise. The report has 4 groupings. In the 4th grouping footers, there are conditional printing, managed from the sections editor. The important thing...

Thanks LizSara, I have been getting some pretty weird things happen in crystal in my time, but this threw me. Funnily enough, when logging on via other odbc links, or straight through oracle drivers, using same logon, this wasn't happening. Anyway, working for now, so thank you very much. David

I am connecting to Oracle 10g, through ODBC drivers, from Crystal 9. When I am connected, I try to add tables to my report, only to find there are no tables there, only programming procedures and code. The previous person to use this machine and write reports here used to write solely in...

I have used the (very useful) tip of having dynamic grouping within a report by defining a parameter and then assigning it a field. See Example. select {?group} case 'COURSECODE': totext({MBDA_FREEZE_DATA.COURSECODE}) case 'CLOCK' : totext({MBDA_FREEZE_DATA.CLOCK}) case 'COURSE_TITLE' ...

I am trying to concatenate two strings, with a comma and space in the middle. If one of these fields is a blank or null, then the whole string doesn't print. I have never come across this before. Anyone help, sorry it is such a pathetic question. {VENUES.VENUE_NAME} +", "+ {VENUES.LOCATION}...

I am inviting user to input company codes that they wish to exclude from the report. I am then trying to execute the following lines in report record selection formula editor {COMPANY_ADDRESSES.COMPANY_ID} not in ({?Excluded Companies}) I keep getting error 'The remaining text does not seem to...

I am running Enterprise and Crystal Prof v9. I get this error message having posted and run a report on the enterprise server. I can find solutions to v11 but not 9, which seems different. Anyone can help ?