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 How To Take Data From Two Different Databases


hi,
 
1. I am new to SSRS. I want to show the data from two different databases in a single report. That databases may be in different machines also. Can you please suggest me how to do.
 
2. How to use the configurable connection string in reports. bcoz i'll have reporting service in one machine and database in another machine. At the time i want to read from config file. If database changing mean i need to reconfigure connection string. how to do.
 
Thanks.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Using Two Databases With SSRS 2005
Hi,
 

I want to use two databases for my reporting services 2005. I want to connect to one database and check whether the logged in user is a portal admin using portalid and userid.If yes, then I will allow the user to user use all the stores. Stores are displayed in the drop down list as the multiselect parameter. If no, then I will connect to another database and check the user rights. Based on the user rights I will select only the stores that are applicable the user.  i don't know how to use two databases in the reporting services. Please give me an idea to do this.
 

 Thanks,

Muniappan Kandasamy
 

View Replies !   View Related
Taking Data From A Different Databases/Data Warehouses Using A Sequel Server 2005 Based Database.
 

I'm in the middle of developing a Database for a hospital that measures its audits, inhouse operations, and finance.  What we currently have and do everyday is collect data from a large database that is real time with patient data, progess, infomation, etc and dump it into a data warehouse that runs on TSI/Eclipsys.  We run reports using a number of  programs and dump it into Excel sheets that have charts, reports, etc.  This Database for which I'm developing won't come soley from the TSI/Eclypsys source, but this is the only source thats updated regularly.  I don't want to have in sync with TSI/Eclipysys in fear that every day when it updates data may be lost, not read, or worse won't be up date if there is a problem.  My question is is it possible to run a query from Sequel Server 2005 that will take that data upon request using the reporing features on Sequel Server 2005.  i.e. What if I need to run a report on measure B in department 12 from Jan 1-Feb 1, instead of being in sync, can I just write queries to take that information rather than double the data and take up twice the space and trouble.  FYI, these datatypes rarely change in the TSI/Eclipsys data warehouse.  This sure was long question and didn't intended it to be .  Thanks for listening and hope to hear back.
 
 
Stephen

View Replies !   View Related
SSRS Data Tab
 

Hi All,
I am getting a problem...
I have devloped a BI Solution in VPC.
In which I have created a SSRS soltution and few reports.
Now i have some reports level changes ie some changes i have to do in SSRS MDX Querys.
But when i open a report and from layout when i click on Data tab of SSRS report  all my old qureys vanish and just like a blank design enviorment open.
 
do any one know the reason as well solution of this problem  
Its urgent

View Replies !   View Related
Reg: Data WareHouse And SSRS
 

Hi,
 
Can any one give some good articles and webcast links for Developing SSRS reports with Data WareHouse.
 
 
Regards
Sithender

View Replies !   View Related
SSRS Footer With Data
I'm writing a report that will have data for mulitple accounts btoken up by page breaks(on account)

The user would like to see the name of the account in the footer. Since the entire report will consist of many accounts using first or last in the footer element is not an option.

Does anyone know of a way to get the account that is displayed in the body of the page to display in the footer?

Thanks

View Replies !   View Related
SSRS Using Xml Data And Array Properties: Is It Possible?
i'm using a vanilla XmlSerializer to write out a class structure to xml.
 
the class contains an array property something like this:
 
[Serializable]
class MyClass
{
 private long id;
 public long Id
 {
  get { return id; }
  set { id = value; }
 }
 private decimal[] monthValues = new decimal[12];
 public decimal[] MonthValues
 {

  get { return monthValues; }
  set { monthValues = value; }
 }
}

 
writing this out to xml gives a bizarre but consistent structure:
 
<?xml...?>
<DataTables>
 <MyClass ...>
  <Id>1</Id>
  <MonthValues>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
  </MonthValues>
 </MyClass...>
 <MyClass ...>
  <Id>2</Id>
  <MonthValues>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
   <decimal>0</decimal>
  </MonthValues>
 </MyClass...>
</DataTables>
 
reading this into SSRS gives not the two rows with an indexed property i was expecting, but twenty four rows with each decimal value in a separate row.

 
is this something i just have to live with? how do i make SSRS see this as two objects?

