Click Button?

Oct 15, 2007



Hi everyone, Im using SSRS 2000 and I was wondering is there a way to create a click button??? I have 2 reports linked with hyperlinks but I wanted to make it look more presentable. So, instead of just clicking on the words, I want them to click the button.

Thanks in advance,

Abner

View 3 Replies


ADVERTISEMENT

SQL && C# Help On A Button Click!!!

Mar 7, 2008

Hey Guys,
I'm not sure if anyone can help me with this but I am trying to achieve the following:
I have a row (In this case it is information on a fix) and on a button click I am trying to get it to "archive" it.  At the moment I have it so that it it takes the current information and adds it to the archive table adding an archive date.  The thing that I am struggling with is incrementing the version number. So, I need it to (in these steps I think) - Look for existance of the other entires of that ID, look for the version number that is related to the newest date of those knowledgeIDs and then add 1 to it.  If that knowledgeID doesnt exist then add it as one.
My current code is below:
Thanks in Advance =)
C# Codeprotected void Page_Load(object sender, EventArgs e)
{UserName = (string)Session["UserName"];
Label4.Text = UserName + " Is Current Logged In";UserType = (string)Session["UserType"];if ((Session["UserName"] != null) & (UserType == "Helpdesk"))
{Response.Redirect("Accessrights.aspx");
}else if (Session["UserName"] == null)
{Response.Redirect("Login.aspx");
}
FixName = "default";Description = "default";File = "default";
ADate = myCalendar.TodaysDate.ToShortDateString();
AddDate = Convert.ToDateTime(ADate);myConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\inetpub\wwwroot\HOF\App_Data\HOF.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;";
}protected void Button1_Click(object sender, EventArgs e)
{SqlConnection myConnection = new SqlConnection(myConnectionString);
try
{
FixName = TextBox1.Text;
 SqlCommand myCommand = new SqlCommand("select * from Knowledge WHERE FixName like '%" + FixName + "%'", myConnection);
myConnection.Open();SqlDataReader myReader = myCommand.ExecuteReader();if (myReader.HasRows)
{while (myReader.Read())
{
TextBox1.Text = myReader["FixName"].ToString();TextBox2.Text = myReader["Description"].ToString();
File = myReader["Location"].ToString();if (File != null)
{
TextBox3.Text = File;
}
else
{TextBox3.Text = "There is no script avaliable";
}KnowledgeID = myReader["KnowledgeID"].ToString();Add = myReader["DateAdded"].ToString();
}
myConnection.Close();
}
else
{TextBox1.Text = FixName + "Does not Exist. Please try again.";
}
}catch (Exception ex)
{
myConnection.Close();
}
try
Description = TextBox2.Text;File = Convert.ToString(FileUpload1.FileName);if (CheckBox1.Checked == true)
{SAPPS = "True";
}
else
{SAPPS = "False";
}
{SqlCommand mycommand2 = new SqlCommand("INSERT INTO Knowledge (FixName, Description, Location, DateAdded, DateArchived, Version, KnowledgeID) SET ('" + FixName + "','" + Description + "','" + File + "','" + Add + "','"+AddDate+"','" + SAPPS + "','"+I NEED A VALUE HERE+"','"+KnowledgeID+"')", myConnection);SqlDataAdapter myDataAdapter = new SqlDataAdapter(mycommand2);
sa = mycommand.ExecuteNonQuery();
myConnection.Close();
}catch (Exception ex)
{
myConnection.Close();
}
}
 

View 2 Replies View Related

Executing SQL With A Button Click.

Dec 25, 2007

I feel like it must be easy and I'm missing something.  Maybe I'm going the wrong way about it too.  Basically I've written an append query that needs parameters, but I have no idea how to actually execute it.  I'm coming from building apps in MS Access where all of this is really easy.  I'm really enjoying learning some things, and did my first MS SQL trigger event tonight, which worked great.  I though using a trigger may be an option here, but I need to control the "when" of this append a little more carefully and can't rely on an automated event. I can manually execute the query and it works, but have a button I could press on a form, with the queries on that form would be ideal.  I'm basically moving partial data from one table to another. Any help?  Again, this seems like it "should" be easy, but I'm not finding info on it.  Please talk slowly, as again, I'm coming from Access. 

