Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







SSRS &&"cannot Create A Connection To Datasource&&" Error


Hai All..

I have develop any report in reporting services on server Development. i deploy my report to server production.
i have connection to cube as data source. if open report manager in server production and open the report, its succesfully. the report is open. but if i open report manager in server development show error



An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'PNL'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine
i use windows authentication in my pnl datasource.

thanks

Yudhi


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Cannot Create Connection To Datasource?


I've had this datasource set up for awhile now, and i had it runing off of my login and password (with the selection "Credentials stored securely in the report server" selected). and the check box for †"Impersonate the authenticated user after a connection has been made to the data source" checked. But recently my password expired for my domain account, and i changed it, and now, it is not accepting either my old or new password. What is going wrong?

Here is the error messege:


An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'Reporting_FSSRC'. (rsErrorOpeningConnection)


Login failed for user 'TZaccheus'.

View Replies !   View Related
Cannot Create A Connection To The Datasource 'DataSource1'
Hello, I Created a report with reportbuilder, after clicking on Run Report I got this message,† Its very strange it seems that its trying to generate or create a datasource.



Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
----------------------------
No se puede crear una conexión al origen de datos 'dataSource1'.
----------------------------
Error al procesar el informe.





View Replies !   View Related
2005 Reporting Service - Cannot Create Connection To Oracle Datasource On Web Server
created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project† - works fine connecting and preview of report within ide ,†deployed to Reporting Services web server, received the following error when attempting to run the report on web server:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)

any thoughts or direction greatly appreciated

View Replies !   View Related
Datasource Connection Error
have developed a report on a test server which I can access from i./e. http://localhost/reports

DataSourcce is accessed using a sql login

My colleague on his machine can not access. His error is:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'MarketAnalytics'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

View Replies !   View Related
Cannot Create A Connection To Data Source !!!! SSRS 2005
I cannot get this error†resolve either†for myself or any users, and I'm actually part of the Admin group!† Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password.† I thought that since this datasource was set to Windows Authentification that it would just pass it through?

I'm pulling my hair out at this point:




Screen Shots:










http://www.webfound.net/datasource_connection.jpg









http://www.webfound.net/datasource_connection2.jpg




http://www.webfound.net/datasource_connection3.jpg





Also As far as I know, I've given sufficient permissions to the right logins and right users on my SQL Databases and related stored procs that the datasets (not datasource) run











An error has occurred during report processing.

Cannot create a connection to data source 'datasourcename'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

View Replies !   View Related
Use Sybase Odbc Datasource Or Oledb Datasource,run No Error,but 0 Row Data Output,why? Help Me!!!
use sybase odbc datasource or oledb datasource,run no error,but 0 row data output,why?† help me!!!

use sql server2005 ssis







View Replies !   View Related
SSRS Report As A Datasource To SSIS


Hi All,
Is there a way in SSIS to specify SSRS report as a datasource? I don't see any options in the data flow sources..
Thanks a lot!!


View Replies !   View Related
SSIS Datareader Destination As Datasource For SSRS
I am currently trying to use a SSIS datareader destination as a datasource in Reporting Services (RS). I have sucessfully developed the report and I am able to execute and see the results from it in the RS preview pane.† I am also able to deploy it (same server as RS development and report is on) without errors.† However, once deployed, I am unable to get the report to work in Report Manager.† I get the following error message:



"An error has occurred during report processing. Query execution failed for data set Dynamic_POS_BO_xRef'. The package failed to execute."



I have read everything in BOL regarding configuration of the RS Execution Account and have configured it with a domain member that has admin rights and tryed it with one that has limited rights (best practice recommendation).



Any ideas about what else I can try?



View Replies !   View Related
SSIS As DataSource For SSRS - Failure On Different Machine (Server Vs Dev)
I have developed an SSIS Package which is the Data Source for a Reporting Services report (using the OLE DB Destination DataReader component - very cool and powerfull!!!).

I have one Connection Manager defined in the package to access a SQL Server 2000 Database. The authentication is set to SQL Server Authentication (per the documentation in BOL) where I provide the UserID and Password.

Here is what works and what doesn't work:

In BIDS on my local machine the report executes beautifully.

