Thank you for your response. I did try select date_column from linked_server...table and select * from openquery (linked_server,'select date_column...
Hello, I have successfully set up linked server from sql server 2005 (sp2) to a lotus notes database ( using NOTESSQL ver 8.0 ) and can query the...
Hello, I migrated one of our main databases from sql 2000 to sql 2005. This query worked well in sql 2000 but fails in 2005 ( giving the error NAME...
Ranjit, Thanks for your response This link explains for simple reports in a RDL file. But I need to know the option using report builder . Regards,...
In report builder , is there an option to show the page numbers on each page in the report generated. There is no report header and footer options as...
Hi, In reporting services , Is there an option to avoid drill thru when the value of the column is zero. Thanks, Shivi
We are connecting to Oracle.. which doesn't have any easy command like Pivot and Unpivot and there where the problem started,
Thanks for your quick reponse.. Actually my table is CustomerNameProcessingMonthYearcnt A Jan-20071 A Feb-200723 A...
Hi, I am creating a Matrix report and I need to perform few calculations on the columns that are dynamically created....
Hi, When the report is exported to excel, data appears in different sheets with the default sheet names - Sheet1, sheet 2….. But I need the...
Hello, I have a simple report which displays the values from a sql server table thru reporting services. We have used a 'table' report item. One...
Hello, I am trying to import a text file to sql server. Flat file has date, text and int columns. There is an erroneous row where the text qualifier...
I have the lastest sp - SQL Server 2005 Service Pack 2 installed on my pc and the server as well.. now do I need to reapply the packs on the server...
I have 2 issues when using reporting services 1) Intermittently I get memory error Event code: 3005 Event message: An unhandled exception has...
Spirit, No, if the 'to' date is < 'from' date then it will not give any records. Anyway thanks for your replies.. Regards, Shivi
Hello, In my report I am getting the 'FROM' date and 'TO' date as parameters .Is it possible to validate the 'TO' date to check if it is always...
missed to mention one point.. when I removed the expression =iif(Parameters!Showtable1.Value ="Y",false,true) from table VISIBILITY property then...
Thanks for your replies. I have done this by creating multiple tables in a single RDL and each table gets the data from different tables. For each...
Hello, We need to create a report which has many sub reports as follows 1) Get the customer and the bill date as a parameter 2) report 1 should...
We have a database that contains very confidential information and only 2 users in our company are allowed to view the data. Even the system...
Separate names with a comma.
