REPORTS IN ORACLE 10G

Feb 22, 2008

HI FRIENDS
I HAVE SOME PROBLEM IN ORACLE 10G. I HAD TRY TO CREATE A REPORT IN 10G BUT SOME HOW I DONT KNOW THERE IS COMPILATION ERROR , WHICH I DONT UNDERSTAND ,IF THERE IS ANYBODY TO SOLVE IT
I POST MY PROBLEM WITH ERROR MESSAGE.

CREATE OR REPLACE FORCE VIEW "RES" ("ROLLNO", "ANAPHYNO", "ANAPHYSIOIA", "NUTRIBIONO", "NUTRIBIOIA", "TOTAL1", "TOTAL2", "RESANA") AS
select "BARCODEDETAIL"."ROLLNO" as "ROLLNO",
"THEORY"."ANAPHYNO" as "ANAPHYNO",
"INTERNALASSESSMENT"."ANAPHYSIOIA" as "ANAPHYSIOIA",
"THEORY"."NUTRIBIONO" as "NUTRIBIONO",
"INTERNALASSESSMENT"."NUTRIBIOIA" as "NUTRIBIOIA",
"THEORY"."ANAPHYNO" + "INTERNALASSESSMENT"."ANAPHYSIOIA" as Total1,
"THEORY"."NUTRIBIONO" + "INTERNALASSESSMENT"."NUTRIBIOIA" as Total2,
CASE WHEN ("THEORY"."ANAPHYNO">=.5*"THEORY"."ANAPHYNO") THEN "PASSED" ELSE "fail" END as RESANA
from "THEORY" "THEORY",
"INTERNALASSESSMENT" "INTERNALASSESSMENT",
"BARCODEDETAIL" "BARCODEDETAIL"
where "BARCODEDETAIL"."ROLLNO"="INTERNALASSESSMENT"."ROLLNO"
and "BARCODEDETAIL"."ANAPHYBC"="THEORY"."ANAPHYBC"
and "THEORY"."NUTRIBIOBC"="BARCODEDETAIL"."NUTRIBIOBC"
/

ERROR MESSAGE
COMPILATION FAILED,LINE(0(00:03:08)
ORA-00904: "FAIL":INVALID IDENTIFIER

View 1 Replies


ADVERTISEMENT

Issues Using Parameterised Reports Connecting To Oracle Using ODBC And Microsoft OLE DB Provider For Oracle

Sep 12, 2007

I have an issue using parameterised reports connecting to Oracle using "ODBC" and "Microsoft OLE DB Provider for Oracle" using parameteried reports. The following error is generated "ORA-01008 not all variables bound (Microsoft OLE DB Provider for Oracle)" and a similiar one for ODBC. It works fine for simple reports. Do these 2 drivers have issues passing parameters for a remote Oracle query?
Thanks.

View 4 Replies View Related

SSRS Reports With Oracle DB--some One Plz Help Me.

Nov 21, 2007



Hi Guys,
I am creating SSRS report using Oracle DB. When i run this query in TOAD, it's giving output but when i run this in SSRS to create new dataset then it is giving me ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle).

This is the query iam running.

SELECT ts.transaction_status_desc, COUNT (ut.transaction_id) AS transcount
FROM dsc_transaction_status_vl ts,
dsc_user_transaction ut,
billing_markets bm,
retail_location rl,
cash_register cr
WHERE ts.transaction_status = ut.transaction_status
AND ut.cr_number = cr.cr_number
AND cr.rl_number = rl.rl_number
AND ut.RL_NUMBER = rl.RL_NUMBER
AND rl.bm_code = bm.bm_code
AND (ut.creation_date BETWEEN tartDate AND :EndDate)
AND bm.bm_name IN
(CASE (:Market)
WHEN 'OKC' THEN ('OKLAHOMA CITY' || 'TULSA')
WHEN 'NFL' THEN ( 'DAYTONA'|| 'JACKSONVILL' || 'MELBOURNE'|| 'NORTH FLORIDA'|| 'ORLANDO' || 'WEST FLORIDA' )
WHEN 'LA' THEN ('PAC Los Angeles')
WHEN 'CAR' THEN ('Carolinas')
END
)

I am passing 3 parameters: StartDate, EndDate and Market.
we have 3 markets and each market includes some cities. Cities are in BM_NAME column.
My Question is that
1) How to pass parameters for Oracle using SSRS
2) How to resolve this error: ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle)
3)How can i write Stored Procedure for this query & How to execute SP in SSRS.