When deploying the SSIS Package to my local machine's Integration Services File System and the report to my local machine's Report Server database the report executes beautifully (Yes, I'm using the developer edition).

When deploying the package to a W2003 Server Integration Services installation as well as deploying the Report and Data Source to the same W2003 Server's Reporting Services installation - the report fails.

I think it is because the passsword to the SQL Account is not "set".† †I am able to run the package through BIDS via dtexecui on this W2003 server successfully. However, when I run the report on the server it fails.

I am guessing it is because the password for the SQL Server Authenitcation is not "there". I am encrypting via "Save SensitiveDataWithPasssword".

What am I doing wrong? Any suggestions would be welcome.

View Replies !   View Related
Parent-child Hierarchy In A SSRS Project Using A SSAS Datasource
Hi everybody,



I would like to know how to create a hierarchy in a SSAS project using a SSRS datasource?



All values are displayed when I drag the field "parent" in the MDX generator...



Thanks in advance for any idea...











View Replies !   View Related
Programmatically Assigning The Datasource In The Server Report Ssrs 2005
Dear All:

I am new to SSRS 2005.

I have created many shared datsources and reprots at http://localhost/resportserver.


I am trying to access these reports from ReportViewer in the web application. Actually I want to use these reports for different customers †by just changing the datsource programitically.

Is this is a possible?

Thank you
Theju


View Replies !   View Related
XML DataSource, Text Dataset And Image From Database Using Visual Studio 2K5 And SSRS 2K5
"Short" Story Version:

I have a VS 2005 Web Appplication solution that†uses SQL Server Reporting Services 2005.† One of the projects is a Report Server Project. In this project†I have an†RDL file that†has:
1.)a non-shared XML DataSource (no credentials),
2.)a DataSet with a Command Type of Text and a Query String that is as follows:
<Query>
†<XmlData>
††<Root>
<LOAD LOAD_ID_PREFIX="" LOAD_ID="" TRUCK="" DIAGRAM=""/>
††</Root>
†</XmlData>
</Query>†


3.)a field that comes from the Database that is of VarBinary(Max) that is a JPEG Image

What happens is, is that by doing #2 above, at design time I can create tables and hook into my datasets and get the report all designed out the way I want.† Then at runtime, I have a Stored Procedure that uses the "FOR XML AUTO" option so that I can represent my results from the database in an XML fashion which will allow me to replace the†XML Schema†in between the Root tags above (in #2)†with my actual data (which still has the same schema).† I then save the modified RDL to a database table field†and move on to†happily ever after......in this case, not.† In this case, since an VarBinary is involved, unless I want to get a pointer back for the Diagram Column, I have to use the "FOR XML AUTO, BINARY BASE64" option.† This returns an Encoded string to represent the Binary value that was in the Database....and this is the partial source of my angst....read on.

My approach that I described above worked flawlessly in all cases where an image wasn't involved.† This report is the only report in the whole system I am working on that will have an image and it is the last one being done, so that's why I didn't run into this earlier.†

I have tried all kinds of things at different levels, but the thing that I have tried that seemed to me to have the most potential was†to use Embedded Code to take the Encoded†ASCII Value and convert into something binary that the SSRS Reporting Engine likes (so my image will show), but I have been unsuccessful thus far.† The error message I keep getting now from my Embedded†Function is: "Invalid length for a Base-64 char array", which I have not been able to resolve thus far....and I do know that the Binary value in the database is good becuase I can see it in†pages in my application otherwise.††

This aside, is there anyone out there that knows how to take the value of a VarBinary(Max) field and insert it into the Text (XML) DataSet in†the†markup of an†RDL file....and have it appear correctly when the report is rendered in something like the standard Report Viewer Control (or even when being previewed at design time inside of Visual Studio†for that matter)?†

Just to be clear, the root of my problem, as I see and understand it, is that I have a VarBinary value in a database that is being converted†to a string (ASCII...I am presuming) due to how I am writing my stored procedure†and then†needs to go back to something else binary†that the SSRS Engine will accept so that I can see my Image in the report when I render it.

I am†wishful that someone out there understands my problem and†has run into this and has a solution......but I am wishful of winning the lottery, too, and that hasn't happened yet...............

Thanks.