View Replies !   View Related
XML Data Source Within An SSRS Sub-report
 
This is a question regarding the use of an XML data source within an SSRS sub-report.  This is a two server configuration consisting of SSRS 2K5 and a separate file server exposing xml files over http, IIS 5. 
 
Is it possible, and if yes how, to configure the xml data source to use the application pool identity instead of the current caller identity?  I can not turn off impersonation within SSRS.  I need to revert to use the W3WC, app pool, process identity within the xml data source.  I do not want to configure Kerberos delegation and the file server€™s IIS virtual directory must be set for windows security.

View Replies !   View Related
Best SSRS Data Source: SQL Or SSAS?
I have a vision of a beautifully interlocked Business Intelligence system in which I load dimensional fact tables through SSIS, build aggregations in SSAS cubes, and quickly and easily generate SSRS reports using the cubes as data marts.

 

I am now a month into trying to implement this vision and Reality is stomping all over it.  Primarily, I am running into issues with the "cube as a data mart" idea.  Each cube is taking up an additional gig or two of space, report queries against them seem to take longer than a straight SQL query against my fact tables, and I am running into serious problems trying to pass time-related calculations such as Year-To-Date to my reports.

 

Has anyone else tried setting up a BI system that uses cubes as the primary drivers for their reports?  Have you seen any benefits to doing it that way?  Or should I generate most of my reports through the SQL tables?

 

I'm nearing the point-of-no-return in choosing my final methodology, and any feedback would be greatly appreciated. 

 

Thanks!

 

-- Steve

View Replies !   View Related
Data From Two Databases
Hi All,
We currently got two databases in the application(Visual web express with vb script). The one database is a sql 2000 that sits on a server and is fed by people that does E Learning. The app. got its own database(SQL 2005 express) with the record of the people doing the learning and some other attendances from other courses. I would like to determine attendances from both databases etc. How do I link this to table form diffrent databases into one table for me to do training cost etc.
Thanks for your help.

View Replies !   View Related
SSRS 2000 Data Not Refreshing In Report
Good day,

I have a SSRS 2000 report that when I view the report data does not refresh until I press the refresh data button in the report. Clearly this can't be right and to expect users to press the refresh button every single time is also rediculous.

HAs anyone had this problem before and know what to do.

Please help.

Thanks

View Replies !   View Related
SSRS 2000 Not Displaying Latest Data
Good day,

My report links to a SQL server and is not showing the latest information. If I open it now and look at the report, close it and open it again ina few hours it will show the same report as I looked at originally. When I push the reports refresh button then the data refreshes and shows all the information.

The execution for the report is already set to: Do not cache temporary copies of this report

Why does this happen? I have about 40 reports that work perfectly but this one is giving me problems, any one got any ideas for me? Please help.

Thanks

View Replies !   View Related
Problem Using Oracle Data Source From SSRS
Hi,
I'm new to SSRS but have a problem connecting to Oracle. I have placed my reports upon a reporting server but the shared data connection isn't working and I'm confused as to why. I have specified the name, connection type as "Oracle", set the correct user id and password for the credentials and the connection string as for example 'Data Source=oracleExample;Unicode="True"'. I also have set the correct entry in the tnsnames.ora file for this datasource, example:
"oracleExample =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 12.23.45.23)(PORT = 3425))
)
(CONNECT_DATA =
(SID = oracle)
)
)"
Unfortunately I receive the following error when trying to connect.
"
An error has occurred during report processing.
Cannot create a connection to data source 'oracleDataSource'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
"
I'm mystified as to what the issue is. Any ideas? Would restarting the report server pick up the tnsnames.ora file? I have this working locally using report designer.
Any help, much appreciated.

View Replies !   View Related
InfoPath Form's Data To SQL / SSRS Database
Hi
 
