Hi,
I am accessing my reports through one aspx page designed by me.
in that i am using webservice to render the report and
linking the url of the report to reportviewer
it is working fine
but for the first time it is asking username & password of the reporting server to render the report.
i am using Reporting Services 2000
plz help to avoid this user name & password prompt.
Hi,
We are using Microsoft Reporting Service 2005 to develop reports and we are accessing these reports through a J2EE application.
The front end is implemented using Tapestry and we using JBoss as our applicaiton server.
We are using Shared Data Sources for the reports and we set its data source type to SQL Server Analysis Services.
In the credential tab, by default "Use Windows authentication" is selected. All other options are disabled.
When I access my reportserver through my web application, I am always prompted for a windows login and password.
How can I avoid being shown the windows login prompt, since our web application will be used by several users and we do not want the users to type in a username/password everytime they want to access our reports.
Please suggest me solution for this scenario.
Thanks in advance!
hi all
any one can tell me to avoid credential prompt i.e. uid & pwd when the first time going to render report from the reporting server
I need to verify a csv file exists before I call a stored procedure to complete a bulk insert. The first step in the SP will be to verify the file exists (that particular "Job" step did not fail). I have only one step in the job that I have set the type as "Operating System (CmdExec)" and the Command is "Dir C:NAFCDMDataShipmentsCooperShipments.csv". When I execute the job manually to verify the proper operation I receive the error listed below. I know the path and file name are correct as I originally typed in the UNC, when it failed I copied it from the Address bar. I attempted to move the file to the root location without success. I attempted to use another file. I have attempted to rename the file. The DBAs will not allow me to use the SP_cmdshell stored procedure (that was my first thought).
I added 'Everyone' with Full Access to the root folder and propagated these permissions to all containing folders. This again did not allow the job to run. I changed the statment to "REN C:NAFCDMShipmentsShipment.csv Shipment1.csv". I continue to get the same error. Can someone Please point me in a direction to fix this problem?
"The process could not be created for step 1 of job 0x71D51027F920A140A2913234DB7FF509
(reason: The system cannot find the file specified). The step failed.
The job failed. The Job was invoked by User sa. The last step to run was step 1 (Verify the File's Existance)."
We are planning on using 2005 report services. Im wondering how I can feed reports to my asp.net web application that resides on a different machine.
The scenario is:
user -> IIS web app -> report on sql
I guess the real question at this point for me, is if I have reports - can I have them cached in pdf format and then how are they accessed with a url ?
Hi, when I am using the Report Manger to open a report, I am unable to acess the Database from my .Net application and vice versa - error report from MS Visual Web developer - "Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
Hi,
I have report that in access 97. When i run that report every morning, it's update technician time, mileage and money. I want that report to be update every min like real time report in sql reporting service.
The main thing i want to know is how to import report from access 97 to sql reporting service. I am not really familiar with reporting services in sql, can you be little more specific where to set up time?
The report only update when i run query every morning. Queries and Tables are in access 97. When i tried to migrate tables with ssma, i wan not able to convert all of the query.
Thanks.
Hi there,
I've seen some similar posts to this one, however none with an answer and I'm wondering if anyone has actually figured out what causes this issue. I'm running SQL Server 2005 Reporting Services.
I'm attempting to implement a folder structure for the report server, therefore am creating individual solutions in Visual Studio for each folder. At the top level i.e http://servername/reportserver/ I am able to deploy reports no problem.
However creating a folder at the next level in the tree and then deploying to that level such as http://servername/reportserver/ManagementReports causes a Reporting Services Login prompt to appear. No matter what user credentials I enter they are not accepted. I have full administrator rights the server, the site and the folders in question.
Has anyone else experienced this? Does anyone have any suggestions?
Thanks
Matt
i have a list report
some values of this are blank or null
i want to avoid that spacing if it is null
like
name:jjj
lastname kkk
firstname
address uuuu
i want it should be
name jjj
lastname kkk
address uuuu
Hello,
I was wondering if there was any way to set the service account on sql server 2005 express to Local System via command prompt.
To giva some background to this issue, I am installing 2005 express via command prompt, however, the default service account is network I believe. However, when running this, I keep getting an "error 3415" whenever I try to attach a database, which states that the files are "read only", which they are not. However, when setting the service account to local or set the security mode to windows authenticaiton, I can attach just fine.
The parameters I use to install are pretty standard:
"/qb ADDLOCAL=ALL INSTANCENAME=<name>SAPWD=<pwrd> SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SQLAUTOSTART=1"
So I was wondering if there was some way to set the service account to local system to local using some command prompt parameter. OR if there was another way around the error 3415 that will enable me to attach a database, that I do not know about that I can use, preferrably via command prompt, but anything will be fine at this point.
Thank you all in advance.
I am trying to get add a parameter to my code so that when the report is run, a dialog box pops up and asks for the date.
The tutorial only seems to talk about parameters as filters, rather than variables. Is there a way to do this?
I'm a very basic user to VSS 2005 and I've created a simple report to display our customer master table. The problem is that we have 1000's of customers, but the report must scroll page by page.
I'd like to prompt the user with:
"Customer code starts with:"
Can you tell me how to do this using the field:
=Fields!custnmbr.Value
Hi all
Basically I had 2 paramater which ComputerName and MemberName.
The membername was set as Multi-Value as sets as follow:
Label: Value:
Exclude Domain Admins Domain Admins
Exclude Local Install Local Install
And the query is:
SELECT id,
ComputerName,
GroupName,
MemberName,
ScanDate
FROM GROUPMEMBERS WITH (NOLOCK)
WHERE ComputerCN LIKE '%' + @ComputerName + '%'
AND MemberName NOT IN (@MemberName)
ORDER BY ComputerName ASC
The prompt is like this:
Computer Name [ ] Excluded by [ ]
The issue is in the second prompt I have to select
"something" which is I don't want to. I want the user to have this parameter as an optional.
Any ideas?
Thanks
Hello,
I have created a DLL and specific translation funtions for my reports.
With these functions i can manipulate all text and numeric data in anyway i want
depending on several user settings (like user language and user local browser settings).
The only textfields i'm not able to manipulate with my functions are the parameter prompts.
Is the a way to manipulate them through custom functions ?
A second question i have. When reports are deployed, they are deployed with there initial file name (file name.rdl).
Is there also a way that i could manipulate the description when they reports are deployed ?
example : when the user's browser is set to english he would see eg: Sales overview
but when the browser language is set to french he would see eg: Résumé des ventes.
Greetings
Vinnie
Hi All,
We have a deployment senarion in which our application server is hosted on one machine and reports are hosted on another machine. If ananymous access is checked in reports server IIS reports are wroking fine from our application. But we have a requirement where we have to remove that ananymous access and use windows athentication. When we uncheck ananymous access and check windows athentication in reports server IIS it is giving not authorized error. Can any one have any idea on this please reply.
Thanks in advance.
Hi,
We have requirement where we need to run the SSRS report from Command Prompt. We are using Control + M, which is a scheduler runs only from DOS prompt.
Can anyone help us to know the procedure of doing this.
Thanks
Karthik
I am working on reports in SSRS 2008 (not R2)... There are some reports with parameters that are hidden when the report is accessed through normal URL using ReportViewer.asx..The thing is that these hidden parameters need to be visible when the report is accessed using SSRS Report Manager.
View 3 Replies View Related
Is it possible to include a text/string as suffix(append to the end of textbox) to an report parameter prompt string ? Something like this
Enter Date: [ Textbox ] format:mm/dd/yyyy
Enter Age:[Textbox ] e.g 50
I need to include text like the one that I have highlighted in blue. Could someone help me out?
Hi,
I would like to call the report from an external source:
The report requires a paramater.
I tried the following:
<a href='http://Report.aspx?ItemTakeOn%2fItemTakeOn&ProcessNo=278'> Report</a>"
The link works & i added the parameter in the link (ProcessNo=278)
it opens the report but i still have to manually insert the Parameter.
Also tried setting the parameter as hidden.
How do i bypass this?
Anyone please Assist!
Regards
Hey
I've got a few questions regarding prompts on the Report builder
Can I change caption of the prompt? I intend to let the users know what kind of prompt that is, if the date they're choosing is a upper limit or a lower limit
How can I create a Between date prompt? I tried using the From..To but it disabled my option to tranform the Filter into a prompt, and from some reason it didn't let me execute report which had After and Before prompts on the same date field (tried it as some sort of work around)
I tried adding fields from a 3rd level table using the report builder, I.E, I drilled down to the 3rd connected table and I was unable to add fields ... any thoughts?
Thanks!
Ron
Hi all
I hope someone can help me on this issue:
I am designing dynamical reports, that are abel to run in four different languages - so far everything works just fine for me (I select my headers and labels from a database). Only problem is the prompt text for report parameters. How can I set this text dynamically?
E.g. I have a parameter where the user selects a storage - this prompt should be "Storage: " in the English report and "Lager: " in the Danish report. I have absolutely no idea how to fix this.
I am greatful for any help.
Hi All,
I have a question regarding how to use report prompts in SSRS reports that are based on SQL queries.
When I added the prompt into the query for use as a filter value, it says that there is an error.
It does not recognise the '!' inside the parameter prompt string. Example is parameter!month_prompt.Value, which the ! is not recognised.
Your help is much appreciated.
Thanks & Regards,
Mohd Fadzli
I need to access a billing webservice from SQL. I createde a new c# class project and made a web refrence to the web service "ProdBilling".
Here is the code of my assembly
using System.Data;
using Microsoft.SqlServer.Server;
using System.Data.SqlTypes;
namespace PaymentProc
{
public class PaymentProc
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void ChargeCard(int account, int amount)
{
string Response;
ProdBilling.Service serv = new ProdBilling.Service();
Response = serv.ChargeCard(account, amount);
SqlContext.Pipe.Send(Response);
}
}
}
I then ran WSDL
wsdl /oaymentProc.cs /naymentProc http://ProdWeb1/PaymentProc/PaymentProc.asmx
Then compliled
csc /target:library PaymentProc.cs
and added the assembly
CREATE ASSEMBLY PaymentProc from 'D:ProdCodePaymentProc.dll' WITH
PERMISSION_SET = UNSAFE
I cannot figure out how to refrence the chargecard method
I have tried
CREATE PROCEDURE PaymentProc
@Account int,
@Amount int
AS
EXTERNAL NAME PaymentProc.[PaymentProc.PaymentProc].ChargeCard
It seems wsdl.exe put all this serialization code
namespace PaymentProc {
using System.Diagnostics;
using System.Web.Services;
using System.ComponentModel;
using System.Web.Services.Protocols;
using System;
using System.Xml.Serialization;
///
[System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "2.0.50727.42")]
[System.Diagnostics.DebuggerStepThroughAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Web.Services.WebServiceBindingAttribute(Name="ServiceSoap", Namespace="http://ProdWeb1/PaymentProc")]
public partial class PaymentProc : System.Web.Services.Protocols.SoapHttpClientProtocol {
private System.Threading.SendOrPostCallback ChargeCardOperationCompleted;
///
public PaymentProc()
{
this.Url = "http://ProdWeb1/PaymentProc/PaymentProc.asmx";
}
///
public event ChargeCardCompletedEventHandler ChargeCardCompleted;
///
[System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://ProdWeb1/PaymentProc/ChargeCard", RequestNamespace="http://ProdWeb1/PaymentProc", ResponseNamespace="http://ProdWeb1/PaymentProc", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
public string ChargeCard(int account, int amount) {
object[] results = this.Invoke("ChargeCard", new object[] {
account,
amount});
return ((string)(results[0]));
}
.................
When I run
CREATE PROCEDURE PaymentProc
@Account int,
@Amount int
AS
EXTERNAL NAME PaymentProc.[PaymentProc.PaymentProc].ChargeCard
I get error
Method, property or field 'ChargeCard' of class 'PaymentProc.PaymentProc' in assembly 'PaymentProc' is not static.
Any ideas? This seemsed so straitforward in the beginning.
Hi all. Here is my problem. Computer A has sql server 2005 express installed on it together with sql management studio. Computer B has only sql management studio. Computers are members of a corporate domain and are running xp professional. After starting management studio on computer B the databese engin on computer A is visible in the 'select server to connect to' dialog under network servers. When i try to connect i get the message login failed - so i try to add a windows athentication login for the appropriate user on computer A. The problem is as follows: Under 'Create new login/Select user or group/location' no network location apear and i can not add a network user name. This seem to be a network connectivity issue. I have, however, adjusted network connectivity via surface area configuration and enabled tcp/ip and named pipes - the server is visible form another computer as i have prviously mentioned.
View 1 Replies View Related
In Report Builder, can you link prompt/filter fields to one another? For instance, I have Users and Groups and I want to dynamically fill the dropdown for Users based on the Group(s) chosen in the group prompt/filter. Or show the hierarchy as a expanding tree list for navigating the hierarchy to choose the user/groups to report on.
Another example would be product category & subcategory in adventure works.
And just to throw in a wrench, one of the areas I want to do this has 4 levels to the hierarchy.
Thanks for the help,
Toni
I have created some reports using Report Builder however they autorun with default values when selected in report manager, cant think many people would want this to happen. Is there a way of getting rid of the default values in RB or preventing auto execute in RM?
View 1 Replies View Relateddoes RS allow a report to be built such that after user runs it, hovering over a particular piece of info could display some variable piece of info similar to tooltips, intellisense etc?
How about a tip to the user if he/she hovers over a parameter prompt?
Is there a way to access cubes via a web service?
Are there any built in web services for doing this in SSAS?
Do I have to have the ADOMD client installed before I can access or use data if it were possible to access it via a web service?
I created a database that will be distributed to my customers. This database is running on an Instance of SQL Server 2005 Express edition. I removed the admin logins from my SQL Server Instance so in theory, only my application connecting itself using the Sql Server autenthication will be able to be access the data (using "sa" having a password that I set at the installation).
For now, all this is working fine and after some tests, I haven't been able to access the data in any ways except by using the "sa" and the password my app is the only one to know.
But the problem is coming from a security leak when using User Instance. Indeed, I've been able to create a program getting the content from my MDF file. If somebody try to get connected using User Instance on his own SQL Server instance, he will be able to reach the data.
How could I prevent this to happend? Is there a property or something that could be set into the database that would prevent the database (mdf file) to be used with User Instance?
Thanks!
Hello all,
I have a peculiar problem. We are using VS-2005,SSRS-2005,SqlServer-2005. Our front end is Windows forms and we are communicating with SSRS through WebServices protocol. Through WebServices we are generating dynamic parameters based on the report and were able to show them on the Win form screen.
The previously entered values are being retained even though we delete the existing one. I am unable to figure out the cause of it.
Please help......
--Deepak
Hi,
i created report and i have to deploy report , at time of deploying it asks report services login credentials.my sql server is windows authentication .it doesn't accept any credentials.how to avoid RS login window at time of deploying report.
Plz help me ASAP
thanks,
...kalyan
I am trying to access the Reporting Services Web Service, but i m not able to make it work. i tried with default credentials and network credentials
ReportingService service = new ReportingService();
service.Credentials = new System.Net.NetworkCredential("username", "password", "domain");
service.CreateSubscription(report, extSettings, description, eventType, matchData, parameters);
This is the exception i getThe current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. ---> The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.
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.Web.Services.Protocols.SoapException: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. ---> The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.
Source Error:
Line 3382: [return: System.Xml.Serialization.XmlElementAttribute("SubscriptionID")]
Line 3383: public string CreateSubscription(string Report, ExtensionSettings ExtensionSettings, string Description, string EventType, string MatchData, ParameterValue[] Parameters) {
Line 3384: object[] results = this.Invoke("CreateSubscription", new object[] {
Line 3385: Report,
Line 3386: ExtensionSettings,
I have two grids in two different pages. In that one grid have more number of columns compared another grid. In this case report takes width of the first grid which has more no of columns. So empty sapce in right side of the report is there for second grid. Based on the grid size reprt width should be there. How to avoid empty space in this?
View 8 Replies View Related