View Replies !   View Related
Error In Trying To Create A New Connection.
†I'll ask for patience cause am new to this....but I am trying to create a new connection while trying to add a new Data Source in Visual Studios, and I keep getting the error "Login failed for user 'Mohaminho-PCMohaminho'." I have tried several things that my little knowledge knows, but no success.
Any ideas anyone?

View Replies !   View Related
Error Message When Trying To Create An SQL Connection
Hi,Just recently I am getting the following error when trying to connect to an SQL DB: Exception has been thrown by target of an invocation. This happens even if I create a new website/solution. Procedure I use:open server explorer and click on create a new connectionchoose SQL server from the listenter my IP address and credentials, click on test and everything is fine. When I go to select the DB the dropdown box is empty, if I type in my database name and click on ok I get the following message:Exception has been thrown by target of an invocationI know it is nothing to do with SQL or credentials as I can create a datasource to my SQL server using my colleagues computer!I have removed VS 2005 from my computer and reinstalled only to be met with the same problem.reinstalling my computer is a last resort!Any ideas?Cheers,  Ps, I can connect to my DB using VB code behind.   

View Replies !   View Related
Cannot Create A Connection To The Data Source Error


Hi,

I have setup SSRS with 3 data models using 3 different datasources on one server.† I can create reports ok, but if any of the other users I want to access these reports tries to open the report†I created†or run there own reports (they can create a report), it gives them the error:

†Report Execution Error

Cannot create a connection to the data source 'datasource1'

I do not recieve this error, but the other users do.† I have set the other users as System administrator in the site-wide permissions, so they have access to everything.

Everything is set to integrated windows authentication.

On the Reporting Server Configuration Manager, the Unattended Execution Account is not selected and is blank.

What could cause these users not to be able to run existing or new reports they create?

Thanks for any help,

Steve



View Replies !   View Related
Cannot Create A Datasource Items
I'm trying to use WSS3 & RS 2005 as Integration Mode.
But i cannot create a data source item on sharepoint site library.

If i go to Central Administration > Configure Reporting Services Integration,

