How To Create A PopUp Report

Sep 6, 2007

Hi Friends,

No I m not looking for a drill down report.

I want a hiperlink on my country sales reports. When user will click on this hiperlink one popup window will open(Popup report). This popup report will contain some input parameter eg list box of sales person name and list of country to be selected select.

One user will select country germany and sales person as Mr Bin and click go on the poup report I want the popup report to be closed and based on the input(country germany and sales person as Mr Bin ) want my country sales reports to get updated.

Hope you undestand my qn.

thanks

Novin

View 7 Replies


ADVERTISEMENT

Urgent: Popup Report And Input Parametrs

Sep 5, 2007

Hi Friends,

I am new-bie to reporting services 2005 and using it from last 1month.

I have interesting problem.

I have to pass some common input parameters to 10 of detail report. I want a popup report having those parameters.

So my detail report will have a link for that popup report once user click a popup window will open(popupreport).
User can select the input parameter and click go on popup report then these parameter will be passed to the detail report.

I thing it is possible using
="javascript:void window.open()"

but i donot exact syntaxt?

Where should I pass in Jump to report ot Jump to Url?

How to achieve this in priview mode?

Pls help me?

Thanks in advance
Novin

View 2 Replies View Related

Can We Generate Reports Without Using Report Viewer And Give A Popup For Saving And Opening It?

Apr 24, 2008

Hi


I am generating a Report by using SSRS. I am making using use of SSRS Report Viewer control for displaying the report. Which has an option to export the generated report in PDF format. Instead of displaying the report in by using report viewer I want to generate it directly in PDF format whenever that report is selected from the list of reports. So is there is any way to generate the report directly in PDF format which prompt a pop up for opening or saving the PDF?


Thanks,
Shailesh

View 3 Replies View Related

Message Box Popup

Feb 3, 2006

Hi,

I'm looking for a way to popup a message from my .asp program for users under the following scenario:

(1) user enters an id number in a field on Page A and clicks on a link.
(2) .asp program runs a query against a bunch of tables and then calls another .asp program which presents the user with the data extracted via the query on Page B.

I'd like to pop up a message box when the user clicks on the link in #(1) above (something like "Retrieving Information...please wait") until the screen #2 with the data is displayed.

I've tried this:

<Script Language="VBScript">
MsgBox "Retrieving Query information...please wait"
</Script>

but the message doesn't pop up until the data has already been retrieved. This is an application that is going away in the next year and a half so, rather than tweak it to see if the query time can be decreased, I'm told I should popup this message.
Thank you,
Jeff

View 3 Replies View Related

Hyperlink As Popup

Jun 21, 2007

Hi,



I'm trying to find a way to put in a hyperlink to a url so the url linked to comes up in a new popup window and leaves the original report visible. Any help greatly appreciated.

View 1 Replies View Related

Popup Window

May 22, 2007

Hi,

In my report, I would like to have the following functionality :

The report will have a table with table header columns. If the user clicks on the header column, a window or text box should show up specifying the rules how that cloumn is calculated.



I can do that through sub-report, but I cannot use subreport, according to our specifications.



Please help me



thanks



View 4 Replies View Related

Popup In Sqlserver?

Apr 1, 2008

Hi,

I have 2 tables with values.
This values are comming second by second by second.

I want to compare this values? In first table i have price column and Second table i have AVG(price) column.
Continously coming this values.

i want compare when price> avg(price), then popup (or) alert should come.

Please help me to findout this.

View 2 Replies View Related

SQL Server Annoying Popup Upon Boot

Apr 28, 2007

I have SQL Server Manager 8.00.2039 installed because I have one program(app) installed that requires it be installed. For the first littlewhile when I had SQL server installed it would only show up in thetaskmanager tray, now MOST of the time, it shows up as a popup on mydesktop and also in my task tray when I first start XP (SP2). It staysthere until I close it. Is there a way to prevent the SQL from poppingup?Thanks

View 3 Replies View Related

How To Supress Popup Window On Export

Feb 21, 2008

Is there any way to supress the popup window on the export option so that the first thing the user see's is the open/save dialog?

Alternatively

Is there a way to make the window close when the open/save dialog appears?

Thanks
Mike

View 7 Replies View Related

SQL 2012 :: Creating A Popup Window From SSAS Actions?

Nov 19, 2014

I have a cube where i would like to define some actions. I have done report Actions but they are limiting in terms of what i am trying to achieve.I want a popup window from the action from relevant cells at the moment i can use the urlaction type to open the link in a new window which is ok but i want this as a popup.

View 0 Replies View Related

Download And Create A Report Project From A Report Server

Jan 9, 2007

Before I start coding ...

Is there any existing software/trick/hack to create a Report Project from the DataSources and Folders/Reports on a Report Server, i.e. the inverse of Deployment?