View 5 Replies View Related

Search In Button Click

Jun 29, 2007

i have to search through differene controls (textboxes,dropdownlist,checkboxes,radiobutton) in an Asp.Net page usingC#.

can anybody tell me how to write the code of searching in button_click.

using dynamic query or stored procedure.



all replies are welcome.

Thanx in advance.

View 3 Replies View Related

How To Execute A Selectcommand On Button Click?

Jan 9, 2007

Hello friends
Can anyone tell me the means by which I can populate a label or a datagrid by executing a selectcommand statement on the form of my webpage. And what is the best way to retrieve data from a SQL datasource, is it by using separate sqldatasources for each different parts of a page that requires different data from different tables in the same database or by using a tableadapter to retrieve the data for the best performance?
Thanks for replying for my previous questions. It was helpful and great in my program implementation.
Thank you

View 1 Replies View Related

Binding A Gridview To Sqldatasource On Button Click

Mar 3, 2008

 i am using 2 textbox to search name and instituition of some students. on button click  need to display the result on gridview. but i dont get any result.. pl adviceSqlDataSource1.SelectCommand = "SELECT Sname, Address, Instituition, Role, Testgroup, Email FROM std_det WHERE (Sname LIKE '%'+@Param1+'%') AND (Instituition = 'RASET') AND (Role LIKE '%'+@Param2+'%') AND (Instituition = 'RASET')";            name.ControlID = "TextBox3";            name.DefaultValue = "%";            name.Name = "Param1";            name.PropertyName = "Text";            inst.ControlID = "TextBox4";            inst.DefaultValue = "%";            inst.Name = "Param2";            inst.PropertyName = "Text";            //SqlDataSource1.Select(DataSourceSelectArguments.Empty);            SqlDataSource1.SelectParameters.Add(name);            SqlDataSource1.SelectParameters.Add(inst);            SqlDataSource1.DataBind();            //DataView dv = (DataView)this.SqlDataSource1.Select(DataSourceSelectArguments.Empty);            GridView2.DataSourceID = "SqlDataSource1";                        GridView2.DataBind();

View 2 Replies View Related

Running A MS SQL Stored Procedure On Button Click

Mar 14, 2008

I am new to ASP.NET so please excuse what may seem like a dumb question.
I have a stored procedure that I need to run when the user clicks on our submit button.  I am using Visual Studio 2005 and thought I could use the SqlDataSOurce Control.  IS it possible to us the control or do I need to create a connection and call the stored procedure in the the button_click sub?
Thanks in advance
MF

View 6 Replies View Related

2nd INSERT INTO Statement In A Button Click Event

Mar 6, 2006