I can see the settings, thats mean that the Report Server is available ( i think so )
And also i can create dataources on Central Administration Web site (//servername:12500)

But from my production server web site ( //servername/ ), i cannot create those items.

I received the message

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.



Can somebody help me to fix that strange behavior.

Thanks.

View Replies !   View Related
How To Create A Datasource Which Is Not Shared
Is it possible to create a datasource, which is not at al shared via vs 2005

View Replies !   View Related
Client Connection Error While Trying To Create Maintenane Plans
Error:  Ole db error 0x80004005 Client unable to establish connection

This happens when trying to create a maintenance plan in sql 2005 sp 1

It has now happend with 3 installs - one fresh install and two upgrades from 2000 to 2005.  The startup account for sql server is a domain user account and has not been changed.  This happens on both windows 2000 and windows 2003. 

 

This however does not happen if the sql startup account is in the local admin group for the machine

 

Any help is greatly appreciated

Thanks

KR

View Replies !   View Related
SQL Error On URL -cannot Create New Connection Because In Manual Or Distributed Transaction Mode
We are using a Standard Microsoft Product called Solomon which has aWeb interface.We have installed this in more than 50 sites but we are getting thefollowing error after being in the Web application for a few minutes:'cannot create new connection because in manual or distributedtransaction mode'Could someone provide some help on how we can have a resolution forthis error.Could this be a SQL Server issue or is it a programming issue.Please assistSam CommarJoin Bytes!

View Replies !   View Related
Unable To Create Datasource In VB 2005 Express
mike writes "Hi
Brand new at SQL and am using VB 2005 express edition with MS SQL 2005 ver 9.00.1116 on windows XP home

Following instructions in the MS free video tutorials lesson 8/9 I created my first database then tried to create a datasource and dataset. The "dataset" appears to create ok but I then get an error message "Could not get type information for ...(mydatabase name) dataset"

I have searched forum and help for some indication why this happens but no luck. Hopefully you maybe able to help.I hope so.Databases are my interest but not skil;led enough to work without an IDE.

Thanks
mike"

View Replies !   View Related
How To Create Cascading Parameters In A Report With Cube As Datasource


I'm trying to create report with datasource as a cube. I'm able to connect to datasource to pull data with a single parameter. But, I'm unable to succeed in creating a cascading parameter.
The following scenario:
†I have a dimension "Period" as Paremeter.
The Period dimension†is cascaded to†year- quarter- month.
So, I would like to create a†cascading parameter for period as year - quarter - month.

Please let me know, how to acheive this.

thanks,
Naveen.

View Replies !   View Related
Missing Permission To Create Datasource, New Folder, Add Security..etc
I have windows 2003 reporting services 2005 that has been working fine.† Now all of a sudden when I go to http://localhost/reports I am unable to assign security to folders(the link is hidden) the New data source button is hidden, the new folder button is hidden, upload folder and report builder are also hidden.† I am logged in as aministrator.





Also when I connect to reporting services through SQL Mgmt Studio I have the same issue, there are no options for permissions only a general option.



I'm sure it's a permissions issue but what do i do to resolve?



Thx

View Replies !   View Related
Nonstop Datasource Connection
Does anyone out there have any ideas on the best way to connect in integration services to a nonstop sql database running on a tandem computer?† We have some odbc drivers that have proven to be problematic and slow to use.† What oledb products I can find apparently come with something that's around $36K per processor to buy.† Thanks.

View Replies !   View Related
Problem With The Connection To The Datasource
Hi everyone,

I have one problem with my reports. I have one Cube and every week, we process the cube to recalculate the measures.
Before, my report can be displayed with any problem but know, since we process the cube, we can't see the reports based on the cube.
The errors display in the report manager are :
rsProcessingAborted and
rsErrorOpeningConnection.

When i try to access the report directly from my local project thanks to visual studio, the reports works well.









I think that it may be a problem of rights and abilitations. Or maybe it'a an IIS problem ? Or a firewall problem ?







Thanks for your response.

Shaouk.


View Replies !   View Related
Nonstop Datasource Connection
Hi, the integration services forum recommended that I come over here for this.† Here's what I posted there:

Does anyone out there have any ideas on the best way to connect in integration services to a nonstop sql database running on a tandem computer?† We have some odbc drivers that have proven to be problematic and slow to use.† What oledb products I can find apparently come with something that's around $36K per processor to buy.† Thanks.



View Replies !   View Related
Batch Script To Create ODBC And Update Registry Datasource Key - Help!


I†have create a batch file, that creates an ODBC then updates the application datasource key in the registry to the new system dsn name.

The problem is that†the new DSN doesn't work when i try and connect the application...but if i had manually created the odbc source the app connects as expected... i have checked the registry and there is no difference between the two dsns created...but the application throws IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified after i have also changed the applications registry key to point to the new database.

Now the interesting things to note are that when i re-create the odbc to the old server and database (sql 2000) by batch file†it works fine. The new ODBC is linking to a sql 2005 database, but it is still using the 2000 drivers and†when i manually created it, it worked also.

Another interesting thing is that if i go into the odbc dsn and click configure, go through and test the connection it works fine... after i close this i then retry the application and it opens correctly...

I need this to be automated†with no manual intervention, as this will be added to a large group of users login scripts!

Any help greatly appreciated.

My batch file code is as below:

ODBCCONF.exe CONFIGSYSDSN "SQL Server" "DSN=RMS Live 2005 | SERVER=d-db99sql2005| Trusted_Connection=Yes | Database=RMS-Livedb"

View Replies !   View Related
Configuring The Connection (DataSource) Dynamically


Hi All,
I need to write a report which will run based on the user's input for Server Group. Meaning, if the user wants the report to be run for one say, UAT group, the report (and therefore the stored procedure) should be executed against UAT server. Or, if the user wants it to be run on the Production machine, the stored procedure should be executed on the Production Server. Assume that both UAT and Production servers are in the same domain to rule out any authentication issue.

I think one way of doing it is to create a linked server on one server which we use to connect via the Report Manager. So, whatever Server Group is selected based on that the SP will be executed on that respective Server Group's Server, since in the query we will have given full names of the tables that we use.

But, I strongly suspect, that having linked servers will not be accepted since it requires that the server owners maintain that. So, I was thinking if there is any other way of achieving this. If anyone knows, please help me with this.

Thanks a lot and let me know if the question is not clearly stated.

Manoj.

View Replies !   View Related
Trouble Using ADOX To Create Linked Tables In Jet Database From An ODBC Datasource
Hai,

I am using ADOX to create linked tables in a jet database from an ODBC datasource.
The tables in the ODBC data source does not have a primary key.
so I am only able to create read only linked tables.But I want to update the records also.
I tried adding a primary key column to the linked table while creating the link.
but I am getting an error while adding the table to the catalog.

The error message is "Invalid Argument".

I use the following code for creating the linked table

Sub CreateLinkedTable(ByVal strTargetDB As String, ByVal strProviderString As String, ByVal strSourceTbl As String, ByVal strLinkTblName As String)

††††††††††† Dim catDB As ADOX.Catalog
††††††††††† Dim tblLink As ADOX._Table

††††††††††† Dim ADOConnection As New ADODB.Connection

††††††††††† ADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strTargetDB & ";User Id=admin;Password=;")

††††††††††† catDB = New ADOX.Catalog

††††††††††† catDB.ActiveConnection = ADOConnection

††††††††††† tblLink = New ADOX.Table

††††††††††† With tblLink

††††††††††††††† ' Name the new Table and set its ParentCatalog property
††††††††††††††† ' to the open Catalog to allow access to the Properties
††††††††††††††† ' collection.
††††††††††††††† .Name = strLinkTblName
††††††††††††††† .ParentCatalog = catDB

††††††††††††††† ' Set the properties to create the link.
††††††††††††††† Dim adoxPro As ADOX.Property

††††††††††††††† adoxPro = .Properties("Jet OLEDB:Create Link")
††††††††††††††† adoxPro.Value = True

††††††††††††††† adoxPro = .Properties("Jet OLEDB:Link Provider String")
††††††††††††††† adoxPro.Value = strProviderString

††††††††††††††† adoxPro = .Properties("Jet OLEDB:Remote Table Name")
††††††††††††††† adoxPro.Value = strSourceTbl


††††††††††† End With

†††††††††† 'Adding primary key,
††††††† †† '***** the source column name is "Code" ******
††††††††††† tblLink.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "Code")