Please reply me. Thanks in advance.

Thanks
Santosh

View 11 Replies View Related

Reports And Oracle Error

Nov 29, 2007



Hi,

I am using a Oracle database to connect to and generate reports from it. Intermittently, the report after running for sometime raises the oracle error

ORA-12842: Cursor invalidated during parallel execution, which I read could possibly be due to DDL on a schema object and shared pool being flushed. Rerunning again, the report runs fine.

How can this be resolved. Any suggestions/tips are appreciated.

Thanks,
Swami

View 3 Replies View Related

Cannot Connect To Oracle Using SSIS Or Crystal Reports

Oct 9, 2007

I am working with the IT department at a client site trying to hook into Oracle. We are using Windows Server 2003 64-bit, SQL Server 2005 Standard 64-bit, Oracle 10-g 64-bit and Linux Red Hat 64-bit. All service packs are current.

We are working on a data warehouse project where we need to import Oracle information periodically throughout the day and integrate it in a central location with data already residing in SQL Server. This is the first time I have tried to pull data from Oracle. The databases in Oracle and SQL Server that we are pulling data from are third party application databases.

My client cannot connect to Oracle using Crystal ODBC connections. When we use either the .NETor OLEDB connections, we get the "client tools need to be installed" message. We do have the client tools installed on the WIndows Server that SQL Server is installed on. We can connect to Oracle from this locattion using Aqua Data Studio and SQL *PLUS. I checked and there is only one tnsnames.ora file on the server. I used the name from there to try to connect using SSIS. Still no luck.

I did see somewhere that there is a possible issue with 64-bit installations. We really need to get this connection working.

Thanks!

Jeanne :-)

View 2 Replies View Related

Migrate Oracle Discoverer Reports To SqlServer 2005

Mar 12, 2008



Hello everybody.

Recently my boss decide migrate reports in Oracle Discoverer to SqlServer 2005 using Reporting Services..because SqlServer is less expensive than Oracle. ..
Well I don't know exactly How do I began? because it's new for me.
Any has experienced? Can you give any recomendations to migration?


Thanks.

View 1 Replies View Related

Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options

Nov 5, 2007

Hello SQL Server Experts, Data Analysts, and Report Writers et al:

re: Reporting Options with SQL Server

I wanted to propose an offshoot to the pryor thread:

Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?

I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?

Thank you to all, and I hope this is a beneficial discussion to others.

Hal1490



Hal9000

View 4 Replies View Related

Reports Usage Frequency For All The Existing Reports On SSRS 2000

Mar 18, 2008

I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.

Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?

I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.

Any help is appreciated

View 2 Replies View Related

Reports Usage Frequency For All The Existing Reports On SSRS 2000

Mar 18, 2008

I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.

Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?

I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.

Any help is appreciated

View 1 Replies View Related

Output Column Has A Precision That Is Not Valid (loading From Oracle Using OraOLEDB.Oracle.1)

Apr 2, 2007

Hi!



I'm loading from Oracle using the OraOLEDB.Oracle.1 provider since I need unicode support and I get the following error:



TITLE: Microsoft Visual Studio
------------------------------

Error at myTask [DTS.Pipeline]: The "output column "myColumn" (9134)" has a precision that is not valid. The precision must be between 1 and 38.



------------------------------
ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0204018 (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
BUTTONS:

OK
------------------------------
For most of my queries to Oracle I can cast the columns to get rid of the error (CAST x AS DECIMAL(10) etc), but this does not work for:



1) Union

I have a select like "SELECT NVL(myColumn, 0) .... FROM myTable UNION SELECT 0 AS myColumn, .... FROM DUAL"