Would there be anybody interested in such a thing, and, if not, why not?

View 1 Replies View Related

SQL 2012 :: Adding Required Message Popup To SSRS Home Page

Sep 26, 2014

Our Information Assurance (IA) office wants us to add a warning message popup box to our SQL 2012 SSRS server.The purpose is to force users to acknowledge the warning box popup before they get into to the SSRS main page.The message box would contain text stating Privacy Act information and or DoD monitoring consent...

View 1 Replies View Related

Add Login Fails With Popup Beacuse It Connot Determine Is Computer Instancename Is Joined To Domain

Apr 23, 2008



I have a SQL 2005 SP2 fail-over cluster with several named instances. It has been running for sometime with no problems. Recently I had to add a new windows group to a named instance. From Management Studio I brought up the "Login - new " gui hit search to find the group in out doamin and got the following error mesage:

The program cannot open the required dialog box because it cannot determine whether the computer named "<instance_name>" is joined to a domain.

The id I am using is a domain authenticated account and I used this same proceedure to add windows groups in the past. If I ignore the message and type in the group as domaingroup_name I can still add the group and users of that group can log into the instance. The other named instances have the same probelm. There are no errors in the event log or SQL's log. Any ideas on how to get the domain search back would be appriciated.

View 4 Replies View Related

How Can I Create A New Custom Report Item? The Report Item Is Extends Matrix.

Jan 18, 2007

hi everyone

what the matrix's class name ?

where is the matrix's dll?

Can i create a new class extends the matrix?

I want to override the matrix's onpaint method.

Can i do this ?

why the table not have the column group?













View 9 Replies View Related

How To Create This Report?

Feb 12, 2008

I need to create the following report:










Location (City)
YTD Sales Qty for item category code : X
% for Sales Qty YTD compared to Sales Qty YTD previous year
YTD Sales Amount for ALL item categories
% for Sales Amount YTD compared to Sales Amount YTD previous year

I have the following matrix showing the source (OLAP)







X
Y
Z

YTD
PYTD
PYTD
Current Time
YTD
PYTD

Quantity
Amount
Quantity
Amount
Quantity
Amount
Quantity
Amount
Quantity
Amount
Quantity
Amount

New York
12
1000
417
123958
1
100
200
2000
200
2000
2570
242690

Total
12
1000
417
123958
1
100
200
2000
200
2000
2570
242690


The X, Y, Z is the item category dimension. YTD, Current time etc. is a calculated time dimension. (YTD=year to date, PTYD = Previous year to date)

What I need to do is:
1. For the YTD quantity of X, reference the PYTD of X and calculate the % of these two.
2. Sum amount for the YTD amount of ALL (sum X, Y, Z).
3. Equals 1. but then for the YTD amount of all.

Can I do this within one matrix or table? I tried using filters on item category in columngroups but this can not produce a column showing X and a second showing ALL.

I also tried using tables with separate filters but then the row count was different and rows were not matching. Furthermore I didn't manage to reference sums from other tables in a calculation.

Any help would be appreciated!

Tom.

View 1 Replies View Related

How To Create Report Using SSRS2005 And Use Web Ap

Apr 2, 2007

Dear All,
I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2005 as a back End
i want to know how to create report using server 2005 reporting services and use in web application.

please give me some link or example .

Thanks

View 2 Replies View Related

DTS Create Report And Email .

Jun 13, 2007

Hello,

I am trying to create a dts to schedule some reports and email it. The point is that i try to do that through Data Flow > Export to Excel....!!! Is there an other way to create reports?? Cause i don't see any crystal reports or somenthing else!!!


Thanks
Stefanos

View 4 Replies View Related

How To Create A Report Parameter

May 31, 2007

I'm pretty new at this, how the heck do you edit and create parameters? Not really looking to edit code yet, just want to know how to use the interface to do this.

View 4 Replies View Related

Create Report With An ADO Dataset

Aug 23, 2006

Hello,

We are trying to convert our Crystal XI reports to SQL Reporting Services 2005. Our crystal reports get their data from ADO datasets which are populated through code at run time. Is it possible to do this in SQL Reporting Services?

The only options for a dataset seem to be query and stored procedure. When i have a blank dataset it throws an error. When i try to link my dataset to code, it throws an error.

Thanks for your help!

View 7 Replies View Related

How To Create A Report To Be Viewable From A Web Page

Feb 18, 2001

HI, Is there a way to generate a high graphic report to a web page . if so how ?

Thanks
Ali

View 1 Replies View Related

Query To Create View / Report?

Apr 27, 2012