††††††††††† 'Append the table to the Tables collection.
††††††††††† '******The exception occurs on the following line***********
††††††††††† catDB.Tables.Append(tblLink)

††††††††††† 'Append the primary index to table.
††††††††††† catDB = Nothing

††††††† End Sub

If† I avoid the line for adding the primary key,everything works fine,but the table ctreated is readonly.

Thanks in advance
Sudeep T S

View Replies !   View Related
How To Use A Stored Procedure With Parameters To Create The Datasource View For Report Model Builder
I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?

View Replies !   View Related
DTS - Updating DataSource Connection Via ActiveX Script Task
Hi,

I've written a DTS Package to pull information from a number of servers. I have a list of servers (Source Servers) and for each one I automatically update the Datasource property of the Source Server connection using vbscript in an ActiveX Script task and a global variable.

I have a transformation that occurs between the Source server and Target server.

As I process each Source Server in turn, the global variable gets set correctly and so does the Datasource property of the Source Server connection. However the transformation still runs against the first Source Server that was processed.

Looking at BOL it appears that a transformation stays connected even after it has finished. Therefore I assume that although I change the Datasource of the connection to a new server, it still runs against the first server that was used.

My question is how do I get the connection to run against the updated Datasource, i.e. do I need to do a refresh of the Connection, disconnect or what ?

Any ideas would be much appreciated.

thanks

View Replies !   View Related
New SSRS Install, Works Great Until I Try To Access Oracle Datasource - System.Data.OracleClient Requires Oracle Client Software
re: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software

From my desktop the report accessing an Oracle 9i db with no problem.
I've deployed other reports accesing sql server with no problem.
Now I deploy the report and try to access my Oracle source and get:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
On the server in question, I know they've installed the oracle client. I can access the db from sql plus with no problem.
As the user that I access ssrs credentials, i remote login and am able to write to oracle home.. C:oracleora10gNETWORKADMIN
i've confirmed my database is in tnsnames and it works from sqlplus.