Even if I cast the columns in both selects (SELECT CAST(NVL(myColumn, 0) AS DECIMAL(10, 0) .... UNION SELECT CAST(0 AS DECIMAL(10, 0)) AS myColumn, .... FROM DUAL) I still get the error above.



2) SQL command from variable

The select basically looks like this:

"SELECT Column1, Column2, ... FROM myTable WHERE Updated BETWEEN User::LastLoad AND User::CurrentLoad"

Again, even if I cast all columns (like in the union), I still get the same error.



Any help would be greatly appreciated. Thanks!

View 10 Replies View Related

Setting Up Oracle Linked Server : Need Help : Sql2005 Running On XP Linking In Oracle 10.2

Oct 26, 2006

Is there any step by step help sites for setting up SQL 2005 linked (oracle 10) server?

I find MSDN articles but they referance winNT and 2000, I'm not getting very far and I'm not a DBA but need to get this working asap.

View 1 Replies View Related

Data Access :: Accessing Oracle Tables From Server Via Oracle DBLINK?

May 8, 2015

we recently got a scenario that we need to get the data from oracle tables which is installed on third party servers. we have sqlserver installed on ourservers. so they have created a DBLINK in oracle server to our sqlserver and published the DBLINK name.

what are the next steps that i need to follow on my sqlserver in order to access the oracle tables ?

View 2 Replies View Related

Oracle Connection Fail With Microsoft OLEDB Provider For Oracle MSDAORA.1

Feb 22, 2006

Hello,

On my dev server I have working ssis packages that use connections Microsoft OLEDB provider for Oracle MSDAORA.1 and Oracle provider for oledb and OracleClient data provider.

I use one or the other according to my needs.

In anticipation and to prepare for the build of a new production server, I have build a test server from scratch and deployed to it the entire dev.

Almost everything works except Microsoft OLEDB provider for Oracle.

ssis packages on the test machine will return an error

Error at Pull Calendar from One [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "one.oledb" failed with error code 0xC0202009.

Error at Pull Calendar from One [DTS.Pipeline]: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

[Connection manager "one.oledb"]: An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.".

I have used the same installers for OS, SQL and Oracle SQL*Net on both dev and test machines. The install and then the restore/deployment on Test went fine.

Does anyone could point me to the right direction to solve this issue?

Thanks,

Philippe

View 17 Replies View Related

Oracle Publication Error:The Permissions Associated With The Administrator Login For Oracle Publisher 'test1' Are Not Sufficient

Jan 12, 2006

Hi,

I am trying to make an oracle publiching from sql server 2005 enterprise final release, i installed the oracle client  10.2 (10g) on the same server where sql server already installed, i made different connection to oracle database instance and it was  ok.

 

from sql server : right click on publication -New oracle publication-Next-Add Oracle Publisher-Add button-Add Oracle Publisher-i entered server insttance test1 and their users and passwords--connect --->

the oracle publisher is displayed in the list of publisher but when press ok i got the following error :

TITLE: Distributor Properties
------------------------------

An error occurred applying the changes to the Distributor.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=ErrorApplyingDistributor&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

SQL Server could not enable 'test1' as a Publisher. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The permissions associated with the administrator login for Oracle publisher 'test1' are not sufficient.
Changed database context to 'master'. (Microsoft SQL Server, Error: 21684)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=21684&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Any idea about this error ?

Thanks

Tarek Ghazali
SQL Server MVP.


 

View 2 Replies View Related

Remove All Reports ( Not Data Sources) From Reports Server

Jan 23, 2007

Hi does anyone know how to do the above with out going through reportserver url?

Preferably by using a cmd tool ? such rs.exe

or through the backend in the reportserver DB?

Thanks

Dave

View 2 Replies View Related

Inserting Into Oracle Table That Has DATE_HIGH As A Partition And Need Oracle Sequence Used

May 11, 2007

Hi Everyone,



I've been searching for a solution for this for a week-ish, so I thought I would post my quesiton directly. Here is my scenario..



Source: MS SQL Server

Destination: Oracle 10g



The destination table has a partition set on a column called "DATE_HIGH". How do I populate this date high column in my package? Currently I just have a source object, and a destination object, but I'm unclear how to populate this field in the destination. I've read one blog that states "use OLE DB Command" - but that isn't enough information for me to implement - Can someone be more specific in these steps? Here is an example of what my newb-ness needs to understand



OLE DB Source (Select * from Table) ---> OLE DB Command (What query goes here?) --> OLE DB Destination.



Second part of my question: There is a second column called "ROW_NUM" and there is an Oracle Sequence provided to me... What objects do I need (Source, Destination, OLE DB Command etc...) and how do I call this sequence to populate on the fly as I'm loading data from my source?



If these are simple questions - my appologies, I am new to the product.



Best Regards,



Steve Collins

View 1 Replies View Related

Unable To Connect To Oracle Using Microsoft OLEDB Provider For Oracle

Aug 23, 2007

Hi everybody,

I have designed a DTS package which will migrate a view from Sqlserver 2000 to Oracle.My package is using Microsoft OLEDB provider for Oracle driver for connecting to oracle.Im able to execute this package on the my system ie on the system where sqlclient is installed(Oracle client is also installed on my machine) .But when im doing it on the server im not able to do it.The Connection to Oracle Fails.
I wanted to know in order to connect to Oracle from the server,is it necessary that Oracle has to be installed on the server?.If yes, is it enough if i install oracle client on the server or Oracle Server version has to be installed on Server.

Please suggest me wht should i do know?

Thanks in advance

Regards
Arvind L

View 3 Replies View Related

Trouble With: Linked Server To Oracle Using OraOLEDB.ORacle Provider

Jan 11, 2007

Hi--

 

I am running SQL Server 2005 on Win2k3:

Microsoft SQL Server Management Studio      9.00.2047.00
Microsoft Analysis Services Client Tools      2005.090.2047.00
Microsoft Data Access Components (MDAC)      2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML      2.6 3.0 4.0 6.0
Microsoft Internet Explorer      6.0.3790.1830
Microsoft .NET Framework      2.0.50727.42
Operating System      5.2.3790


I have the OraOLEDB.Oracle provider installed to the (C:oraclexe) directory.

I am having problems querying from linked oracle server.  When i setup oracle as a linked server and purposely enter an incorrect password the query i run tells me i have an incorrect password.   So it at least knows that.  when i set the correct password and run a query I get this error:

(i replaced the real server name with "someServer".)

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "OraOLEDB.Oracle" for linked server "SomeServer" reported an error. The provider did not give any information about the error.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "SomeServer".

 

This is how I set up my Linked server:

Provider: "Oracle Provider for OLE DB"

Product Name: SomeServer

Data Source: SomeServer

Provider String:  "Provider=OraOLEDB.Oracle;Data Source=SomeServer;User Id=MyLogin;Password=MyPassword"

 

 

The query I run is:

Select * from [Someserver].[schema or database]..[tbl_name]

 

Any help???  What am i missing?

View 3 Replies View Related

Oracle Parameterized Queries To Update Oracle Table Do Not Work

Apr 23, 2007

Oracle and MS drivers do not support parameterized queries, so update table set column=? where primarykey=? does not work for Oracle.



Anyone knows how to update an Oracle table through SSIS?



Thanks!

Wenbiao

View 5 Replies View Related

How To Migrate Oracle Applications 11.03/Oracle 8.05 To Navision 4.0/ms Sqlserver

Oct 29, 2005

need a clue about how to migrate the data from an Oracle applications 11.03 and underlying Oracle 8.05 database to navision 4.0 running sql server 2000

tia

View 1 Replies View Related

Migration Of SQL Reports 2000 To SQL Reports 2005

Feb 13, 2008

Hi Friends,

Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...

Could anyone explain me. How it works.


Thanks
sqlferns

View 2 Replies View Related

Converting Crystal Reports To SSRS Reports

Mar 27, 2008


My issue is with converting multi-value parameters:

In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).

As an example:

I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".

With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127

This will only return results within those ranges.


Does anyone know if SSRS provides this kind of functionality?

Thanks,