In my current project we are dealing with a lot if Infopath forms of all sizes and complexities. currently they are being saved in Forms library of sharepoint.
We need to build a warehouse for SSRS which receives data either from content database or from infopath forms submit with minimum latency.
I thought of few alternatives, but, not sure which is most robust and economical.
1. Built c# classes to parse XML of infopath forms and then push data to SQL using ADO.net and SQL stored procedure while item is being added (ItemAdding) to Forms Library.
2. Use CAML queries to extract XML from forms library and then continue with C#/ADO/SQL..
3. Use SSIS APIs and webservices to massage XML and put it to SQL at ItemAdding event
4. Use CAML queries to generate XML files and stage it to FTP and rest will be done on SSIS.
 
I am currently looking for feseability information based of Besy Known Practise.  Please feel free to suggest a totally new approach, if available.

Thanks

View Replies !   View Related
Setting SSRS Data Source Via Script
Is there a command that can be used to set the account and password of an SSRS data source? I want to use a datasource that uses the option "(windows) credentials stored securely in the report server". The password for the account to be used can not be known by any humans (or we have to kill them after) so we want to set it programmatically. Is this possible via a command?

View Replies !   View Related
SAPParameter -- Configuring SSRS To Use .NET Data Provider For SAP
In the MSDN white paper "Microsoft .NET Data Provider for mySAP Business Suite", on page 2, it shows an example of calling a RFC with a variable.  Specifically, it states "To execute this statement, you must create a SAPParameter object with the name @var1, specify its value, and add the new object to the SAPCommand object corresponding to the query."  How do I create a SAPParameter object?

Brent-GPTX

View Replies !   View Related
Data Validation For Datetime Parameter In SSRS
 

Hi,
 
I wanted to know more about validation of SSRS parameters. I have a simple report which has a parameter called startdate of DateTime datatype. The datetime parameter in SSRS takes manual input as well. So, the user can enter any junk value. I want to ensure that the input parameter is in correct format and I want to display an error msg when the format is incorrect. My report has the following VB code for validation:
 
Public Function Validate( ByVal startdate As String) As Boolean
If IsDate(startdate) = True Then
Return True
Else
Return False
End If
End Function
 
And my report has a textbox which has the expression property set to;

=Code.Validate(Parameters!startdate.Value)
the textbox on the report has to display if the entered date is valid or not.
 
But, when i enter an erroneous date, SSRS doesn't render the report and throws a generic error. This happens even before the code written for validating the parameter executes.
 
Also couldn't find a way to disable the manual input for the datetime parameter. Even that would solve the problem.
 
Another alternative was to make the startdate parameter as string, but i want the calendar control button to be provided for the user.

View Replies !   View Related
SSRS &&amp; SSAS 2005 Data Parameter
 

Hi all,
 
I'm sure what I am trying to do is very simple - but I just can't seem to figure it out. I have a report based on a SSAS cube (SQL 2005). The report shows sales based on the dates the user selects from the parameter field (the date parameter field comes from a Y-Q-M-D hierarchy). This all works fine.
 
What I would like to happen is for the members within the last 3 months to be automatically selected so that the report automatically executes for the last 3 months.
 
Can anyone help or offer any advice. If possible I would like to achieve this using the GUI features so that power users can use the "plug and pray interface".
 
Many thanks
 
Matt
 
 

View Replies !   View Related
Add To SSRS Data Extension With Config File
Hello,

 

I try to add an data extension who take the information to connect to the database in a config file. But It's could not retreive the values corresponding to the key. 

I'm using the class ConfigurationManager from the namespace System.Configuration.

 

ConfigurationManager.AppSettings["QueryModel"]

 

 

Without the config file, the extension is working well.... I got the impression that reporting service and Visual Studio BI don't find the config file.

 

If someone can help me or have some advices. I will be pleased

 

 

View Replies !   View Related
Use An SSRS Report As An SSIS Data Source
See above...
 
Apologies for the duplicate post!

View Replies !   View Related
How To Use The Sum To Add Specific Data From The Table In Ssrs 2000?
Hi All,

I am new to this forum and had checked this forum for this problem that I am having. Although there were a lot of informative articles that I found useful, I still couldn't resolve this problem.

I am having a little trouble trying to use the Sum function to get the totals that I need for a project that I am trying to accomplish. The scenario is below:-

This is the report image that I want to produce.

Region1                                    policy1                            policy2
    AgentType1                            Total                               Total
    Agenttype2                             Total                               Total
    AgentType3                            Total                               Total
                                             Region1's policy1 Total    Region1 Policy2 Total