View Replies !   View Related
Turning Off Impersonation On A SQL Server Datasource, Connecting To Datasource Using Reporting Services Credentials


Dear SQL Server Reporting Services Support Guru,

How do we configure Reporting Services such that when it attempts to connect to a datasource (e.g. Microsoft SQL Server datasource), it connects as the service account under which it is running as opposed to the calling user?

From our research we were thinking we could try one of two things:†


1) change the credential type on the datasource itself so that it does not use Windows Integrated Security and instead connects as itself or

2) change the <identity impersonate="true"> flag in the web.config of the ReportServer web service to false.

A high level description of our architecture is that we have a client application with an web browser control that displays a report†in the ReportViewer web control on the server.† The report uses a SQL Server datasource to connect to our own SQL Server database hosted on the same server as Reporting Services but we want it to turn off impersonation and have Reporting Services†connect as itself, not as the calling user.† We do not want to grant users in Production direct access to our SQL Server database; so instead we wanted to configure†Reporting Services such that it†resolves and connects to the datasource using its own credentials.†

A related question...when does the ReportServer web service get called?† For both retrieval of the .rdl files and connecting to the datasource for dataset retrieval?† What exactly does that <identity impersonate="true"> flag affect?

Any help you can provide would be very much appreciated.

Thanks much!

-canuck81

View Replies !   View Related
How To Create Dashboard Reports Using SSRS?
Hi Folks,

† I have SSRS and Asp.net2.0. i have been asked to create the dashboard reports for our organization. please give me some tips, how to develop the dashboard reports using this technology?

†† Is there anyother resources avilable to develop this dashboard reports? thanks in advance..


Thanks,
Senthil

View Replies !   View Related
Does SSRS Have To Create Its Own Database? Or Can It Use An Existing Empty One?
Hello everyone,


Greetings! I just found this group after wasting hours trying to make
SSRS work with databases that are already created (that is, the DBA
created two empty databases for me, X and XTempDB).



I keep getting "this connection string is invalid can't use this to
connect to SQL Server" in the Database Setup tab.



