Hi swenri,
The Oracle client (OLE DB drivers etc.) will need to be installed and configured on the Report Server as well as your workstation. From what you say it sounds like you have the Oracle client correctly configured on your workstation, hence the reports run in VS, but not on the server...
Hi Andy,
No I don't think it is possible to show or hide parameters based on the values of other parameters.
An alternative option you might consider is to publish your report to a folder, hide it using security permissions, and present to the users two "linked reports" based on the hidden...
Could be to do with the package protection level then. Does the package contain any connections that require a password? You might need to change the protection level to "EncryptSensitiveWithPassword" and then add the password into the Agent job step command line.
You might also want to have a...
Have you tried opening the package using VS on a different computer? If that works then save it and copy it back to the first computer, and try opening it again - if it still doesn't open you might need to reinstall VS on that computer.
I'd also check what version of .Net Framework you've got...
Using SQL Server Management Studio, connect to the Integration Services instance where your package is deployed and expand the "Stored Packages > File System > " node.
Do you see your package listed there?
Sounds like your SQL Server Agent account might not have sufficient permissions to the...
Hi Diane,
How are you hiding the detail rows in Group 2? I think you would probably need to replicate the logic for this in the summary field in Group 1.
e.g. if your Group 2 detail row Hidden expression was something like
=Iif(Fields!Myfield.Value > 10, True, False)
Then your summary field...
Hi,
When installing SQL Express you can choose whether to install a default instance or a named instance.
from: http://msdn.microsoft.com/en-us/library/ms143722(SQL.90).aspx
Maybe you could create a report subscription and set the Report Delivered To: option to "Windows File Share".. this would effectively be the same as an auto export to a file? To set the file name I think you would need to use "Data Driven Subscriptions" which are only available in the Enterprise...
Hi mugs132,
Do you mean Excel 2003 or Excel 2007? There isn't an Excel 2008 as far as I know.
Excel 2003 has a limited colour palette (56 colours I think) and so if your SRSS 2005 report uses a colour not in Excel's palette then when you export to Excel format your colour will not be displayed...
Looks correct to me too. A couple of things to consider;
1) BETWEEN is inclusive, so if a.effdate = @PrevQtrClose or a.effdate = @PrevYrClose, then it will also be excluded. That may be what you want, just thought I would highlight it.
2) Instead of using the (READCOMMITTED) table hint for each...
64-bit hardware, multiple CPUs and Enterprise editions of Windows Server and SQL Server are the way to go for anything bigger than a small-medium implementation, particularly anything involving data warehousing or is likely to have a large number of users.
OLAP Performance is also heavily...
Hi codingvista,
For the example you gave you could first use a Data Flow task to load the departments table, you will need to add some logic in the data flow to see whether a department already exists or is new (and therefore needs to be inserted). There are a couple of ways to accomplish this...
From the Microsoft website you linked to:
In other words, when you view a report in Report Manager, Sharepoint etc. using a web browser (Internet Explorer) you are viewing it as HTML. There is a difference between viewing a report online (as HTML) and saving/exporting a report to a format like...
Hi, Not sure why you are seeing such a long delay with the Transfer SQL Objects task, I haven't used much myself as I found it too fiddly to configure - this blog post below describes a way of creating your own object transfer using a Script Task that uses SQL Management Objects, which is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.