Hi everyone.I am trying to write 2 INSERT INTO statements into a Button click event. Both statements go to the same database but differnet tables. The first statement works fine but the 2nd causes an error with the Try, Catch, Finally statement. When I remove the ExecuteNonQuery from the 2nd statement, the 2nd INSERT INTO statement fails to work. Any help would be brilliant. Thanks!
Private Sub btnInsertChange_Click(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs) Handles btnInsertChange.Command
        'Insert Guide changes into ChangesReport table in sql server        Me.SqlCommandThemeTest.Connection = Me.SqlConnection1
        Dim Name As String        Dim values As String        Dim sSQL As String        Name = "Theme, Guide, GuidePage, PageType, ChangeCategory, ChangeFrom, ChangeFromText, ChangeTo, ChangeToText ContentManager"        values = "lstTheme, lstGuideName, lstGuidePage, lstPageType, lstChangeCategory, lstChangeFrom, txtChangeFrom, lstChangeTo, txtChangeTo, Label1"        SqlCommandThemeTest.CommandText = "INSERT INTO dbo.ChangesReport (Theme, Guide, GuidePage, PageType, ChangeCategory, ChangeFrom, ChangeFromText, ChangeTo, ChangeToText, ContentManager) VALUES (@themeValue, @guideValue, @guidepageValue, @pagetypeValue, @changecategoryValue, @changefromValue, @changefromtextValue, @changetoValue, @changetotextValue, @contentmanagerValue)"
        SqlCommandThemeTest.Parameters.Add("@themeValue", lstTheme.SelectedItem.Text)        SqlCommandThemeTest.Parameters.Add("@guideValue", lstGuideName.SelectedItem.Text)        SqlCommandThemeTest.Parameters.Add("@guidepageValue", lstGuidePage.SelectedItem.Text)        SqlCommandThemeTest.Parameters.Add("@pagetypeValue", lstPageType.SelectedItem.Text)        SqlCommandThemeTest.Parameters.Add("@changecategoryValue", lstChangeCategory.SelectedItem.Text)        SqlCommandThemeTest.Parameters.Add("@changefromValue", lstChangeFrom.SelectedItem.Text)        SqlCommandThemeTest.Parameters.Add("@changefromtextValue", txtChangeFrom.Text)        SqlCommandThemeTest.Parameters.Add("@changetoValue", lstChangeTo.SelectedItem.Text)        SqlCommandThemeTest.Parameters.Add("@changetotextValue", txtChangeTo.Text)        SqlCommandThemeTest.Parameters.Add("@contentmanagerValue", Label1.Text)
        Try            Me.SqlConnection1.Open()            Me.SqlCommandThemeTest.ExecuteNonQuery()        Catch ex As Exception            Response.Write(ex.ToString)        Finally            Me.SqlConnection1.Close()        End Try
        'Insert textbox to ChangeLogFrom ddl        Me.CmdDDLFromUpdate.Connection = Me.SqlConnection1
        Name = "ChangeFromText"        values = "txtChangeFrom"        sSQL = "INSERT INTO dbo.Change Log From (ChangeLogFrom) VALUES (@changelogfromValue)"        Me.CmdDDLFromUpdate.Parameters.Add("@changelogfromValue", txtChangeFrom.Text)
Try            Me.SqlConnection1.Open()            Me.CmdDDLFromUpdate.ExecuteNonQuery()        Catch ex As Exception            Response.Write(ex.ToString)        Finally            Me.SqlConnection1.Close()        End Try

View 3 Replies View Related

Machine Restart On Print Button Click

Jan 28, 2008

i am using Asp.net , C# , sql server 2005.
i made one rdl report and called it from server (win2003). it worked successfully . but when i give print for the same report(through reportviewer control print option). Client machine restart. Same thing happened on four machine that were in win2000.

Please guide me.

View 2 Replies View Related

Creating Graphs In Access On A Click Of A Button

Aug 3, 2006

I need to create graphs in access in a lick of a button all the data will be in the sql transfered from the access.

If anybody did this before ar having Idea please let me know

View 4 Replies View Related

What To Get The Confirm Msg On Button Click Event Stored Data...

Apr 1, 2007

How can i confirm that the data entered within the standard controls and after the click event for the particular sql query the data is been stored in the database tables (depending insert,update,delete).I want to display the different messages on the click event and that after the changes made into the tables.How can i do it ?? I m using ASP.Net with C#,VB and the sql server to store data.I also want to know where are the database tables exactly get stored which are made in the Microsoft SQL Server Management Studio Express.I want to use as the existing item in .Net but could not find.. Thanxs... 

View 2 Replies View Related

Running Multiple Commands On Single Button Click

Feb 21, 2008

I have a form that contains data that some of which needs to be inserted into one table and the rest updated to another table. I want this to happen on a single button click. Is this possible?Here's what I have so far:            String id = parm_tb_tktid.Text;            String update = parm_tb_desc.Text;            String status = parm_cb_status.Text;                     SqlCommand cmd = new SqlCommand("Insert into History (tkt_id, hist_desc) values(@parm_tb_tktid, @parm_tb_desc)", HelpdeskConnectionString);            cmd.CommandType = CommandType.Text;            cmd.Parameters.AddWithValue("@parm_tb_tktid", id);            cmd.Parameters.AddWithValue("@parm_tb_desc", update);                        SqlCommand cmd1 = new SqlCommand("Update Ticket (tkt_status) values(@parm_cb_status) where tkt_id = @parm_tb_tktid)", HelpdeskConnectionString);            cmd1.CommandType = CommandType.Text;            cmd1.Parameters.AddWithValue("@parm_cb_status", status);            HelpdeskConnectionString.Open();            cmd.ExecuteNonQuery();            cmd1.ExecuteNonQuery();            HelpdeskConnectionString.Close();            parm_tb_tktid.Text = String.Empty;            parm_tb_desc.Text = String.Empty;            parm_cb_status.Text = String.Empty;I know it isn't right, but I can't find any info on why it's wrong and how to code it properly.  

