Recent content by PeterConnick

Mufasa, Do you want 6 commas to appear regardless of how many, or how few, languages appear for each provider (to a maximum of 7)? Yes, I want 6 commas to appear for each provider and 7 is the maximum number even if there are 8 or more languages. What I am actually doing is creating a text...

Mufasa, Let start off by saying, thank you. I have been spinning my wheels all day trying to figure this out. I created the function and ran the SQL and it worked perfectly. Actually, what I am trying to do is capture the first 7 languages (omit 8 and above). If the person only speaks 1...

Mufasa, - Will there always be a consistent number of values (e.g., 3 or less, or, 8 or less, et cetera) for each distinct providerid? There will always be at least one 1 value per distinct providerid, but there is no limit to the number of languages the providerid could have. - Is there...

Oracle 9i I have a query like SELECT a.providerid, a.languageid FROM tblProviderLanguages a 10 1 10 2 10 3 20 2 20 3 20 5 I will join a.languageid later to get the language code Any idea how I can retrieve the data like this: 10 1 2 3 20 2 3 5 Please note the languageid can have 1000...

synapsevampire That worked thanks

Crystal 8.5 Oracle DB In my group footer I am using a running to sum all transactions. There are time when I have a payment (+ $50.00) and a return ( - $50.00) End result being $0.00. I what to be able to suppress the entire page as I am doing on page break on this group. I can suppress...

I was afraid that was going to be the answer. Thanks for the response.

I am using Crystal Reports 10 Oracle DB I have a parameter called city and I want to prompt the user to select a city from a drop down list. Table Name Address Field Name City {ADDRESS.CITY} When I originally built the parameter, I selected table ADDRESS and the field City and...

Never mind I got it. Here how I did it just in case some else is having the same problem. Create two new formulas WhilePrintingRecords; stringvar depart := ''; WhilePrintingRecords; stringvar dest := ''; Then I placed this in the group header 2 (Ticket Number) Thanks again LBass

LBass I followed your instructions above and it worked for the first line. Ticket Number Passenger Name Depart Dest 1 Paul Smith YFB OTT The second line of the report will display the Ticket Number 2 and so on. Here is what I am getting. Mary & Peter's...

Crystal Report 8.5 ODBC Oracle Database I need to get the Departure value and the final Destination value from the travel legs table. Here is an example. If an invoice item contains a stopover on a trip (e.g., Rankin Inlet to Iqaluit to Ottawa), the invoice item will have two travel legs...

Thanks that works. One more easy one for you. Now that I have the TOP 100. How can display the a column with values of 1 through 100 example 1 SUV 2 Car 3 Van 100 Truck

I am new to SQL Server. In Oracle I can use the word ROW NUM to filter how many rows I will return. What word would I use in SQL Server Thanks Peter

Visual Studio 7.1 New Project BI folder for Reporting Services (Report Project) I am using a bubble chart and want to insert a line for x Axis and Y axis. Presently, I have built a graph to display all the bubble and everything looks good. However, I want to add a line for X Axis and Y...

Never mind I figured it out.