Region2                                    policy1                            policy2
    AgentType1                            Total                               Total
    Agenttype2                             Total                               Total
    AgentType3                            Total                               Total
                                             Region2's policy1 Total    Region2 Policy2 Total

(this is where i am having the problem)
AgentTotals
 AllAgentType1Totals             Policy1Totals              Policy2Totals
 AllAgentType2Totals             Policy1Totals              Policy2Totals

TotalforallRegions      RegionsTotals

I managed to get all the information I needed in the
Report except for Agent Totals. I am having a little
bit of a logic problem on how to get the totals for a
particular agent type with each policy.

Right now my layout only has ONE grouping which holds
the region types. my dataset basically is how the
report is going to look like without the totals.

Is there an expression I can use that would identify
what type of agent that is and then add the total ?

kinda like the following:-

=IIF(agenttype = "AgentType1", Sum(all agent totals
for policy 1), "")

Am I heading in the right direction ?

Any tips or hints would be greatly appreciated.

Sincerely,
Bernard Ong 

View Replies !   View Related
SSRS 2005 And XML Document As Data Source
I'm new to SSRS 2005, and having a very hard time getting something I thought would be trivial to work. It would appear that if you want to report from XML data, there are a variety of ways to do so.

I would just like to use a simple document that was created by serializing to disk. I don't even have a fancy query. Can someone help me with an start-to-end from which I can build upon and add complexity? Thanks.

C:XmlDataCustomers.xml contains a single Customers table; 3 Customer rows with an ID, FirstName, LastName. (I'll try pasting it as a follow-up).

My DataSource type is 'XML' and the ConnectionString is the simplest of URLs "C:XmlDataCustomers.xml". Credentials are set to 'none'. My suspision is that I am not even succeding at creating a valid DataSource. I don't know if it has to do with the XML, the location of the file, the syntax of the ConnectionString or what.

Assuming I get this right, I want all rows and all columns, so I assumed an empty query on the DataSet would be appropriate.

I've found a bunch of examples - but none seam to be this trivial - they all involve using a web service, embedded data in the query, or creating a Customer Data Extension (CDE) to provide the document. I've tried converting these samples to use my DataSource, but so far no luck.

Your assistance is appreciated.

View Replies !   View Related
Using SSRS With An ODBC Data Source (Oracle RDB)
I'm attempting to use SSRS (2005) with my Oracle RDB database (old DEC RDB), using an ODBC driver. I am able to create a report, and view data, but I need to add some report parameters to filter the data.  When I attempt to use parameters in the query, I either get a syntax error, or a message that my odbc connection cannot use "named" parameters, and that I should use "unnamed" parameters.

Here is a snippet of my sql query:

SELECT Application_Notes.Lease_Application, Application_Notes.Followup_Code,

<...>
FROM
    Application_Notes Join

<...>
WHERE
    (Application_Notes.Tickler_date >= {ts '2008-02-08 00:00:00'}    AND

     Application_Notes.Tickler_Date <  {ts '2008-02-09 00:00:00'} )


The "Tickler_Date" field is a binary date field. The above syntax is pulled from a Crystal Report, which I am considering moving over to SSRS. Ideally, I would like the user to enter a single RunDate parameter, and have the query do the following:

Where (Application_Notes.Tickler_Date >= @RunDate and
 Application_Notes.Tickler_Date < (@RunDate + 1 day) )


If the user has to enter two dates, that will be fine, but I can't seem to get past the errors.


Thanks,


Paul

View Replies !   View Related
SSRS 2000 Not Displaying Latest Data
 

Good day,
 
My report links to a SQL server and is not showing the latest information. If I open it now and look at the report, close it and open it again ina few hours it will show the same report as I looked at originally. When I push the reports refresh button then the data refreshes and shows all the information.
 
Why does this happen? I have about 40 reports that work perfectly but this one is giving me problems, any one got any ideas for me? Please help.

View Replies !   View Related
No XML Data Sources Support In SSRS 2008?
 

When trying to use the report editor in VS 2008, I noticed that there is no longer an option to use an XML data source (either a file-based or URL-based source).  This is a major omission given that so many services nowadays are exposed via REST-style interfaces.
 
Please advise if I'm missing something!  I'm using the February CTP.
 
Thanks,
 
Rick
 

View Replies !   View Related
Wrong Data In SSRS 2005 Dataset
I built a profile management application that feeds dimension tables in data warehouses.

 

Recently an annoying operation issues has been brought up and points to the wrong data appeared in SSRS 2005 dataset.

 

As it displayed in the screen shot (of a fraction of SSRS 2005 report embedded in a Web page), the highlighted number is a piece of data that should not appear in the underlying dataset:
 

 
When user hit the Edit button above, the correct data is retrieved by a Typed DataSet method:
 

 
To validate my suspicion, I copied the SSRS dataset query and run it in SQL Server Management Studio.
 
The result line is correct when query run in SQL Server Management Studio. However, the same result line is wrong like it displayed in the SSRS dataset designer.
 
The query involves 3 Union processes that may cause the problem. I€™ll try move the query text into a stored procedure and see if the work around fly.
 
For some reason the screen shot does not get posted in the editor but I think it should not matter.
 
Hopefully this post will get some heads up and probably some enhancement on next release.

 
KC

View Replies !   View Related
ODP.Net Vs. Microsoft Oracle Data Provider In SSRS
 

Which one is better to use?  Is there a significant difference between the two?
 
Does someone have the directions to add ODP.Net to my database connections list in SSRS?
 
Thanks

View Replies !   View Related
Move Data Between Databases
hi, I currently uses SQL Server 2005.I need to move the data to my website, how do I do that? I have the SQL Server Management Studio Express but I couldn't not get it to export the data in .sql file (which is needed to import to my website's SQL database).Please let me know of any tools I need to perform the task. thanks. 