View 9 Replies View Related

How To: Send Time To Database Table On Button Click

Mar 21, 2008

Hello, I need to know how I can make a button on my page send the Time of Click, to a table in a database, and repeat this everytime the button is clicked. Thanks for any guidance on this matter 

View 9 Replies View Related

Running An SSIS Package After A Webpage Button Click

Jun 12, 2007

Hi all!
I'm a newbie when it comes to SSIS and web development (I'm currently in school for Mechanical Engineering). I'm trying to develop a website in which I can upload an excel file and have the contents written to a SQL database. I have been successful in creating a package in which I point to an excel file and it writes the contents to the desired database. With this, I was hoping that I can modify my website to take the file which is being uploaded, change the name, and then have the SSIS package run, in which it will look for the named file in a certain directory and upload the contents to the SQL server.

Ideally this would be the order of events:

User selects and uploads a file to the server (button click)
Server renames it and places it in a certain directory
SSIS package runs and extracts the data to SQL database


Thanks all!
Shrey

View 5 Replies View Related

Button Click Event Fires While Refresing The Page

Aug 9, 2007

Hi!

I have written some code to insert a record into the table in BtnAdd click event and I also have a Grid view control to show the table records.

If I click the Add button ,the record gets inserted into the table and shown in the grid correspondingly.But if I refresh teh page,the same data gets inserted again since it fires the Btnclick Event.

Please help me out in this issue.
Thanks

View 1 Replies View Related

Why Is This SQL UPDATE Query Not Updating When This Code Is Used Under Button.click.

Mar 20, 2008

Why is this SQL UPDATE query not updating when this code is used under button.click.

Dim ListingID As String = Request.QueryString("id").ToString
Dim sqlupdate As String = "UPDATE Listings SET PlaceName = '" & PlaceName.Text & "', Location = '" & Location.SelectedValue & "', PropertyType = '" & PropertyType.SelectedValue & "', Description = '" & Description.Text & "', Price = '" & Price.Text & "' WHERE ListingID ='" & ListingID & "'"
Dim con As New SqlConnection(ListingConnection)
Dim cmd As New SqlCommand(sqlupdate, con)
con.Open()
cmd.ExecuteNonQuery()
con.Close()

View 12 Replies View Related

Recovery :: Adding Second Replica To 2012 AG / Cannot Click Next Button

Oct 21, 2015

Trying to add a second replica to my SQL 2012 AG. for some reason i cant click the next button.

View 3 Replies View Related

Theres A Syntax Error When I Click On Login Button After Writng The Codes

Feb 1, 2008

 the line in bold..can sumone tell me how to correct the error , it say syntax error beside "="
Imports System.Data
Imports System.Data.SqlClient

Partial Class Default3
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub btnlogin_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnlogin.Click
        Dim conn As New SqlConnection _
                      
("data source =YOUR-KEGKZI6IFCSQLEXPRESS; integrated security=true;"
& _
                      
"initial catalog=LOGINPAGE")
        conn.Open()

        Dim cmdLogin As New
SqlCommand("select * from UserName where ='" & txtusername.Text
& "' and Password='" & txtpassword.Text & "'", conn)
        Dim dr As SqlDataReader
        dr =cmdLogin.ExecuteReader()


        If dr.Read() Then

            Response.Redirect("Galery.aspx")
        Else
            Response.Redirect("homepage.aspx")

        End If

View 1 Replies View Related

System Restarts On Click Of The Print Button While Viewing Reports In The Browser

Apr 17, 2007

We are using Reporting Services 2000.

The print button that is present in the browser is working just fine for some users.



But some users are complaining that on clicking the print button their system restarts.



Some other users are also getting the error "An error occurred during printing. (0x80004005)"

However on closing the browser and opening the report in it again this issue is resolved.



So, the main concern is "Restart of the machine on click of the PRINT icon in reports viewed in some application browser."



Please help!!

View 2 Replies View Related

Sqlcommand And Visual Studio Net 2003 Code To Update A Record With A Click Of Button.

Sep 1, 2006

Hello to everyone,  I have this problem If I use this code when I try to update a record in my sql database It does not do anything. This is the code.  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click        Dim myconn As New SqlConnection("Data Source=.;Initial Catalog=SistemaIntegral; user id=sa")        Dim mycmd As New SqlCommand("presup", myconn)        mycmd.CommandType = CommandType.StoredProceduremycmd.parameters.Add(New SqlParameters("@txtClave", SqlDbtype.int,4)).Value=txtClave.textmycmd.parameters.Add(New SqlParameters("@txtForig", SqlDbtype.varchar,50)).Value=txtFOrig.textmycmd.parameters.Add(New SqlParameters("@txtFmod", SqlDbtype.varchar,50)).Value=txtFmod.textmycmd.parameters.Add(New SqlParameters("@txtFeje", SqlDbtype.varchar,50)).Value=txtFeje.textmycmd.parameters.Add(New SqlParameters("@txtPorig", SqlDbtype.varchar,50)).Value=txtPorig.textmycmd.parameters.Add(New SqlParameters("@txPmod", SqlDbtype.varchar,50)).Value=txtPmod.textmycmd.parameters.Add(New SqlParameters("@txtPeje", SqlDbtype.varchar,50)).Value=txtPeje.text mycmd.parameters.Add(New SqlParameters("@txtClave", SqlDbtype.int,4)).Value=txtClave.text        myconn.Open()        mycmd.ExecuteNonQuery()        myconn.Close()        mycmd.Dispose()        myconn.Dispose()    End Sub  This is the code for the procedure called "presup" in SQL 2000 Server.CREATE PROCEDURE [presup](@txtClave [int],@txtForig [varchar](50),@txtFmod [varchar](50),@txtFeje [varchar](50),@txtPorig [varchar](50),@txtPmod [varchar](50),@txtPeje [varchar](50),@txtIdPresupuesto [int])as Update [Presupuesto]Set [IdClave]=@txtClave,[orig]=@txtForig,[moda]=@txtFmod,[ejer]=@txtFEje,[origr]=@txtPorig,[modar]=@txtPmod,[ejerr]=@txtPejeWhere ([IdPresupuesto]=@txtIdPresupuesto)GO When I click the Update button of my webform it does not do anything. Please Help me I am new to Visual Studio.Net 2003. (2 weeks ago I started using Visual Studio) 

View 1 Replies View Related

Error: Button Click Is Undefined - Simple If Statement With Sql Command Wont Work (c#)

Feb 2, 2008

hello it seems lack of c# skills is getting the better of me here...iv been trying to get this to work for hours now without success. I have just started working in c# so i am a beginner :)
all i want to do it query the database, check to see if a title exists, if yes then populate textbox saying 'title in use' but if the title doesnt exists then continue executing rest of code to add the title.
You'll notice iv tried to use string variables and sqlDataAdapter but i cant get these to work either...please help
so far i have this that keeps giving me the error that my button click is undefined: protected void bookButton_Click(object sender, EventArgs e){
//string title;try{SqlConnection conn1 = new SqlConnection();
conn1.ConnectionString =
"Data Source=Gemma-PC\SQLEXPRESS;" +"Initial Catalog=SoSym;" +
"Integrated Security=SSPI;";SqlCommand findTitle = new SqlCommand("SELECT title FROM Publication WHERE title='" + titleTextBox.Text + "';", conn1);
 
conn1.Open();
findTitle.ExecuteNonQuery();
 /*
DataSet myDataSetTitle = new DataSet("PublicationTitle");
myDataSetTitle.Clear();
myDataAdapterTitle.Fill(myDataSetTitle);//myDataSet contains results from above SELECT statement
title = myDataSetTitle.Tables[0].Rows[0]["title"].ToString();*/
}catch(Exception ex)
{TitleInvalidMessage.Text = "Title Not Accepted: This title is already in use by another publication" +ex.Message;
}
//title does not exist in table so continue and add to database
//rest of code here

View 5 Replies View Related

Reporting Services :: Cannot Click Restore Button In RS Configuration Manager To Restore Encryption Key

Oct 29, 2015

While migrating Report services in SQL Server 2005 to 2014, I am trying to restore the Encryption Key in RS Configuration Manager in2014. But I cannot click the 'Restore' button in RS Configuration Manager. So if I should be grant more right to do so or any other action?

View 2 Replies View Related

SQL Server 2008 :: Click On ADD Button To Connect To Secondary Server

Feb 27, 2015

I am configuring log shipping. On the secondary server, I already restored the DB.From the primary server, I was following all the instructions on how to. Now this is the problem. I click on ADD button to connect to the secondary server. I put in the IPInstanceName and the DB. I also chose option 3 (No, the secondary database is initialized), clicked OK after all the option, now getting this error.

View 9 Replies View Related

Double Click On The View Report Button To Get The Report To Render.

Jul 26, 2007

I've got a SQL Reporting Server 2000 SP2 report that takes 3 parameters. FromDT, ToDT, and LocationCD. The first two parameters are free form text fields that expect a date. The last one is a drop down box. For some reason, when I'm viewing the report through the standard reports folder on the report server I have to click the "View Report" button two times to get the report to render. Clicking it just once, doesn't seem to do anything. The report is a line graph.

There are default values in the FromDT and ToDT parameter fields.

Anyone have any ideas what would be causing the need for the second click?

View 2 Replies View Related

Right-click Db Properties EM Goes Bye Bye

Jan 11, 2005

Running SQL2000 SP3.

We installed an application named Streamserve. Now, if I go into Enterprise Manager I can expand the databases fine. But when I try to right-click properties Enterprise Manager goes bye bye. No error messages. I tried this on master and same thing. I currently have 2 different machines - a dev and a QA box and both are behaving badly.

Any ideas?

Thanks
Sharon

View 4 Replies View Related

Point And Click DTS

Mar 19, 2007

i have a DTS Package a saved when i set up the package. it's in local packages in Enterprise Manager now. is there any way i can simply set up a shortcut on my desktop to execute that DTS, rather then having to nav though Enterprise Manager?

yeah, i know i'm lazy :o)

View 2 Replies View Related

SQL Update On Click Event

Mar 7, 2008

My database isn't getting updated. You see any problem with this code?
 string strConnection = ConfigurationManager.ConnectionStrings["ShippingConnectionString"].ConnectionString;
SqlConnection myConnection = new SqlConnection(strConnection);String updateCmd = "UPDATE [response] SET [sitename]=@sitename, [sitephone]=@sitephone, [siteemail]=@siteemail, [siteaddress]=@siteaddress, [cra_name]=@cra_name WHERE [responseID]=@responseID";
SqlCommand myCommand = new SqlCommand(updateCmd, myConnection);myCommand.Parameters.Add(new SqlParameter("@sitename", SqlDbType.VarChar, 50));
myCommand.Parameters["@sitename"].Value = txtSiteName.Text;myCommand.Parameters.Add(new SqlParameter("@sitephone", SqlDbType.VarChar, 50));
myCommand.Parameters["@sitephone"].Value = txtPhone.Text;myCommand.Parameters.Add(new SqlParameter("@siteemail", SqlDbType.VarChar, 50));
myCommand.Parameters["@siteemail"].Value = txtEmail.Text;myCommand.Parameters.Add(new SqlParameter("@siteaddress", SqlDbType.VarChar, 1000));
myCommand.Parameters["@siteaddress"].Value = txtAddress.Text.ToString();myCommand.Parameters.Add(new SqlParameter("@cra_name", SqlDbType.VarChar, 50));
myCommand.Parameters["@cra_name"].Value = txtCRA.Text;myCommand.Parameters.Add(new SqlParameter("@responseID", SqlDbType.Int));
myCommand.Parameters["@responseID"].Value = Convert.ToInt32(hiddenID.Value);
try
{
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
}catch (SqlException test)
{
//Response.Redirect("~/error.aspx");
Response.Write(test.Message.ToString());
}
finally
{
myCommand.Connection.Close();
}

View 3 Replies View Related

Performance Experts Click Here

Jul 28, 1999

Scenario..

Table 1 = Product (one row per productID, also has second key, KEY2)
Table 2 = Usage (many rows per KEY2)

I have a view that aggregates Usage GROUP BY Key2 - Usage_VIEW

I create a view over Product and Usave_view joining on KEY2 - Final_VIEW

When I query Product with a where Product = 'x'
the time is under 1 second return.
I then take the Key2 value returned and query my Usage_View
the time is under 1 second to return.

BUT, if I query My Final_VIEW with where product = 'x'
I can take a coffee break.

Question? Does the aggregate of Usage get performed before limiting to the matching rows in Product?

Can I use "Force Order" hint to make the first table limit the search on table 2? If so, please give syntax on FORCE ORDER. I can't seem to figure it out.

View 2 Replies View Related

Click Through Report Parameter

Aug 27, 2007

Hi there.

I am having a problem where I have a Summary Report for a Region that lists out data for each community in that region (sample below):








West Region
Count

Community 1
N/A

Community 2
14

Community 3
41

Community 4
25

Community 5
38

Community 6
67

Community 7
40

Community 8
52

I have navigation setup such that when I click on a Community (like Community_1 above), the detailed community report is called. I am passing CommunityID as a parameter to the community report. The community report has a CommunityID (literally) parameter setup. This seems fine, but when I click on a community from the Region report (for example, Community_1 above), the community report does not automatically get rendered, it makes me select a community before it renders. I must have something setup incorrectly, but can't figure it out. Any ideas would be appreciated.

I want the community report to be rendered based on the selected community without having to select it again.

Thanks, Mike

View 11 Replies View Related

How To Modify One Colomn's Data On One Click?

Jan 8, 2008

Hello every body
 
i am using a view grid to display data
the viewgrid is tied to an sqldatasource control
 i want to give the user the ability of modifing data by colomn instead of by row
 how could i do ?
 
ghassan

View 2 Replies View Related

Click Through Error - An Item With The Same Key Has Already Been Added - When/Why?

Jul 10, 2007

I am getting this error when clicking-through in Report Builder on a report using a report model as the data source -
An item with the same key has already been added.



I searched for the error but came up empty in the SSRS space. Does anyone out there know when this is generated and where I need to look in my model/properties to see what I have set incorrectly?



A little background/detail - It's a simple report against two fields (type & #count) in one entity (customer) in a (guessing here) medium sized model (~16 transactional/fact entities, ~40 lookup entities, ~15 what I am calling domain entities). The entity has 5 DefaultDetailAttributes, one Identifying. The report has 2 fields type (a lookup role) and #customers in the data area (so I can click it to test the click through). Then I click the # Customers to look at the detail for those X customers and after a long while and no queries against the DB (I have profiler running) I get this error.



Thanks in advance for the help.

View 1 Replies View Related

Downloaded Two Reports As PDF One By One After Click One Hyperlink

Mar 31, 2008

I have two reports. I need to provide a service that when the user click one hyperlink (or button), then the program can export these two reports to two files as PDF and let the user save it one by one. Is it possible?

View 3 Replies View Related

On Click Of Hyperlink Filter Data

Apr 24, 2008



Hello,

I have a report which has 2 tables.
The first table shows the current summary data as below.


ServerName Date ProjectStatus

Srv1 01/10 Green
Srv2 01/10 Red
Srv 3 01/10 Green

and the second shows the detailed history per server,

eg for Srv1

Table 2
ServerName Date ProjectStatus

Srv1 01/10 Green
Srv1 01/09 Green
Srv1 01/08 Red
Srv1 01/07 Red
Srv1 01/16 Red

I have a link on Srv1 column, on click of which i want to filter and show the data only for Srv1.
If user clicks Srv2 data in table 2 should be refreshed with values only for Srv2.

How to do this ?

Note: I have done this using subreports but I dont want to use sub reports for when it comes to using them in web aspx page it has its own issues.

I want a single report to have this functionality.

I am not able to set the Report Parameter on click of link.

Thanks
Prasad








View 11 Replies View Related







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