Changes In Paramters In RS2005 Compare To RS2000
Nov 27, 2007
Hi there,
I've got a RS2000 report from Analysis services 2000. This report is working fine but after the upgrade to SQL2K5, i'm having issues with changes to parameters.
Basically i'm passing DateQuarter, CustomersLevel as parameters to the following mdx script. I've tried to change mdx script in RS2005 but no luck yet. I don't much about the parameter level changes in sql2k5. So can anyone suggest what is wrong in the script.
Code Block
RS2000
="with " &
"member [Measures].[Ex Price] as 'coalesceempty([Measures].[Ex Price After Trade Discount - Detail],0.00)' " &
"set [Rolling Quarters] as '" + Parameters!DateQuarter.value +".lag(4):" + Parameters!DateQuarter.value + "'" &
"SELECT " &
"{[Measures].[Ex Price]} ON COLUMNS , " &
"filter({CrossJoin([Items by Class].[Item Class Description].members, [Rolling Quarters])}, [Measures].[Ex Price] > 0) on Rows " &
"FROM Sales " &
"WHERE (" & Parameters!CustomersLevel.Value & ")"
RS2005
with
member [Measures].[Ex Price] as 'coalesceempty([Measures].[Ex Price After Trade Discount - Detail],0.00)'
set [Rolling Quarters] as '@DateQuarter' +'.lag(4):' + '@DateQuarter'
SELECT
{[Measures].[Ex Price]} ON COLUMNS ,
filter({CrossJoin([Items by Class].[Item Class Description].members, [Rolling Quarters])}, [Measures].[Ex Price] > 0) on Rows
FROM Sales
WHERE STRTOSET(@CustomersLevel)
Thanks in advance,
Vivek
View 4 Replies
ADVERTISEMENT
Feb 5, 2007
We successfully migrated our RS2000 to RS2005. But we run into an issue €“ trying to modify an existing subscription that was created on RS2000 (We do not have this problem if the subscription is created on RS2005).
The error message is:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help.
The specified @name (€˜B3F7CB60-6636-4F67-93CF-B94C052DFD29€™) already exists.
The call stack is:
w3wp!library!d!02/05/2007-14:31:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: The specified @name ('B3F7CB60-6636-4F67-93CF-B94C052DFD29') already exists.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.CreateTask(Task task)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.RSService._SetSubscriptionProperties(String subscriptionID, ExtensionSettings extensionSettings, String description, String eventType, String matchData, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.RSService.SetSubscriptionProperties(Guid batchId, String subscriptionID, ExtensionSettings extensionSettings, String description, String eventType, String matchData, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
--- End of inner exception stack trace ---
The error message is raised from the stored procedure sp_verify_job:
-- NOTE: We allow jobs with the same name (since job_id is always unique) but only if
-- they originate from different servers. Thus jobs can flow from an MSX to a TSX
-- without having to worry about naming conflicts.
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobs
WHERE (name = @name)
AND (originating_server = @originating_server)
AND (job_id <> ISNULL(@job_id, 0x911)))) -- When adding a new job @job_id is NULL
BEGIN
RAISERROR(14261, -1, -1, '@name', 'name')
RETURN(1) -- Failure
END
which is called by another stored procedure sp_add_job.
Question:
Is there anyway that I can workaround this issue? Or is there anyway that I can re-create existing report server subscriptions (I have 300+ subscriptions) programmatically.
Please help.
Bobby Fu
View 2 Replies
View Related
Nov 30, 2007
Hi all,
Not sure what's going on here...
I had reports using the HTML Viewer working in RS 2000. The servers were both O/S Windows 2000, SQL Server 2000, IIS 5.0, Reporting Services 2000) The default toolbar and parameters area were formatted and looked fine.
We just migrated to new servers with Windows 2003 Server, SQL Server 2005, IIS 6.0, Reporting Services 2005. I have the reports working fine...except the toolbar and parameters areas look as if there is no formatting at all...as if the style sheet isn't being applied (not even the default one --see below).
Although I don't think this is necessary....I tried the following to resolve the issue....
Updated the RSReportServer.config file.
Driveletter:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config
Checked that the HtmlViewer.css file was in the ...ReportServerStyles folder.
Added the following line between the
<Configuration>.......</Configuration> tags in the RSReportServer.config file.
<HTMLViewerStyleSheet>HtmlViewer</HTMLViewerStyleSheet>
Find
|
Next
Select a format XML file with report data CSV (comma delimited) TIFF file Acrobat (PDF) file Web archive Excel
Export
I can't find anyone else having this issue...any ideas?
Hope someone can help...thanks for looking....
Leslie
View 3 Replies
View Related
Nov 4, 2007
I am in a SQL Class and I am starting to learn about SQL Parameters in conjunction with using them from a C# program. I have a couple of questions.
1. When I include an Output parameter in the list or paramters that I send, SQL always is returning a message indicating that the parameter was missing, when I know in fact that I am passing the paramter (@RtnMsg)
2. When I remove any reference to "@RtnMsg", which it can not find, and execute the stored procedure it always returns a -1 and never inserts the record.
Here is my code for the stored procedure....
ALTER procedure [dbo].[Insert_Biblio]
@ISBN as char(11),
@CALL_NO as char(20),
@DEWEY_NO as char(20),
@AUTHOR as char(5),
@TITLE as char(100),
@AUTHOR_BORN as int,
@AUTHOR_DIED as int,
@PUBLISHER as char(30),
@YEAR_PUBLISHED as int,
@BOOK_INFO as char(49),
@BOOK_HEIGHT as int,
@BIBLIO_INFO as char(100),
@COST as money,
@TOPIC_1 as char(30),
@TOPIC_2 as char(30),
@RtnMsg as varchar(50) output
as
declare @Book_ID as char(5);
begin
Set @RtnMsg = 'Insert Successful'
return 0
select @Book_ID = max(book_ID) + 1
from collection
insert into biblio
(BOOK_ID,ISBN, CALL_NO, DEWEY_NO, AUTHOR, TITLE,
AUTHOR_BORN, AUTHOR_DIED, PUBLISHER, YEAR_PUBLISHED,
BOOK_INFO, BOOK_HEIGHT, BIBLIO_INFO, COST,
TOPIC_1, TOPIC_2)
values (@BOOK_ID,@ISBN, @CALL_NO, @DEWEY_NO,
@AUTHOR, @TITLE, @AUTHOR_BORN,
@AUTHOR_DIED, @PUBLISHER, @YEAR_PUBLISHED,
@BOOK_INFO, @BOOK_HEIGHT, @BIBLIO_INFO,
@COST, @TOPIC_1, @TOPIC_2)
return 0
end
Here is the C# program code (this version is the one where SQL tells me @RtnMsg is missint.
SqlParameter[] parms = new SqlParameter[16];
parms[0] = new SqlParameter("@ISBN", SqlDbType.Char, 11);
parms[0].Value = (txtISBN.Text.Length == 0 ? (object)DBNull.Value : txtISBN.Text);
parms[1] = new SqlParameter("@CALL_NO", SqlDbType.Char, 20);
parms[1].Value = (txtCallNbr.Text.Length == 0 ? (object)DBNull.Value : txtCallNbr.Text);
parms[2] = new SqlParameter("@DEWEY_NO", SqlDbType.Char, 20);
parms[2].Value = (txtDewerNbr.Text.Length == 0 ? (object)DBNull.Value : txtDewerNbr.Text);
parms[3] = new SqlParameter("@AUTHOR", SqlDbType.Char, 5);
parms[3].Value = (txtAuthor.Text.Length == 0 ? (object)DBNull.Value : txtAuthor.Text);
parms[4] = new SqlParameter("@TITLE", SqlDbType.Char, 100);
parms[4].Value = (txtTitle.Text.Length == 0 ? (object)DBNull.Value : txtTitle.Text);
parms[5] = new SqlParameter("@AUTHOR_BORN", SqlDbType.Int);
parms[5].Value = (txtAuthorDOB.Text.Length == 0 ? (object) DBNull.Value : Convert.ToInt32(txtAuthorDOB.Text));
parms = new SqlParameter("@AUTHOR_DIED", SqlDbType.Int);
parms.Value = (txtAuthorDOD.Text.Length == 0 ? (object) DBNull.Value : Convert.ToInt32(txtAuthorDOD.Text) );
parms[7] = new SqlParameter("@PUBLISHER", SqlDbType.Char, 30);
parms[7].Value = (txtPublisher.Text.Length == 0 ? (object)DBNull.Value : txtPublisher.Text);
parms = new SqlParameter("@YEAR_PUBLISHED", SqlDbType.Int);
parms.Value = (txtYearPublished.Text.Length == 0 ? (object) DBNull.Value : Convert.ToInt32(txtYearPublished.Text) );
parms[9] = new SqlParameter("@BOOK_INFO", SqlDbType.Char, 49);
parms[9].Value = (txtBookInfo.Text.Length == 0 ? (object)DBNull.Value : txtBookInfo.Text);
parms[10] = new SqlParameter("@BOOK_HEIGHT", SqlDbType.Int);
parms[10].Value = (txtBookHeight.Text.Length == 0 ? (object)DBNull.Value : Convert.ToInt32(txtBookHeight.Text));
parms[11] = new SqlParameter("@BIBLIO_INFO", SqlDbType.Char, 100);
parms[11].Value = (txtBiblioInfo.Text.Length == 0 ? (object)DBNull.Value : txtBiblioInfo.Text);
parms[12] = new SqlParameter("@COST", SqlDbType.Money);
parms[12].Value = (txtCost.Text.Length == 0 ? (object)DBNull.Value : Convert.ToDouble(txtCost.Text));
parms[13] = new SqlParameter("@TOPIC_1", SqlDbType.Char, 30);
parms[13].Value = (txtTopic1.Text.Length == 0 ? (object)DBNull.Value : txtTopic1.Text);
parms[14] = new SqlParameter("@TOPIC_2", SqlDbType.Char, 30);
parms[14].Value = (txtTopic2.Text.Length == 0 ? (object)DBNull.Value : txtTopic2.Text);
parms[15] = new SqlParameter("@RtnMsg", SqlDbType.VarChar, 50);
parms[15].Direction = ParameterDirection.Output;
foreach(SqlParameter parm in parms)
{
if (parm.ParameterName != "@ReturnValue")
{ parm.Direction = ParameterDirection.Input; }
}
string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["CIS277ConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("dbo.Insert_Biblio", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(parms);
cn.Open();
int rtnCode = cmd.ExecuteNonQuery();
View 1 Replies
View Related
Jan 25, 2006
We want to start working with Reporting Services on a Windows Server 2003 (SP1) server that has SQL2000 (SP3) Standard Edition. I thought I could load RS from the CD but it does not appear to be on there. I seem to remember that Microsoft added RS to SQL2000 in the last year or so. Can I download a copy of it, or how do I go about getting a copy and how to I show my boss that it is a legit copy? Thanks...
View 4 Replies
View Related
Jan 12, 2000
Does anyone have a way of finding all parameters with default values, for any stored procedure in a database?
aTdHvAaNnKcSe!
View 1 Replies
View Related
Jul 20, 2005
From previous postings I have read it seems that I cannot create afunction that accepts a variable list of parameters. Seems that SQLServer does not support this.A few questions:Is this true?What is a workaround?Then how does the function COALESCE do it?Cut and pasted from online books:SyntaxCOALESCE ( expression [ ,...n ] )ArgumentsexpressionIs an expression of any type.nIs a placeholder indicating that multiple expressions can bespecified. All expressions must be of the same type or must beimplicitly convertible to the same type.
View 3 Replies
View Related
Nov 15, 2007
What is the proper syntax for the SET transact-sql for mult-value parameters? Is this even possible?
Code Block
declare @Name char(55);
set @Name = 'name1';
select *
from table1
where name in (@Name)
How do I write the SET line so that it will behave like this:
where name in ('name1','name2','name3')
I'm sure this is an easy one, I'm currently looking it up, but thought someone might be able to answer this for me quick.
Thanks much!
View 5 Replies
View Related
Aug 15, 2007
We just applied SP2 to our Windows 2003 server & it has had an odd impact RS2000.
When trying to change the data source of a report to a shared data source, the browse button when clicked does not take you to the page to enable selection! It does nothing!
Does anyone have any ideas on what's going on there?
View 1 Replies
View Related
Oct 12, 2007
Here's the situation we're facing. Our organization is going to consolidate into a single domain. The plan of action is to disband the old domain, and create an all new domain. Most of our servers will also be renamed in the process.
We've got something of a two-server setup, with one machine handling SQL Server, and the other hosting various intranet sites, including Reporting Services 2000.
SQL Server itself shouldn't be a huge problem to migrate - the machine only has about half a dozen Windows logins set up. In my experience, though, Reporting Services is a much more fragile animal. Just getting it up and running on Win2003 SP1 and coexisting with ASP.NET 2.0 was enough of a stunt already. What will I have to watch out for to make sure this doesn't completely hose our installation? Would it be too optimistic for me to hope that I'll just have to reconcile any domain service accounts, change the connection string for the report server catalog database, and be done with it?
View 1 Replies
View Related
Feb 28, 2008
i have a query in SQL Server 2005 that uses a parameter like so:ALTER Procedure [dbo].[p_FullTextEquipmentSearch]
@search as nvarchar(50),
as
SELECT * FROM EquipmentView
where contains(*, @search);
what i want to so is add more parameters to the query so that the user can choose either 1 or many for the search can anyone help me on this
View 2 Replies
View Related
Nov 14, 2006
Hello,
I just installed the new SQL 2005 sp2 CTP on my stand alone report server. Now whenever a parmeter is not multi-value I get
One or more data sources is missing credentials
when clicking off the parameter. If I set the parameter to multi-value it works fine but confuses the users.
Does anyone know how to debug this or if a fix is available ? Yes it was working before I installed the service pack.
View 3 Replies
View Related
Apr 28, 2008
We are using MS Reporting Services to generate Xmls for corporate billing statements. Our DBAs found that MS ReportingServices are querying Oracle Catalogue before executing stored procedures in RDLs to get Oracle parameter information. Is there a way to eliminate the trip to database before executing the stored procedures?
Hongmei
View 1 Replies
View Related
Mar 5, 2007
We're using RS2000 and there are some reports that are having problems exporting to Excel after having been rendered.
The reports have no more than 30,000 rows, but are about 150 columns wide. The reports run (execute and redner) very quickly in Reporting Services, but when exporting, the "blank rendering window" (the one with the URL: "http://ServerName.Reportserver?ReportName&rs%3aCommand=Render&rs%3AFormat=EXCEL) is open for about half an hour, and the w3wp process pummels our 8 proc box (CPU between 50 and 90% for that time) and memory goes past 1.5 GIG (of the total 8 GIG) usage.
Sometimes we'll get a message asking the user to log in after about 10-15 minutes, after which it fails, other times it makes it to the dialog box asking if you want to open or save the spreadsheet. If it makes it to this dialog, it's OK, if not, it fails on the export. The resulting spreadsheets are only between 25 - 32 MG, not very big at all.
Are there any settings we can tweak to speed this up, or at the very least, be sure it always makes it to the Open/Save dialog?
Thanks in advance.
View 3 Replies
View Related
Sep 19, 2007
Hi There
I've not managed to find an answer already about this, and so I know you guys will be able to help me out becuase your great!!!
Our Reporting Services portal is acting strangely, all the existing reports we have subscriptions for are running fine.
However should we change the list of contacts or the dates or times of any exisiting schedule this stops our reports from being delivered, infact the report run time will pass, but the report will not run and even in the Subscriptions table of RS the last status will only show "New Subscription".
So whatever is happening, it is not triggering the correct work flow. (Thats my thought at least)
We examined SQL Agent logs to uncover that the Login used to run the reports was running the existing reports without issue, however the new subscriptions would give the following error:
[298] SQLServer Error: 8198, Could not obtain information about Windows NT group/user 'SERVERNAMEREPORTING_ACCOUNT'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
The server name and account have been changed to protect the gullible and innocent.
I do hope someone else can provide some insight into my issues
Thanks in advance
Tristan
View 1 Replies
View Related
Mar 14, 2008
we're all pretty fluent with 2005 products, but must enhance our legacy 2000 RS product, and prefer to use vs2003. Does anyone recall how we used to get vs2003 to allow RS2000 design. We dont believe we saw such an option in installation of vs2003, but since installing the db preceded that, arent sure if we would have been given such an option had vs2003 been installed prior to the 2000 db.
View 1 Replies
View Related
Dec 3, 2007
Occasionally I have this error happening in some of my subscriptions: Subscription contains invalid parameters.
What is actually happenign, one of the parameters has lost the value on which it was previously running without problems. If I open subscription the first parameter, of more, is having no value. The value that is usually lost is first option in drop down list, being for ALL of bellow values. When the error happens it has no value, and that option normally doesn't exists as a parameter value. (If you go creating new subscription that same parameter doesn't have empty values as options to be selected. I usually return ALL and then other individual values.)
For example, one report is having paramteres that returns values from the stored procedure, and the return dataset would be:
Value Label
----------------- -----
'SP1','SP2','SP3' ALL
'SP1' SP1
'SP2' SP2
'SP3' SP3
So, when the error happens, in no reason (no changes to proc, to report design, to subscription,...)
usually those subscriptions that had ALL for this parameter have lost the value, the option is BLANK, and is treated as invalid value, which is correct, as my query also doesn't return BLANK value.
I have to manually go into subscription and set up the value back to ALL and then it's OK, untill next time.
Has anyone experienced this problem?
Does anyone now the fix for this? We thought that hot fix on SP2 may solve this, we applied on dev server but it didn't.
Or maybe someone knows workaround this issue?
Thanking in advance!
Regards,
Elizabeta
View 2 Replies
View Related
Mar 14, 2007
A few details first:
The report server is remote to the development server (VS 2003).
The web application that will be calling it is ASP.NET 2.0 and developed in VS 2005.
I have a couple of questions:
a: Can I link to the report from the web application using a basic Hyperlink control rather than using a ReportViewer control?
b: How can I force which format it opens in? Say I want it to be rendered as a PDF in one instance but at an XSL document in another.
Many thanks and kindest regards,
TwoForTea
View 1 Replies
View Related
Sep 20, 2007
Using gridview to display the data and sql server 2000 I have
a column in the database say departtime of datetime datatype that
cntains the date and time resp(09/19/2007 9:00 PM). I am separating the
date and time parts to display in two different textboxes say
txt1(09/19/2007) contaons date and txt2(9:00 PM) contains time by using
the convert in sqldatasource. Now i need to update the column in the
database and i am using Updatecommand with parameters in aspx lke
updatecommand = "Update table set departtime = @departtime" . How can
i update my column as datetime by getting the data from 2 texboxes as
now i have 2 textboxes displaying data for single column means if user
edit the data in txt1 as(10/19/2007) then on click of update i need to
populate the column daparttime as (10/19/2007 9:00 PM).Please let me know if you have any questions.
View 1 Replies
View Related
Mar 29, 2006
I have one table with categoriestblCategoriescat_id | cat_name-----------------1 | cat 12 | cat 23 | cat 34 | cat 45 | cat 56 | cat 6and one table with projects which relates to tblCategoriestblProjectsproj_id | proj_name | cat_id----------------------------1 | proj 1 | 22 | proj 2 | 23 | proj 3 | 34 | proj 4 | 2How would you create stored procedure for searching some string infiled proj_name but within multiple categoriesfor exampleCREATE PROCEDURE [spSearch](@SEARCH_STRING nvarchar(200),@CAT_ID int)ASBEGINSELECT proj_idFROM tblProjectsWHERE (proj_name LIKE '%' + @SEARCH_STRING + '%') AND (cat_id =@CAT_ID)ENDBut that one works only with one categorie and i need to search for oneor more categories at once, does anyone have a solution? Is theresomething like ellipsis (...) in C++ for MSSQL?
View 7 Replies
View Related
Nov 5, 2007
Hi
Im writing a program that stores data to SQL server 2005.
Program writen on VC++ 2003.
Code is very simple and it works ok if server runs and parameters are ok.
try
{
HRESULT hr = m_Connection.CreateInstance(__uuidof(ADODB::Connection));
String ConnectionStr;
ConnectionStr.Format(_T("Provider=sqloledb;Data Source=%s;Initial Catalog=MyDB;User Id=%s;Password=%s;"),m_Server.c_str(),m_Username.c_str(),m_Password.c_str());
_bstr_t bstrConnection(ConnectionStr.c_str());
m_Connection->CursorLocation = ADODB::adUseClient;
hr = m_Connection->Open(bstrConnection, L"", L"", ADODB::adConnectUnspecified);
}
catch(_com_error &e)
{
_bstr_t Description = e.Description();
}
But!
if i give wrong paramterer for Data Source , it may happen if user configures it and misprints it, or if server goes offline for some reason, program just hangs on m_Connection->Open and never gives exception as it should.
Any ideas what wrong?
Thanks.
View 4 Replies
View Related
May 22, 2008
Hello,
I want to query data from a cube in analysis services with parameters in reporting services. I'm not sure how to make my select statement. Can someone help me please
Pat
View 3 Replies
View Related
Nov 16, 2007
In SQL 2000, working with Maintenance plan wizard, what would be best settings and values should i choose in "Update Data Optimization information" window,
Thanks,
View 6 Replies
View Related
Aug 14, 2006
Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1 with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2.
My problem is that any page of the report manager with a "OK" button, that button doen't do nothing, it is enabled bu doesn't do any action.
Can't figure this one out
Need Help Thank's
PS: Is did work early on this machine but stop working without notice, or any change at all.
View 4 Replies
View Related
Apr 24, 2008
I've created a drill down rpt in RS2000, but when I setup subscription and receive it as Excel, the file doesn't contain any drill downs.
Does anyone have any idea the reason for this??
thx,
John
View 1 Replies
View Related
Mar 5, 2008
SELECT ArticleID, ArticleTitle, ArticleDate, Published, PublishDate, PublishEndDateFROM UserArticlesWHERE (ArticleDate >= PublishDate) AND (ArticleDate <= PublishEndDate)
When I use the above on a GridView I get nothing. Using SQL manager it works great.
I don't know how to pass the value of the ArticleDate field as a default parameter or I think that's what I don't know how to do.
I am trying to create a app that I can set the dates an article will appear on a page and then go away depending on the date.
Thanks for any help!
View 1 Replies
View Related
Feb 11, 2007
How do you set up user as who can access what report in Report Manger. I do not see security tab in RS2005.
View 1 Replies
View Related
May 5, 2008
Hi all,
I really need help with this issue.
I have a setup a reporting server that works perfectly when accessing it from the intranet. Now I need to give access to this report server over the intranet.
I'm stomped...
The network guys did create a secure access to my report server so I can access my server using :
https://<MySecureRS>/reports
The issue I'm facing is that once I authenticated my self using https://<MySecureRS>/reports
It shows the internal ip addres of my server in the browser.... http://<My internal IP Adress>/reports
How can I configure my server to stay on my secure address?
Thanks
Aiwa
View 4 Replies
View Related
Aug 11, 2006
Hi,
As per my reading, using RS2005 with backend database as SQL 2000 is
possible.
Can anyone tell me whether RS2005 connect to SQL 2000 database on same same
machine. i.e. in short can RS2005 reside with SQL 2000?
Which edition of RS 2005 support backend as SQL2000?
TIA,
Tanmaya
View 3 Replies
View Related
Jul 18, 2007
I have code
Function GetDealCount(reportItems)
return iif(IsNothing(reportItems!txtDetailCountRows.Value), 0, reportItems!txtDetailCountRows.Value)
End Function
Function GetSumNotionalAmount(reportItems)
return iif(IsNothing(reportItems!txtDealSumNotionalAmount.Value), 0, reportItems!txtDealSumNotionalAmount.Value)
End Function
That I am calling from a textboxes in the page header
= Code.GetDealCount(ReportItems) & " Deal(s)"
also
= Parameters!BaseCurrency.Value + " " + Format(Code.GetSumNotionalAmount(ReportItems),"N2").ToString().Replace(",","'")
When I preview the report in VS.NET I get values showing.
When I deploy the report I just get #Error showing.
Also this report used to work fine in RS2000
Does anyone know the cause of this issue?
View 6 Replies
View Related
Apr 13, 2007
Has anyone used the MDX Scope Statement in a RS2005 Reporting Services
Report?
I am not sure if the scope / end scope statement will work in a RS report script.
Thanks,
View 4 Replies
View Related
Jan 10, 2007
I have a report that needs to show postal addresses. The address is broken down into several fields. The problem I have is some of the address parts are optional. If they are empty, I'm left with nasty gaps in the address. I'd really like next label to reclaim the space of any empty labels.
a quick example
A full address would look like this..
customer name
address line 1
address line 2
town
county
post code
if address line 2 isnt given, I get:
customer name
address line 1
town
county
post code
but I want:
customer name
address line 1
town
county
post code
Can anyone help?
Many thanks,
Paul
View 4 Replies
View Related
