Search results for query: *

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...

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 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...

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...

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...

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...

Nesting an IF STATEMENT in Crystal Reports Example Category = (1,2,3,4) I need to group these groups by 1 2 123 1234 How would a write an if statement to handle this If Category = 1 then “1” else if Category = 2 then “2” else if Category = 1 or Category = 2 or Category = 3 then “123”...