BIDS: Reports With Prompt

Oct 4, 2007



Hi anyone:

I'm actually developing a report with some dates on it. I want that when I run this report, a prompt (a window) appears requesting a date (or at least it could be good if a list appears and I can select one of them). Do you have any idea about how can I do that?.

Thanks in advance,

Pat

View 3 Replies


ADVERTISEMENT

Prompt Password When Calling Certain Reports Only?

Jan 11, 2007

Hi,

When I call certain reports from an ASP application, some prompt for password and some are not.

I wonder why is this happen?

Under the Directory Security of Reports under IIS 6, I already enable Anonymous Access for IUSR_XXXX with the correct password.

I also assign IUSR_XXXX as Browser in Report Manager of Reporting Services.

The enviroment is Windows Server 2003 standard edition, IIS 6, SQL Server 2005.

Thanks in advance.

Best regards,

Pop

View 2 Replies View Related

Deploying Reports From BIDS Ask For Logon

Apr 29, 2008

I have found many references to this issue on the forum, but no solution that works in my case. I believe that I am lacking a fundamental understanding of a security issue so I will attempt to provide as much up front information as possible. I can publish SSRS reports from BIDS to my local computer but when I try and publish the same reports to a production server, I get a login dialog (which I cannot get passed). Here are the particulars. My environment is a home office. I have my computer (which works with the localhost designation) running on a workgroup network (not domain based). My server is another machine on the network (named €śserverone€?). Both machines are running Windows XP Professional. The BIDS project €śDebug€? property page has the TargetServerURL set to http://localhost/ReportServer. The €śProduction€? property page has the TargetServerURL set to http://serverone/ReportServer. I am logged on as an administrator but I cannot publish to the remote server (serverone) from my machine (localhost). I have also tried using the actual TCIP address of the server in place of the serverone name to no avail. I believe that my problem is related to authentication between the two SQL Server 2005 instances running on separate machines on a workgroup based network rather than a domain based network but I cannot find any information that might be useful under these circumstances. Now, here is my workaround (but this seems very wrong). From the logon dialog generated in BIDS, the user ID name was blank. When I attempted to remotely access the Report Manager on the server from my machine, IE tried to logon using the €śserverone/guest€? account. I added an administrator role to the guest account on the server and everything works as expected. As I mentioned before, this seems very wrong. Currently, both machines were set to use the €ślocal system€? account during setup, but I am not even sure what that means. I tried setting the server to use the €śNetwork Service€? account as suggested in one of the forum threads but that did not work. Any help here would be greatly appreciated as I am sure that allowing the €śGuest€? account to have €śAdministrator€? privileges is a bad idea.

View 1 Replies View Related

User Can Not Access Reports From BIDS

Jan 22, 2008

Up to this point only two of use, both server administrators, have developed reports. Now we need to add two new report analysts to be able to develop reports in BIDS but limit their access to other server folders, etc. Our report source code is located at G:Visual Studio 2005 Source CodeProjects and all report folders, sln files, etc. are located under the Projects sub-folder. I have shared the Projects sub-folder and given read & execute / list folder contents / read / write / modify rights. They can see the report folders and sln files via BIDS or Explorer but get "access denied" when they attempt to execute one of them. Any thoughts on what I may be missing?

View 1 Replies View Related

[Reports Builder] Operator * In A Prompt List

Jul 25, 2007

Hi all, when i create a reports deploy on the Report server, i usually choose a filter prompted on Run. The lsit containt for example the list of my customers, but the list in empty like i want (like that, user can put a list from excel by copy-paste). But ... , if the want all the customers, what is the " * " operator to select all my records ?



Thanks for help

Erwan, France

View 1 Replies View Related

Waiting For User Prompt When Running Report Builder Reports

Jan 2, 2007

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 Related

Reporting Services :: Reports In BIDS Does Not Update When Stored Procedure Is Modified

Jan 3, 2014

I am using SQL Server 2008 R2 SP1, and BIDS 2008 SP1. The problem I am about to define does NOT happen when the report is deployed to the report server, but only within the report development environment (BIDS).

From within BIDS my reports are fed by stored procedures. The problem is when I modify a stored procedure in Management Studio, and refresh the report from within BIDS, the report does not reflect the new changes made in the stored procedure. So far I have found one clumsy solution to this problem:

1) Go to the folder where the project is saved on the file system.

2)Find the ".data" file that is associated to the particular report, then delete it.  For instance, if my report name is TestReport.rdl, find the file named TestReport.rdl.data, then delete it.

View 3 Replies View Related

Reporting Services :: Adding Values To Parameters In Dropdown Prompts In Reports In BIDS Or Report Builder

Nov 20, 2015

I run these stored procedure to build the report and I am able successfully to build the report but I need some prompts to in the report to get the specific data .

ALTER
PROCEDURE [dbo].[Sharepoint_Ticket_Report]
@StartDate
DATETIME,
@EndDate

[Code] ....

And for prompts how to create created_by and message_type dropdowns as shown in picture.

View 7 Replies View Related

Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options

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

Reports Usage Frequency For All The Existing Reports On SSRS 2000

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

Reports Usage Frequency For All The Existing Reports On SSRS 2000

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

Remove All Reports ( Not Data Sources) From Reports Server

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

Prompt For Value

Jun 21, 2004

What is the sql code to prompt for a value?

Can I do this in query analyzer or do I have to send the value from some other application?

View 2 Replies View Related

RE : BIDS

Dec 18, 2007

I installed Visual Studio'05 on my sys.
But it has no BIDS in its pop-up menu and also has no BI project templates.
I am trying to build cubes in SSAS.
Can anyone help me out.

Thanks

View 4 Replies View Related

Migration Of SQL Reports 2000 To SQL Reports 2005

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

Converting Crystal Reports To SSRS Reports

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

Copy Reports From Other Users My Reports Folder

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

Prompt In SQL Server 7

Mar 6, 2002

HI,
I have a need where SQL Server should prompt me for a value when I run a Select statement.

Eg:
If I need the name of an employee by id number, SQL server should prompt me to enter a value for the ID when I run the statement like:

SELECT name FROM employee WHERE id=[Enter ID]

In oracle, it is possible by using "&" operator but I am not sure how it can be done in SQL Server. Is there any other way to get the prompts if not by the above method.

Thank you for your help in advance.

Sravan.

View 1 Replies View Related

What's Sql Prompt Tool

Feb 26, 2008

can anyone tell me what's sql prompt tool and how can it help in sql script? it finds error or what?

is it useful? its like visual studio?

thanks. pls reply.

View 2 Replies View Related

SQL Bundle Pro And Sql Prompt

Sep 24, 2007



Hi,

we are using a development environment. what is the cost saving licence to buy sql bundle pro and sql prompt.
Please guide. we have eight programmers , do we need to buy licence for every one, for both the tools, and what is the cost
i saw the link in the internet, but not so clear.

Thanks

View 5 Replies View Related

Parameter Prompt RTL

May 9, 2007

How i can display parameter prompt in other language like arabic

(right to left)



Regard

LPW

View 1 Replies View Related

Licensing For BIDS

Feb 13, 2008

Can we install BIDS client (no server components) on a separate workstation using a download of SQL Server 2005 Developer edition and not require a separate license for the workstation?

Tammy

View 1 Replies View Related

Got BIDS Working, Was There Another Way?

Sep 20, 2006

i re-installed the SQLEXPR_TOOLKIT.EXE several times(4) trying to get the BIDS part to work. Each time i had the issue of it looking for the devenev.exe as others have mentioned. I gave up on a 5th install and went for the unsupported option of running vs_setup , after the toolkit.exe dumped all the install files to its temporary directory i went in there and ran it sperately...but essentially i did it the same way as this method...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368549&SiteID=1

while this did work, it seems to be the unsupported way.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=665067&SiteID=1

Im not opposed to going back and doing it right, but was there ever a conclusion as to why the BIDS program sometimes doesnt install? im using 2k5 express products on this machine...