I am running MSFT SQL 2008 with a CRM system. In that CRM system we have defined "COMMUNICATIONS" that have a number of different "TYPES" These communications are tied to Companies, which in our business is a resident of our community. The resident has the ability to request a 1 time service (TRAVEL) that would be recorded with one "COMMUNICATION" , or a reoccuring service (DAILY CARE) that would be recorded with two "COMMUNICATIONS" (Start/Stop). THe communication ID does appear to be sequential, but may not be entered sequentially.

we would like to be able to create a timeline for a specific resident around 3 specific types of transactions. (AWAY, RETURN, CS) There should be some strong predictive value to these data points.

ABSENCES
AWAY = Start of an absence from the building
RETURN = End of an absence from the building
A person during their reisdency will have multiple Absences
An absence could start on the same day a previous absence ends
Absences vary in length
CS
CS0-CS10 (each is a different TYPE) of communicatio

[code]....

Query in DESIGN View

SELECT TOP 100 PERCENT comm_trantype AS Type, comm_trandate AS Date, CmLi_Comm_CompanyID AS CompID, Comm_CommunicationId AS CommID, ROW_NUMBER()
OVER (PARTITION BY CmLi_Comm_CompanyID
ORDER BY Comm_CommunicationId, comm_trandate) AS Seq
FROM CRM_CSLDB.dbo.vCommunication

[code]....

Results from QUERY in DESIGN VIEW

TYPE DATECOMPIDCOMMIDSEQ
AWAY2011-02-24 00:00:00.00051747531
RETURN2011-03-31 00:00:00.00051747542
AWAY2011-03-28 00:00:00.00064740681
RETURN2011-04-30 00:00:00.00064752972

[code]....

RESULTS FROM QUERY in SELECT TOP 11

TypeDateCompIDCommIDSeqAwayDaysReturnDate
AWAY2011-06-20 00:00:00.00016977564182011-06-28 00:00:00.000
AWAY2011-12-23 00:00:00.00015059050441122012-04-13 00:00:00.000
AWAY2011-10-09 00:00:00.0003534839461162011-10-25 00:00:00.000
AWAY2012-01-27 00:00:00.0003983890363942012-04-30 00:00:00.000
AWAY2012-03-09 00:00:00.0004064900615202012-03-29 00:00:00.000

[code]....

QUERY in DESIGN VIEW

SELECT TOP (100) PERCENT dbo.vCommunication.comm_trantype AS csTrans, dbo.vCommunication.comm_trandate AS csTranDate,
dbo.vCommunication.CmLi_Comm_CompanyID AS CompanyID, dbo.vCommunication.Comm_CommunicationId AS Comm_ID, dbo.CSL_resident.Name,
Comm_CommunicationId AS CommID, ROW_NUMBER() OVER (PARTITION BY CmLi_Comm_CompanyID
ORDER BY Comm_CommunicationId, comm_trandate) AS Seq
FROM dbo.vCommunication INNER JOIN

[Code] .....

QUERY RESULTS IN SELECT

csTranscsTranDateCompanyIDComm_IDNameCommIDSeq
CS12009-07-27 00:00:00.0001176147Harrison Bailey 761471
CS32007-08-27 00:00:00.0002673777Dorothy Wheeler 737771
CS42011-12-02 00:00:00.0002685087Dorothy Wheeler 850872
CS52012-01-01 00:00:00.0002685446Dorothy Wheeler 854463

[Code] ....

View 12 Replies View Related

Create A Report Showing Title First And Last Name

Sep 9, 2015

I need to create a report showing the title the first and last name of all sales representatives-This is what I have so far but am having difficulty retrieving ONLY the "Sales Representatives" Titles.

Select Firstname, Lastname, Title
From Employees
Where ???

View 6 Replies View Related

How To Create A Report Using Multiple Databases

Jan 31, 2007

Hi, I am a beginner of Reporting Service. I am trying to create a report using multiple databses. For example, I want to create a report called RevenueByCustomer, so I need to get data from the Customer Table of CRM database, which contains customer information, and I also need to get data from Transaction table of Sales database, which contains all the revenue information. In order to get data from both database, I have created two dataset. One is Customer dataset, which get all required customer data from CRM database, and the other is Revenue dataset, which gets data from Sales database, they used seperate datasource (because each datasource only contains one database connection). Now my problem is how can I make them be displayed in one report ? It seems to be like a Master-Detail report, I need to sum up all trasactions for a particular customer and also need to display the customer name with each TotalAmount, but how can I make these two dataset can be merged together or used an extra query to do it?

Please help me, thanks a lot

This Query below is used to calculate the total amount for each customer in Revenue dataset:

SELECT CustomerID, sum(TotalAmount - TotalTaxAmount) AS TotalExcTax, sum(TotalAmount) AS TotalIncTax
FROM TransactionMaster
WHERE (Updated >= @Start) AND (Updated <= @End)
Group By CustomerID