The problem is that to create its own database, SSRS needs dbcreator
and securityadmin roles (please correct me if I'm wrong here). And I'm
having a helluva problem trying to convince the DBA to give me
temporary dbcreator and securityadmin roles!

Is there any document or
something that I can use to convince him that SSRS will not do
anything like recreating the login (because he said that the login has
already existed and has its role set up in many other databases)?


Any help, pointers, suggestions, etc. is very much appreciated.



Thanks,
Ray

View Replies !   View Related
How To Create A Report In SSRS From Local XML File
Hi

i need to create a Report from XML file which available in my current folder.

can anybody suggest How to create a Data source from XML file and How to make a† query for that.



Thanks

Mahesh



View Replies !   View Related
Is It Possible To Create A Cover Page In SSRS 2005?
Very simply, I need to add a cover page to my SSRS 2005 report. I've tried this using the Page Header region, but the cover page will not show up on Preview or Export. How and where†do I create a cover page?

View Replies !   View Related
Is It Possible To Dynamically Create Columns In A Table In SSRS


Hi,
††† I have a sproc that returns somevalues and everything is working fine... and in my reports i am assigning †the†header data††(in a detail column) based on the some feilds in the sproc...† and there around 20 feilds that i want to show... but at a given time i am pretty sure that there wont be more than 10 fields that will have data.

So is it possible that show only the columns that have data in† it and sometimes if there is less that 5 - 6 fields.. i want to realign the widths in those tables..

any help is appreciated..
Regards
Karen




View Replies !   View Related
Sql2005,SSRS How Create Dataset From 2 Datasources
I can add more datasources and† how can i frame my query based on the tables present in the various datasources?

View Replies !   View Related
Sql Datasource Insert Error
hii,,i am using asp.net 2005 and sql server 2005...
i m using sql data source in my form,,i want to insert the details into a table using the insert command thr sqldatasource....one of the column name is service_w/lb, this is where i get an error.i am not able to insert the new data..here is my code::::
______________________________________
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sm123_trackerConnectionString %>"SelectCommand="SELECT * FROM [Agency_Master]"
InsertCommand="INSERT INTO [Agency_Master] ([Agency_Id], [Agency_Main_Contact], [Agency_Invoice_Contact], [Address], [Email_Address], [Phone], [Mobile], [Fax], [TimeZone_Id], [Agency_Name], [Service_w/LB], [Notes], [Technology_Used], [Status with LB]) VALUES (@Agency_Id, @Agency_Main_Contact, @Agency_Invoice_Contact, @Address, @Email_Address, @Phone, @Mobile, @Fax, @TimeZone_Id, @Agency_Name, @Service_w/LB, @Notes, @Technology_Used, @Status_with_LB)"
OldValuesParameterFormatString="original_{0}"
>
_____________________________________
even if i put it as @[service_w/Lb] i get an error....here is the error i get
__________________________________________
Incorrect syntax near 'nvarchar'.The name "Service_w" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.____________________
pls reply as soon as possible ,,,thnks in advance

View Replies !   View Related
DataSource Reader Error ...
I have a SSIS package that pulls fact data from Progress 10.1B database. Midway through the pull (around 10,000 records), it bombs out with the following error. I have'nt a clue as to what it means. Could someone help me out? Thanks in advance.



[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.† The PrimeOutput method on component "DataReader Source" (1) returned error code 0xC02090F5.† The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.† There may be error messages posted before this with more information about the failure.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED.† Thread "SourceThread0" has exited with error code 0xC0047038.† There may be error messages posted before this with more information on why the thread has exited.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADCANCELLED.† Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.† There may be error messages posted before this with more information on why the thread was cancelled.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED.† Thread "WorkThread0" has exited with error code 0xC0047039.† There may be error messages posted before this with more information on why the thread has exited.

[DTS.Pipeline] Information: Post Execute phase is beginning.

View Replies !   View Related
Error Reading DataSource ...
While pulling data from a progress 10.1B Database, we get the following error (datasource). How do we go about redirectign the erroneous row into a flat file / database so that we can isolate the issue?
†[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.† The PrimeOutput method on component "DataReader Source" (1) returned error code 0xC02090F5.† The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.† There may be error messages posted before this with more information about the failure.

View Replies !   View Related
SSRS Connection Issue
Hi all,

When I use the Microsoft SQL Server Management Studio to connect the Reporting Services, I hit the below message. I have checked the SQL Server Configuration Manager and the service is running. Anyone can help me to resolve this issue in my server?

Regards,
Farouk Yew Abdullah






===================================

Cannot connect to MARS.

===================================

The request failed with HTTP status 400: Bad Request. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------
Program Location:

†† at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
†† at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
†† at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
†† at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
†† at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
†† at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
†† at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
†† at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
†† at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

View Replies !   View Related
SSRS Oracle Connection
Hi,



We are trying to change our current SSRS reports to point to an Oracle 10g database.† I can connect to the Oracle db from the report server via the ODBC Administrator and also through the BI 2005 studio.† The connections work fine.† However, when I publish the reports and try to run them from the web I always get a connection error.† When I use the oracle connection it acts as if it doesn't see the oracle client and when I use ODBC it throws a werid 114 error.



Is there anything I am missing? I just don't understand why the report will work in BI Studio, but not when it is published (on the same machine)?



Any thoughts?



S

View Replies !   View Related
SSRS Connection Problem
Hello Friends

Here's now an old (un)solved problem for me...

We've been working with SQL Server 2005 Express Edition.
We're using BIDS for Report Development and Deployment.

Whenever we try deploying the report, we get the following message...

"a connection could not be made to the report server"...comes up.

Environment:
WinXP, IIS 5.1, Norton Internet Security
Report Server and Report Manager website (virtual directaory) listing in-place

Following we're the action taken...
We tried changing the reference URL to absolute path in "RSWebApplication.config"...
After this, the system started throwing "HTTP 403 Forbidden error"...

We tried accessing the default pages in http://localhost/reports$sqlserver...
Result: "Unable to connect to the remote server"...The browser link actually reads...'http://localhost/reports$sqlexpress/Pages/Folder.aspx'

Accessing the http://localhost/reportserver$sqlexpress...returns "HTTP 403 Forbidden, The website declined to show this website" Most likely causes: This website requires you to login...
Now, how to login? From where?

After much reading we found out that all this seems to be something to do with "User Credentials"...We're using Windows Authentication...

Some suggest inclusion of certain code in "reference.cs" file...where's this file located?

Also, is Norton Internet Security blocking the access?
We tried after disabling the Internet Security and Anti Virus...
And the results are same as above...

Any help in solving the problem will be highly appreciated...
Thanks,
Sara

View Replies !   View Related
Error Trapping Of Datasource Control
Hello,
I encountered an interesting situation. I have a gridview and a sqldatasource. It has delete function. When I delete a record an error of foreign key violation is raised. I would like to trap this error and give a user friendly message to the user.
If I use ADO.Net I can use Try/Catch, but it seems there is no way to do the same thing using datasource. Anyone knows?
Thank you,
J

View Replies !   View Related
How Create Multiple Driildowns For All Columns In Table Using Ssrs Report


hai, iam new to ssrs please help me,

†my report having† 10 columns, i can explain my need with example that is,††assume like this††customer id† is first column of my table customer id is 101 it †having 3 departments a1,b1,c1,perticular department that is a1 having emp1,b1 having emp2,c1 having emp 3.††††††††††††††

i want output like this when clicking + customer id driildwon it display† 3 departments taht is a1,b1,c1, when +a1 drill down clicking i need to dispaly emp1, corresponding b1 to emp2 , c1 to emp 3.

above explanation is only one column of the table, like that iam also displaying this† driiling procedure for remaining different columns.

and i need to display customer information by weekly,daily,monthly,yearly at bottom of the report


please give which logic used in creating†format like above†drilldown report which having multiple drilldowns for all columns in a table


if† any body give procedure for creating fromat for† drilldown report which having multiple drilldowns for all columns in a table† is appriciate.


thanks


jacks



View Replies !   View Related
How Can You View The Connection String Of An Existing Datasource? How Do You Delete Existing Dataset?
I went to look at the connection string previously entered for a dataset created in a new report, and am not seeing anything intuitive for bringing up the associated datasource dialog box that was used to enter name, type and connection string.† I'm also noticing nothing intuitive for deleting an existing dataset.† How do you do these two very simple things in an existing project?† I dont see the dataset in solution explorer,†I see it only in the text box on the data tab and†in a limited kind of way on the dataset view where the columns show and maint is allowed mostly on the columns only.† I tried hilighting the dataset here and hitting the delete key to no avail.††

View Replies !   View Related
ErrorColumn Field From Datasource Error Output
Hi,

The problem is, ErrorColumn contains ID.† Is the following code reference safe ?
columnname =† Me.ComponentMetaData.InputCollection.FindObjectByID(Row.ErrorColumn).Name


Is there any possibility for FindObjectByID to return NULL Reference in any case ?

View Replies !   View Related
Error Deploying Report With DataSource SSIS


Hello Everyone,

I make a report to consume a SSIS package, actually I use SSIS to load a datasheet on my Sql Server database, then i expose the aggregate values in a datareader destination. Every work fine in Visual Studio.† But when i deploy my report and my Shared Data Source,† and I try to run the report i get the next message:

An error has occurred during report processing.

No se puede crear una conexión al origen de datos 'ETLSource'.

The package failed to validate.
†I dont Understand why, because when i work in BIDS the work perfect,† Actually i'm using sql server authentication in my package connection to avoid the mistakes about report credentials.

That is the code of the ETLSource.
<?xml version="1.0" encoding="utf-8"?>
<RptDataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
† <Name>ETLSource</Name>
† <DataSourceID>c238d65d-a0f3-48da-ae23-323d6ba13bb0</DataSourceID>
† <ConnectionProperties>
††† <Extension>SSIS</Extension>
††† <ConnectString>-f "C:TempValidaCambioEfec.dtsx"</ConnectString>
† </ConnectionProperties>
</RptDataSource>

Also I have SSIS and SSRS in the same machine.† And I'm using the same domain Account to run SSIS, SSRS and Reports site.


Thank you for help me


Julian Castiblanco P
Bogot√°, Colombia


View Replies !   View Related
Error Creating Report Model Using A DB2 Datasource
I'm receiving the following message after I've created a datasource and datasource view:



[DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601.



View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved