Web Tests Of Reports Working For Anyone?
Feb 11, 2007
Has anyone been successfull in creating a Web Test with Team System to test a Reporting Services report? I can record the test just fine but I can't run the test without errors being reported. I suspect that the session state has to be parameterized but I have no clue how to do this.
Why is this so hard? Why aren't there samples for this kind of thing? I've been all over the SSRS and Team Test forums and the MSDN site and can't find anything about Reporting Services reports being tested with Team System Web Tests.
View 1 Replies
ADVERTISEMENT
Mar 1, 2008
Hi,
I have installed a MS CRM 3.0 Server with SQL 2005 Reporting Server on the same server.
Whenever I access reports from MS CRM with internal IP i.e http://192.168.100.55:5555 within my network every default as well custom reports are working fine.
But the same when I access with Public IP i.e. http://209.199.X.X:5555 I am able to see the application in public i.p but the reports are not working.
Is there any way so that I can access my all reports from MS CRM in public IP.
Thanks
Kshitij
View 1 Replies
View Related
Dec 22, 2006
Hi,
I would like to save a report (.rdl) and work offline with it. Is there a way for doing this without having to install reporting services.
View 6 Replies
View Related
Jan 17, 2006
Interactive sorting works just fine on my report until I set the
execution property to render from snapshot. When viewing a snapshot,
clicking on the column sort arrows will not sort the data I'm viewing. If I turn the snapshot feature off, then I get the interactive sort functionality back.
Is this by design or am I missing something fundamental here?
Using SQL 2005, RS 2005, VS 2005.
Thanks.
View 2 Replies
View Related
Sep 7, 2015
We had migrated the SSRS reports from 2008 R2 to SSRS 2012 SP2Â version. We had a strange issues after migration.
The report which is having images is not working and it just hangs.
The reports which doesn't have any images are working fine.
On top of it some times we are getting the following error message.
Error message : The request failed with HTTP status 503: Server Error.
View 4 Replies
View Related
Feb 9, 2006
Hi all,
Drill through bar charts work great in the report designer preview, but as soon as I deploy the report, and view the report in a webpage, drill through does not work smoothly.
I have to move the mouse around to be able to find a place on the bar to click through to the next report. Sometimes, I am able to click on the bar to go to next report, but then sometimes I have to click on the label, and other times somewhere in the vicinity of the label.
Any help will be much appreciated.
Thanks,
Kanwal
View 1 Replies
View Related
Mar 4, 2007
Hello, I have a configuration where my SharePoint services are running on a web machine and the SQL server reporting services are running on a different machine.
I installed SQL SP2 and the SQL Server Reporting Services Add-in for SharePoint by following all the instructions listed in €śConfiguring Reporting Services for SharePoint 3.0 Integration€? (http://msdn2.microsoft.com/en-us/library/bb326356.aspx).
My issue is that when I Deploy a report from a VS Report Server project by running Visual Studio on the machine where reporting servicers is running, everything works fine.
But if I try the same thing on any other machine on the network, I get a €śThe file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.€? message.
I€™m sure I€™m missing something on the configuration but I can€™t tell what.
Thanks a lot
Gabo
View 1 Replies
View Related
May 19, 1999
Has anyone who has taken and passed the SQL 7.0 test for SQL Admin
have any recommendations on the best sources to help pass?
View 2 Replies
View Related
Jul 30, 2007
Hi Everyone -
We were discussing select speeds the other day,
the question comes in at...
what is faster, a standard query with specifies the search critera
i.e. select * from xyz where a='A' or a='B'
or is the IN a better way to go....
select * from xyz where a in ('A', 'B')
we ran the tests in performance analyzer,
but they were the same results....
maybe i'm smoking the stuff - but i thought the
useage of the IN causes a full table scan for each
of the items in the in clause
please advise
take care
tony
View 4 Replies
View Related
Apr 23, 2007
Anyone know of a site or company that provide good pre-tests for certification?
I don't mind paying for downloadable test either.
Peter Larsson
Helsingborg, Sweden
View 5 Replies
View Related
Feb 17, 2006
http://www.testyourabilities.com/it/IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
View 2 Replies
View Related
Jun 3, 2015
I have one requirement where i have multiple tests conducted on different dates where i have to calculate last 'x' no of tests
Test Date
Test Seq
Subject
1/12/2014
1
English
[code]....
If i enter @testcount=2 then it should pull the data for only data related to test date 1/12/2014 & 10/06/2014...Above data is only sample data but logic should be dynamic..
View 9 Replies
View Related
Jul 28, 1998
I am currently investigating tools that are available that would enable us to performance test SQL tables/databases- can anyone recommend any?
Thanks
View 1 Replies
View Related
Aug 2, 2004
Hi,
I'm trying to extend the usage of the code below. This method returns a variable of type SQLParameter and what I want is to accomodate even a check for a null in the parameter. This is a code which I got from one of my co-workers who isn't anymore working here. Any help would be appreciated. I do not want to throw an exception here when a field's type doesn't fall into one of the categories below. The method where this methos is called is the first part of my below code. Any help would be appreciated.
Part 1
private void AddCommandParameters(SqlCommand Comm, string sProcName, ArrayList aParams)
{
string sSQL = "sp_helptext @objname = '" + sProcName + "'";
SqlDataReader dr = this.GetDataReader(sSQL);
int i = 0;
if(dr.Read())
{
while(dr.Read())
{
//CLOSING PARENTHESIS
//When at the closing paren of the stored procedure's variable
//declaration, quit adding parameters.
if(dr[0].ToString().Trim() == ")")
{
break;
}
//ENDING PARENTHESIS
//When at the closing paren of the stored procedure's variable
//declaration, do nothing and skip to next record.
else if(dr[0].ToString().Trim() == "(")
{
//Nada
}
//PARAMETERS
//Add all the parameters listed in the stored procedure's variable
//declaration.
else
{
string [] sParamDef = dr[0].ToString().Trim().Split(Convert.ToChar(" "));
int cs = sParamDef.Length;
string st = sParamDef[0].ToString().Trim();
SQLParameter s = GetSQLParameter(sParamDef[0].ToString().Trim());
Comm.Parameters.Add(sParamDef[0], s.Type, s.Size);
Comm.Parameters[sParamDef[0]].Value = aParams[i];
i++;
}
}
}
else
{
throw(new Exception("Stored Procedure: " + sProcName + " NOT FOUND."));
}
dr.Close();
}
Method being called
private SQLParameter GetSQLParameter(string sVarTypeDec)
{
SQLParameter oParameter;
//VARCHAR
if(sVarTypeDec.IndexOf("varchar") >= 0)
{
int iOpen = sVarTypeDec.IndexOf("(");
int iClose = sVarTypeDec.IndexOf(")");
int iSize = Convert.ToInt16(sVarTypeDec.Substring(iOpen + 1, iClose - iOpen - 1));
oParameter = new SQLParameter(SqlDbType.VarChar, iSize);
}
//CHAR
else if(sVarTypeDec.IndexOf("char") >= 0)
{
int iOpen = sVarTypeDec.IndexOf("(");
int iClose = sVarTypeDec.IndexOf(")");
int iSize = Convert.ToInt16(sVarTypeDec.Substring(iOpen + 1, iClose - iOpen - 1));
oParameter = new SQLParameter(SqlDbType.Char, iSize);
}
//SMALLDATETIME
else if(sVarTypeDec.IndexOf("smalldatetime") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.SmallDateTime, iSize);
}
//DATETIME
else if(sVarTypeDec.IndexOf("datetime") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.DateTime, iSize);
}
//FLOAT
else if(sVarTypeDec.IndexOf("float") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.Float, iSize);
}
//REAL
else if(sVarTypeDec.IndexOf("real") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.Real, iSize);
}
//SMALLMONEY
else if(sVarTypeDec.IndexOf("smallmoney") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.SmallMoney, iSize);
}
//MONEY
else if(sVarTypeDec.IndexOf("money") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.Money, iSize);
}
//BIT
else if(sVarTypeDec.IndexOf("bit") >= 0)
{
int iSize = 1;
oParameter = new SQLParameter(SqlDbType.Bit, iSize);
}
//TINYINT
else if(sVarTypeDec.IndexOf("tinyint") >= 0)
{
int iSize = 1;
oParameter = new SQLParameter(SqlDbType.TinyInt, iSize);
}
//SMALLINT
else if(sVarTypeDec.IndexOf("smallint") >= 0)
{
int iSize = 2;
oParameter = new SQLParameter(SqlDbType.SmallInt, iSize);
}
//BIGINT
else if(sVarTypeDec.IndexOf("bigint") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.BigInt, iSize);
}
//INT
else if(sVarTypeDec.IndexOf("int") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.Int, iSize);
}
else
{
throw(new Exception("Parameter type not supported."));
}
return oParameter;
}
Thanks,
View 1 Replies
View Related
Mar 26, 2008
If this post belongs somewhere else I appologize. I have spent several days trying to solve this problem with no luck. My site is online. Hosted at NeikoHosting. I can connect to the database remotely when adding a datacontrol. It tests fine. But when running the page it won't connect. Even if I go in and change the Web.Config connection string to a local Data Source provided to me by Neiko, it still won't work. It just won't connect. Here are the two connection strings in the Web.Config, minus my login info: Only the remote string will pass testing. Neither works on the site. <add name="yourchurchmychurchDBConnectionString" connectionString="Data Source=MSSQL2K-A;Initial Catalog=yourchurchmychurchDB;Persist Security Info=True;User ID=me;Password=pwd" providerName="System.Data.SqlClient" />
<add name="yourchurchmychurchDBConnectionString2" connectionString="Data Source=66.103.238.206;Initial Catalog=yourchurchmychurchDB;Persist Security Info=True;User ID=me;Password=pwd" providerName="System.Data.SqlClient" />
Here is the stack trace, if that helps.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]
System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1131233
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.OleDb.OleDbConnection.Open() +37
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.FormView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.FormView.EnsureDataBound() +163
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041
So....... HELP!!!!
Thank you!
View 3 Replies
View Related
Sep 9, 2014
I am getting following errors in my Cluster Validation report when trying to create a Windows Cluster.
I have 2 nodes DB01 and DB02 . Each has 1 public ip, 1 private ip (for heartbeat), 2 private ips for SAN1 and SAN2. The private ip's to SAN are directly connected via Network Adaptor in DB01 and DB02.
Validate Microsoft MPIO-based disks
Description: Validate that disks that use Microsoft Multipath I/O (MPIO) have been configured correctly.
Start: 9/9/2014 1:57:52 PM.
No disks were found on which to perform cluster validation tests.
Stop: 9/9/2014 1:57:53 PM.
[Code] ...
View 9 Replies
View Related
Apr 27, 2007
With a Gridview Control, I set the SqlDataSource to be a stored procedure in a Sql Sever database.
Using the wizzard to configure the datasource, the test returns lots of rows. After completing the wizzard, the gridview control does not show the column names in the VS2005 designer. For the gridview column headers the values are Databound Col0, Databound Col1, Databound Col2, ....) This tells me I have a problem.
I tried the same thing with a simpler stored procedure. This test stored procedure does not call anything else, takes several input parameters, returns rows. The column names show in the gridview control as expected.
So I am trying to figure out why the first case of gridview with sqldatasource is not working and the second case works . The stored procedure that is not working with my gridview calls multiple inner stored procedures and has #TEMP tables. My complex stored procedure ends with Select * from #Temp.
Could the calling of other inner stored procedures and use of #temp tables contribute to the problem? If yes then what is the strategy for using a gridview and loading it with the data that the complex stored procedure returns?
View 8 Replies
View Related
Apr 16, 2015
Using a 32-Bit SQL Server 2008 Express on my LOCAL PC. I downloaded the Advantage 8.1 OLE DB Provider and created a linked server to a REMOTE Advantage 8.1 database server. There is no data dictionary on the Advantage server.
Here is my linked server:
EXEC master.dbo.sp_addlinkedserver @server = N'1xx.1xx.xx.1xx', @srvproduct=N'Advantage', @provider=N'Advantage OLE DB Provider', @datasrc=N'1xx.1xx.xx.1xxeccET', @provstr=N'servertype=ads_local_server;tabletype=ads_cdx;'--tabletype=’ADS_ADT’ (this test works too)
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'1xx.1xx.xx.1xx',@useself=N'False',@locallogin=Null,@rmtuser='adssys',@rmtpassword=Null
Testing the link succeeds with above. Using “ads_REMOTE_server” instead of “ads_local_server” and the test fails. Here is my problem, using the following queries will not work. Perhaps it’s a permissions issue? When I specify my local credentials for the remote server in the linked server it still does not work.
SELECT * FROM OPENQUERY([1xx.1xx.xx.1xx], 'SELECT * FROM ActType')
OLE DB provider "Advantage OLE DB Provider" for linked server "1xx.1xx.xx.1xx" returned message "Error 7200: AQE Error: State = HY000; NativeError = 5004; [Extended Systems][Advantage SQL][ASA] Error 5004: Either ACE could not find the specified file, or you do not have sufficient rights to access the file. Table name: ActType SELECT * FROM ActType".
Msg 7321, Level 16, State 2, Line 2
An error occurred while preparing the query "SELECT * FROM ActType" for execution against OLE DB provider "Advantage OLE DB Provider" for linked server "1xx.1xx.xx.1xx".
View 0 Replies
View Related
Nov 5, 2007
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
View 4 Replies
View Related
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 2 Replies
View Related
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 1 Replies
View Related
Jan 23, 2007
Hi does anyone know how to do the above with out going through reportserver url?
Preferably by using a cmd tool ? such rs.exe
or through the backend in the reportserver DB?
Thanks
Dave
View 2 Replies
View Related
Feb 13, 2008
Hi Friends,
Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...
Could anyone explain me. How it works.
Thanks
sqlferns
View 2 Replies
View Related
Mar 27, 2008
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Thanks,
Patrick Conway
View 9 Replies
View Related
Aug 7, 2007
Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.
The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.
Is there a way to do this?
Thanks for your help.
View 3 Replies
View Related
Mar 3, 2006
hi
I had a view in which I did something like this
isnull(fld,val) as 'alias'
when I assign a value to this in the client (vb 6.0) it works ok in sql2000 but fails in 2005.
When I change the query to fld as 'alias' then it works ok in sql 2005 .
why ?? I still have sql 2000 (8.0) compatability.
Also some queries which are pretty badly written run on sql 2000 but dont run at all in sql 2005 ???
any clues or answers ?? it is some configuration issue ?
Thanks in advance.
View 5 Replies
View Related
Jan 7, 2004
I am writing a pgm that attaches to a SQL Server database. I have an Add stored procedure and an Update stored procedure. The two are almost identical, except for a couple parameters. However, the Add function works and the Update does not. Can anyone see why? I can't seem to find what the problem is...
This was my test:
Dim cmd As New SqlCommand("pContact_Update", cn)
'Dim cmd As New SqlCommand("pContact_Add", cn)
Try
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@UserId", SqlDbType.VarChar).Value = UserId
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = TextBox1.Text
[...etc more parameters...]
cmd.Parameters.Add("@Id", SqlDbType.VarChar).Value = ContactId
cn.Open()
cmd.ExecuteNonQuery()
Label1.Text = "done"
cn.Close()
Catch ex As Exception
Label1.Text = ex.Message
End Try
When I use the Add procedure, a record is added correctly and I receive the "done" message. When I use the Update procedure, the record is not updated, but I still receive the "done" message.
I have looked at the stored procedures and the syntax is correct according to SQL Server.
Please I would appreciate any advice...
View 2 Replies
View Related
Dec 31, 2007
Hi all,
I have two problems.
1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.
2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.
Thanks,
Mahesh Manthena
View 1 Replies
View Related
Apr 18, 2007
Hi,
We just deployed a report solution and I would like to know when and how much each report is used. Is there a report for it ?
With regards,
Constantijn Enders
View 3 Replies
View Related
Oct 24, 2006
Hi all, how can we get running totals for particular column in sqlserver crystal reports
View 1 Replies
View Related
Oct 24, 2006
how to get running totals for a particular field in sqlserver reports
View 2 Replies
View Related
Nov 8, 2007
Hi,
I have all stored procedures for report for this month and previous month. Now my task is to generate report to find out the difference for all coulms those are same for both month reports.
EX of final report
Month1|Month2|Difference|
sales |Sales | % |
| | |
| | |
| | |
There are other colums in those rows too..
So could any one help me out.
I want my out put in Excel sheet
And its a recuant report ..so i have to use stored procedure.
LOOKING FOR HELP ASAP
View 1 Replies
View Related
Feb 20, 2008
How to know which reports are being run/accessed ? Do i have to query some tables for that.
View 1 Replies
View Related