the other one here is used to get customer code and name in Customer dataset:

SELECT ID, Code, Name
FROM Customer

View 10 Replies View Related

Create Linked Report Method

Jul 19, 2007

Does anyone have a sample of a CreateLinkedReport method they are using? I am using Reporting Services 2005 and Visual Basic 2005. I need the VB code and how I need to call it. I'd like to change one parameter, and then send it to select recipients using a specified schedule.



Thanks, Iris

View 2 Replies View Related

Create Report Snapshot From SSIS

Mar 7, 2006

I need to create a SSRS report snapshot at the end of an SSIS package (seems like this would be a common task). I tried connecting to the ReportingService web service to do this but I get the following error when after I select the web service in the Web Service Task:

This version of the Web Services Description Language (WSDL) is not supported.

Is there as simple way to do what I want?

View 4 Replies View Related

Programmatically Create A Report Model

Jul 14, 2007

Hello,

What we'd like to do is programmatically generate and maintain a report model based on how the individual install is configured. I've found some documentation that makes me believe this is possible, but I'm hoping someone can nudge me in the right direction. The ReportingServices2005 class has several model related methods (CreateModel) and I found the .xsd for the semantic model XML file
(http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
but no real documentation on how to put together a Report Model document from scratch. Looking at the files generated from BIDS is somewhat overwhelming and I have no idea where I'd pull most of the information.


Finally, I want to create Report Model(.smdl) file without Report Model Designer.

I want to Implement CreateModel Method to create new model, any source code sample..??


Any help that can be provided would be greatly appreciated. Thanks!


Sandip.

View 4 Replies View Related

How To Create A Report Against A Stored Procedure

Nov 14, 2007

Using sql server reporting services, I want to create a report against a stored proc which has input parameters to the stored proc. Thanks!

View 5 Replies View Related

How To Create A Report Using Multiple Databases

Jan 31, 2007

I have two database:

FoxPro database - contains client info (name, address)

SQL Server database - contains appointmetns, orders, jobs etc.

How can I create reports using both databases?

Thank you

View 3 Replies View Related

Create An Email Link Within The Report...

Jan 23, 2007

Hello...

I have a column of data on my report that contains an email address. Is it possible to format this so that the person running the report can just click on the link and have that action launch their email program...like Outlook?

thanks for any help

- will

View 3 Replies View Related

How To Create Report Parameter Programmatically?

Dec 30, 2006

Hi,



I'm working on custom report manager. It manages "report entities" and
"report templates" (actually, RDLs uploaded on the server) and stores
one-to-many relation between them. The task is to store
"MasterEntityID" report parameter in every RDL and keep it up in actual
state whether RDL is being assigned to another entity or new RDL is
being uploaded and assigned. I've covered the first issue with
SetReportParameters() web method, but how should I deal with the second
one? Uploaded RDL may be short of the param, so I have to add it
programmatically while uploading.



Thanks,

Anatoly

View 6 Replies View Related

Can We Create Shared Report Parametres?

Apr 16, 2007

Hi, all experts here,

Is it possible to create shared report parametres passing among different reports on SQL Server 2005 Reporting Services? If it is possible, and how?

Thanks a lot in advance for your advices. And I am looking forward to hearing from you.

With best regards,

Yours sincerely,

View 1 Replies View Related

Can't Create Report Model For Teradata?

May 5, 2008

Hello!

I've created a data source that uses the OLE DB Provider for Teradata to connect to an existing Teradata database. Works fine.

I then use this data source within my project to create a Data Source View. Again, all works well.

However, the final step - creating a Report Model, bombs out in the wizard at the Completing the Wizard step with the following error: "[NCR][Teradata Database] Syntax error, expected something like a name between the 'SET' keyword and the 'TRANSACTION' keyword." (I elected for the wizard to only create entities for all tables, and create attributes).

If I try to create a Model manually, I get the following error when trying to build: "The Entity '<EntityName>' does not have any IdentifyingAttributes. Entity must have at least one IdentifyingAttribute."

Still fairly new to SSRS, so I'm hoping the issue is just a loose nut behind the keyboard Does anyone know what I'm doing wrong in trying to set this up?

Thanks in advance!

View 1 Replies View Related

Can I Create Dynamic Report Parameters?

Apr 4, 2007

Hi all,

Is it possible to create a report with dynamic parameters or parameters dependant on other ones? I have the following scenario -



Parameter 1 - 'Select an Application' - List of applications that are available

Parameter 2 - 'Select a module' - This is a list of modules that needs to depend on Parameter 1. As a user selects different applications, the appropriate module list will be loaded.

Is this possible to do in SSRS?



Thanks,

Brian

View 3 Replies View Related







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