View 22 Replies View Related

Not Able To Install BIDS

May 2, 2008




Hi all,

I have installed Sql server 2005 enterprise edition with the All the BI services (SSIS,SSAS,SSRS) . when i try to Install the Tools Like BIDS,documentation,sample databses. I am getting the error that foolowing compentes are already installed on the machine though they are not installed

Error message :None of the selected features can be installed or upgraded.Setup cannot Proceed since no effective change
is made to the machine.To continue,Click Back And then select features to install.To Exit SQL Server Setup,click cancel



I have installed vs2008 on my system

Kindly help

View 8 Replies View Related

BIDS Keeps Crashing

Feb 1, 2007

All of a sudden one of my projects/packages seems to have encountered a strange problem. First I tried to remove a data viewer which caused BIDS to crash and tell me that VS has encountered a problem and needs to close. This is repeatable every time I try to remove the data viewer or the link or the transforms or the entire data flow. How do I get around this besides starting from scratch and how do I figure out why this is happening and is there some fix?

thanks

John

View 6 Replies View Related

MDX Disappears In BIDS...

May 9, 2007

I have SQL Server 2005 SP1 installed and none of my datasets will retain the mdx expressions but the report will still run

View 2 Replies View Related

Annoying BIDS Bug

Feb 24, 2008



Well all bugs are annoying, but this one is particularly annoying because it kills the BIDS session with consequent loss of all changes made since the last save.

Click on a control flow task. Position the cursor so that it changes to the 4-way pointer. Drag the task a little bit. The UI locks up, and then BIDS disappears.

I can't repro this on demand, but it has happened about 6 times in the past month. Anyone else seen this one?

View 10 Replies View Related

BIDS Abort

Aug 1, 2007

On several occasions I have experienced crashes while running an SSIS package in debug mode. It happens when I start process on Control Flow table and click on Data Flow tab to monitor progress. I have forwarded the error reports and have searched the boards for similar references. Is this problem going to be fixed?

SSIS Data Sources

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)

Dec 17 2002 14:22:05

Copyright (c) 1988-2003 Microsoft Corporation

Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
----------------------

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)

Mar 23 2007 16:28:52

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Visiual Studio 2005 Professional SP1 SP.050727-7600
.NET Framework 2.0.50727

View 1 Replies View Related

Prompt When New Message Is Submitted

Jul 31, 2006

Hey everyone I dont know if this is the right area to post this but here it goesAn easy expamle of this that everyone is really fimaler with is myspace. When a new database entry is submitted then on the admin page it will say like new message(s).. how can I do this. It doesnt have to be per member. It is only going to be on the admin page.

View 1 Replies View Related

BCP Utility & Command Prompt

Dec 7, 2000

Can anyone tell me how to enable bcp utility. Because anytime I try to run BCP I get the following error messages: (BCP not enable). Also how can I get to SQL Server command prompt? I look forward to hearing from anyone.

View 2 Replies View Related

Running DTS From Dos Prompt.....URGENT!!

Oct 17, 2000

How to run a DTS job from command prompt? Any help is appreciated!
Thanks.

View 2 Replies View Related

Running A DTS Job From Command Prompt

Oct 17, 2000

Sorry for the new thread.
How to run a DTS job from command prompt? Any help is appreciated!
Thanks.

View 1 Replies View Related

XP_CMDSHELL From DOS Prompt And SQL Mail!

Dec 3, 1999

I have a problem like this.

I have a Folder on our NT4.0 server gets filled with different files with extensions(For ex. .bak, .new, .old, etc). These files with those extensions gets build up on a daily basis.

What I am looking for is,
a)I would like to do a count on those files with those extenstion
b)Send an email to the user and their boss if I have letz say more than 15 files of .bak or 15 files of .new files in that folder.
c) Also like to schedule this program to to run every day.

We have SQL Server6.5. Can some one assist me in coding this problem. Thanks
for your time. Roja96@hotmail.com

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved