Search results for query: *

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.

Crystal Report 10 Group 2 Header Detail Detail Detail Detail Group 2 Footer A Group 2 Footer B Group 2 Footer C Group 2 Footer D How can I keep together just the group 2 footer? I do not want to include the Group 2 Header. If I check the keep together option, I get a lot of wasted space...

That makes senses. I will give it a try. Thanks again

Here is an example in SQL (Really the code is over 3000 lines) It will not all fit into the command window Select item, sales, 'SPRING' as "SORT" from sales_table where season_code in (1) union all Select item, sales, 'SUMMER' as "SORT" from sales_table where season_code in (2) union all Select...

Crystal Reports 10 Oracle Database 9i This is my real question as I am new to Crystal. I normally do this type of thing in the command window by using the UNION SQL command, but I ran out of room in the command window. Thanks for the advise above. Is it possible to do this in crystal? Dim a...

Sorry about the confusion. The user has asked for a report to be group by season code. Spring = 1 Summer = 2 Spring and Summer = 1, 2 Fall = 3 Winter = 4 Fall and Winter = 3, 4 Total Seasons = 1,2,3,4 I want to get the sales group by the categories listed above. Total Sales in Spring = 100...