View Replies !   View Related
Moving Data Between Databases
I have a web app that has been regulated to a disconnected PC. It's runing IIS and 2.0 with sql server express, but no connectivity. I have changes that are made to some of the data in the db (data, bot schema). There is one particular table that I cannot overwrite, and must extract the data.
What methods are available to do this swap of data between databases? I was thinking of doing something like this:
Track last date that remote db was updated. Upload updated database into data directory, loop through records for all affected tables, any date that was past logged date then update the record if it exists or insert new record, and then loop through the remote db and delete this records that dont exist in the updated db.
This seems intensive and slow - especially as the tables get bigger but I can't think of another solution that can be done by a user using sometime of web interface.

View Replies !   View Related
Update Data Among Databases
Hi,

I develop ASP.NET applications and use MS SQL 2000 Enterprise.

Each customer has one database and one custom design application. And, there is a gateway and a central database to get data from all databases.

Supposed there are 10 DBs. I want the data in those 10 databases updating to the central database directly.
So, the gateway can gather all data of 10 DBs from a central DB.

Now, my question is how should I do it in MS SQL 2000? Can I do it with a stored procedure (SP)? If so, how does the SP like?

Or, SP can only perform on it's own DB, but not execute across DBs? If so, how can I do that?

Thanks for advice

View Replies !   View Related
Is It Possible To Grab Data From 2 Different Databases
Hello-

I have a chart I am producing in .net and I need to values. The problem is the values (sums) i need are on 2 different servers. Is there any where to combine the query using two databases? Does anyone have any suggestions?


thanks

View Replies !   View Related
How To Copy Data Across Databases
I am trying to copy information from one Database to another. Each of the databases reside on a different server.

My question is
1. How can I use the DSN name in a stored procedure?
2. Do I need to use dynamic SQL?
3. Any other ideas of how to implement this?

Thanks

View Replies !   View Related
Consoldating Data Across Databases
Thanks in advance for your help,

Is there an easy way to "link" data from one SQL database to another, preferably within a view?

More specifically, can one "link" to data from 2 seperate databases to a 3rd without importing the data?

Thanks,
Lee

View Replies !   View Related
Missing Data In Databases
Dear all,

I faced a problem. I found all data/records of tables in a few databases were missing yesterday. I don't know what had happened. Can anyone tell me why? Can anyone tell me how to trace the root of the problem. Any log files I can trace? I fear it will happen again. My server is sql2000 and run on win server 2000.

Regards,
Simon

View Replies !   View Related
Copying Data Between Databases...
If I have to copy data from one database to a temporary database on the same server, which transaction log will be written to as a result? Will it be the DB that the command is run from, the source DB, or possibly tempdb's log?

Thanks

Derek

View Replies !   View Related
Comparing Data In Two Different Databases
Hi
Is there a way of comparing the data contained in two separate databases (on the same server)?

I have two databases: DevDB and DB and all I want to verify is that the data in both are *exactly* the same.

Is there a nifty function to do this in SQL Server?

Thanks
Sara

View Replies !   View Related
Comparing Data In Two Different Databases
Hi, I would like to know if it is possible to compare data in two different databases (both SQL7.0),
with same exact schema. If possible, how could we do it?

Thanks

- Sharma

View Replies !   View Related
Updating Data Across Databases
Not sure if this is the right place for this question, but will give it a try. I am using MS Server 2000

I need to run and update query that will pull information from a table in a database on server A and then update a different table in a database on server B.

I am running into some problems though.

The Query looks something like this


Code:

UPDATE Member
SET Member_Number = Member_Number
WHERE RTRIM(Member.FirstName) = RTRIM(Member.First_Name)
AND RTRIM(Member.LastName) = RTRIM(Member.Last_Name)
AND Member.Member_Number NOT IN
(SELECT RTRIM(Member.First_Name), RTRIM(Member.Last_Name), Member.member_Number
FROM Member
GROUP BY RTRIM(Member.First_Name), RTRIM(Member.Last_Name)
Having Count(*) > 1)



But when I try doing the import/Export data it gets mad by saying that FirstName and LastName are not columns

Any help is appreciated, even just a link to website talking about this!!

Thanks

View Replies !   View Related
How To Select Data From Different Databases
Hi I'm trying to select data from different databases, Actually databases have the same structure and tables but different data, so I want to mix data from specific tables of all databases.
Any help would be great

View Replies !   View Related
COPYING Data Between Databases.
Hi All,
I wish to copy between 2 tables in different databases.
( The source and destiantion tables already exist)
The source table has duplicate entries which i want to avoid from being copied to destination table.
How can i achieve this?

Thanks in advance..!!
Vishu

View Replies !   View Related
Merging Data From Two Databases
i have two databases one has
firstname, lastname
and the othere
firstname, lastname, emailaddress

how do i get to merge the data from emailaddress to the 1st datbase?

Melvin Felicien
IT Manager
DCG Properties Limited

View Replies !   View Related
Data Transfer Between Two Databases
I have two databases DB1 and DB2
With Tables T11,T12 and T21, T22 respectively.
All the tables in the two databases have the same structure.

I need help on a script to clear the contents of Table T21 and T22 in the DB2 database
And load the contents of Table T11 and T12 ( Table have about 2 Million records of data ) into T21 and T22.

View Replies !   View Related
SSRS Changing Expression Data Source Using A Parameter
Currently I am working on adding some redundancy to my reporting solution. In doing this I would like the reports to change instance or data source. The only way that I have found a way to do this is with a data source expression connection.

 

I have included a parameter in the data source connection string. This parameter allows me to control the data source at the time the report is ran.

 

This entire process works perfect until I deploy the report to server. With windows credentials in report designer the report runs and I am able to change the data source with the parameter. BUT with I deploy the report the data source can't make the connection. I have tried changing the credentials to full server admin username and password with no luck.

 

Does anyone have any suggestions on how to resolve this issue?

 

 

="Data Source="& Parameters!ServerName.Value &";Initial Catalog=BI"

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
SSRS :Generate Live Data Report (Example Stock)
 
Hello,
 
 
I have requirement to cache report server as soon as data get refreshed in datbase.My database get refreshed every 10 minutes.
I am working in stock and bond domain were data changes very frequently.My user want to see almost live data whenever accessing report in report manager.they also want to cache some data for better performance.Can any one tell me step's to improve performance of reporting services .
Kindly suggest me.
 
Thanks.
Monika Singh
 

View Replies !   View Related
SSRS Calling SSIS Package As A Data Source
Hi All,
 
It's been a while since I post here. Anyway, I'm trying to call a SSIS package as my data source for SQL reporting service but I keep getting the error "Cannot create a connection to data source 'DsSSIS'.
 
My DsSSIS consists of the following in the connection string.
 
="/file c:FarmBillTesting.dtsx /Set Package.Variables[User::FilterValue].Properties[Value];" & Parameters!FilterValue.Value.ToString()

 
I have tried everything that I know to make this work but I have been able to do so. Any help from the group would be great.
 
 
Thanks
 
Ham

View Replies !   View Related
How Can You Place A Data Bound Footer In SSRS On Every Page?
I am having another setback with a report which has got multiple tables and sections.
Here i wanted to have a footer for every page which is databound to a table. now since there are multiple
sections and multiple tables...the things have become more complicated. is there any way you could tell
me to go around this problem so that i can put a common footer on every page of the reports no matter how many pages
it goes on??

Just to put it in points... I need.. to

a) Place a databound footer(a footer that is bound to a datasource and not hard coded) into the page footer in SSRS.
No matter how long the report is in pages.
b) I need it to appear on every page of the report after it is rendered to a PDF.
I have placed a textbox in the body of the report and linked it to a textbox in the footer of the report.
Now the thing is it is not working.
Cud u please tell me diffrent ways or any possible way this could be done.?

Plz help..
Regards
Savio

View Replies !   View Related
Using SSRS 2005 With AS 2000 Cubes As A Data Source
Hi,
 
I'm am writing a report in SSRS 2005 on a local PC that uses cubes in AS 2000 on another server as a datasource. I am using the Microsoft SQL Server Analysis Services Extension (OLAP9) to connect to the cubes using windows authentication. I can save and preview the report in visual studio and publish the reports on IIS on my local PC with no problems but when I go to view the report in IE, I get the following error:
 

An error has occurred during report processing.
Query execution failed for data set 'dataset'.
Unable to recognize the requested property ID 'ReturnCellProperties'.
 


Have read various articles on the net with no conclusive explanation.



I have seen another post on this forum that suggests using OLEDB for Analysis Services instead but if I do this it doesn't allow me to use the MDX visual query designer. Creating the report using OLAP9 then changing to OLEDB and pasting in the query code doesn't work so well either.






 






I went and read http://technet.microsoft.com/en-us/library/ms159219.aspx about data sources supported by SSRS 2005 and it should be ok.






 






I am using sql server 2005 with the latest service pack 2.






Any ideas?

View Replies !   View Related
SSRS Missing/hidden Data Source Folder
I have inherited a SSRS setup and am trying to do some clean up.  Problem is I cannot see the Data Sources Folder.  I am setup as SA and SU on both the RS Server and SQL Server.  When I go check the catalog in SQL db it does truly exist as well as a number of data sources in the folder that reports are currently using.  How can I see this folder?

View Replies !   View Related
Whats The Best Way To Transfer Data Between 2 Databases
What is the best way to transfer data between 2 databases.
 
Any ideas will be appreciated.
Regards
Karen

View Replies !   View Related
Importing Data Duplicate Databases
I want to import data from a live site database into a development database (SQL Server 2005 Express) using the DTSWizard. Once I copy/paste the live database to my dev machine, I cant attach the live site database because it has the same name as the database on the dev site.A simple solution I would assume is to change one of the names.  But I can't seem to change the "orignal file name".  A backup/restore won't work for me because I made table/field changes to the dev database. Thanks --Dietrich

View Replies !   View Related
Exchange Data Between Databases On Two Servers??
Dear all
 
I have tow server on the same intranet. One server has a sql server 2000 database and the other one has SQL server 2005 databse.
 The sql 2000 database has a table called employee. When ever a new employee is inserted in the database i would like the same values to be sent to the sql 2005 database. But this cant be done on the application level. It has to be done in the database. The application level can not be changed.
I was thinking a trigger but how to achieve the writing from one database to another. If they were on the same server then it would be easier but because they are on different servers i dont know how to do it.
 Has anyone had similar issue before?
Any help is apreciated.
 
Sincerely
Dan

View Replies !   View Related

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