Patrick Conway

View 9 Replies View Related

Copy Reports From Other Users My Reports Folder

Aug 7, 2007

Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.

The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.


Is there a way to do this?

Thanks for your help.

View 3 Replies View Related

Oracle Error ORA-12154 From An Application Which Never Uses Oracle

Mar 14, 2008

My application which ran perfectly well yesterday suddenly stopped working in this morning with following error message. I didn't change anything, at least I believe. Interesting thing is that I don't use any Oracle connection but connects to MS SQL Server 2005 Express version locally. Error messages are different according to the connection string though I don't think it makes difference:
ConnectionString = <add key="Databasehandtool1" value="Data Source=.SQLEXPRESS;Database=handtool;SSPI=true" />ErrorMessage from VS2008 ="Unable to get records. Object reference not set to an instance of an object."
ConnectionString = <add key="Databasehandtool1" value="Data Source=.SQLEXPRESS;Database=handtool;User Id=handtool_DB;Password=mypassword" />ErrorMessage from VS2008 =  "Unable to get records. Unable to connect to database. ORA-12154: TNS:could not resolve the connect identifier specified."   By the way, the application was generated from IronSpeed 5.1 Enterprise. My development environment is : VS2008, SQL2005 EXPRESS, Windows XP SP2, ASP.NET 2.0 
We have actually an Oracle server in the network though. My gut feeling is that something might have changed in my network server during the night but how come it can possibly affect my application running on my local PC. I checked the connection of local SQL Express Server from SQL Server Management Studio and it connected well with UserID=handtoo_DB and showed all tables and stored procedures required for the application. So there is no problem in SQL Server database side.
I would welcome and appreciate any input.
fudata

View 1 Replies View Related

Using SSIS For ETL From Oracle 10g ODS Into Oracle DW And From There Into SSAS Cubes

May 2, 2007

Hi,





This might seems a little 'out there', but has anyone tried doing ETL from an Oracle 10g ODS into an Oracle 10g DW, and from there into SSAS2005 cubes?



Any caveats houghtscomments on doing this?



Thanks,

JGP

View 1 Replies View Related

How To Show ChartFX Reports In ReportServer And How To Show Tooltips For Reports Using Chart Properties

Dec 31, 2007



Hi all,

I have two problems.

1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.

2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.

Thanks,
Mahesh Manthena

View 1 Replies View Related

Reports About The Reports Usage

Apr 18, 2007

Hi,



We just deployed a report solution and I would like to know when and how much each report is used. Is there a report for it ?



With regards,



Constantijn Enders

View 3 Replies View Related

Reports

Oct 24, 2006

Hi all, how can we get running totals for particular column in sqlserver crystal reports

View 1 Replies View Related

Reports

Oct 24, 2006

how to get running totals for a particular field in sqlserver reports

View 2 Replies View Related

Really Need HELP With REPORTS

Nov 8, 2007

Hi,
I have all stored procedures for report for this month and previous month. Now my task is to generate report to find out the difference for all coulms those are same for both month reports.
EX of final report

Month1|Month2|Difference|
sales |Sales | % |
| | |
| | |
| | |


There are other colums in those rows too..
So could any one help me out.
I want my out put in Excel sheet
And its a recuant report ..so i have to use stored procedure.

LOOKING FOR HELP ASAP

View 1 Replies View Related

How To Know Which Reports Are Being Run

Feb 20, 2008

How to know which reports are being run/accessed ? Do i have to query some tables for that.

View 1 Replies View Related

SQL Reports.

Jul 20, 2005

Hi,I have some queries regarding SQL Reports.1. What is SQL Reporting Services?2. What is it's Architechture?3. When it gonna release?It is urgent.If somebody can give me answers quickly.....Thanks in advance,Pratik

View 1 Replies View Related

Sub-reports

Nov 30, 2007

I am using a sub-report to render a group which contains the detail lines in my report. The report works fine, however, it is not page-breaking, so the report is rendered in just one looonnnggg page with many detail lines.
How do I force the report to page-break when it hits the page length.
Thanks for your help or leads.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved