Home > Default > Updating a table when a user selects a row (or triggers an action)

Updating a table when a user selects a row (or triggers an action)

November 30Hits:0
Advertisement
Hi,
i am designing a view on report builder 3, SQL Server 2008R2
i have a shared dataset that holds customer details, and another shared dataset that holds the sales details.
the report has a date from/to parameter and a category parameter.
i have designed the report to have two tables one to show all customers (with their details) and the other should show the sales of the specific selected customer within the date range
i have tried accomplishing this also by using a subreport with no luck, could you please let me know how i can this be done
many thanks!!
Ronen

Answers

Hi Ronen,
Per my understanding that you get the sales of the selected customer within the data range to display in the main report, right?
You have mentioned that you have tried to use a subreport but failed, the issue can be caused by the wrong you have setting the subreport or the relationship between the main report and the subreport.
As Uri Dimant suggested that we should add parameter in the subreport, details information below for your reference:
 I assumed that in the sales details table have the same fields or some relationship fields with that of the customer details table(Date, Category), so in the subreport create three parameter the same as that in the main reports and add the same filter.
Right click the Subreport to select the subreport properties and add the parameter like below:
Three parameter are comes from the subreport and the three fields in the value come form main report:
Another method which is similar like that of using the subreport is to using the LookUp function, because your SSRS version is 2008 R2 and this function only supported with SSRS 2008 R2 and Later version. Details information below for your
reference:
Create an DataSet2 to get all the fields from Sale Details table.
Find out the relationship field between the two table which is union (Date) to use in the expression in the main report like below:
=Lookup(Fields!Date.Value,Fields!Date.Value,Fields!Sales.Value,"DataSetName of the SalesDetails"):
Note: first field comes from Customer details table and second and third field comes from Sales details table.
Detail information about using the LookUP function in below article:
Lookup Function (Report Builder and SSRS)
If you still have any problem, please provide the sample data of the two tables.
Any problem, please feel free to ask.
Regards
Vicky Liu
Vicky Liu
TechNet Community Support

Read other 3 answers

Tags:

Related Articles

  • Updating a table when a user selects a row (or triggers an action)November 30

    Hi, i am designing a view on report builder 3, SQL Server 2008R2 i have a shared dataset that holds customer details, and another shared dataset that holds the sales details. the report has a date from/to parameter and a category parameter. i have de

  • How to refresh a child table each time I select a row in the master tableNovember 30

    I've 2 tables, a master table and a child table. When i click on each row of the master table, the child table needs to be refreshed. I've given the id of table1(master) as the CreatePartialTrigger value in table2(child). The refresh does happen but

  • Best method to update database table for 3 to 4 million rowsNovember 30

    Hi All, I have 3 to 4 million rows are there in my excel file and we have to load to Z-Table. The intent is to load and keep 18 months of history in this table.  so what should be best way for huge volume of data to Z-Table from excel file. If is fro

  • Updating multiple tables from updatable reportNovember 30

    Hi, I'm new to APEX and SQL and need some help I've got 2 tables, one for person (containing employee_id which is the primary key and position_id, which shows the position that the employee fills, and some others) and one for position (containing pos

  • How to select all rows in table automatically after refreshing?November 30

    Hi,All After refreshing the table,I want to select all rows,like MultipleButton's function. How can I do? Thanks Smile.Hi,-Grif- * Set the selected state for the given row groups * displayed in the table.  This functionality requires * the 'selectId'

  • ADF master-detail master selection not updating detail tables properlyOctober 11

    Hi All, I am using JDev version : 11.1.2.0.0 I created new Fusion Web Application Module. In that module I created a master-detail data model and added them to a page fragment with a query panel. When I run it as a separate module, It works perfectly

  • Update table based on a select with a where clauseOctober 11

    I am trying to update a table only for records where i have a status of changed. Using the following code the update changes all the records putting in blank data if it is outwith the where clause. ideas? -- Update changed records UPDATE IP_SURVEY_AC

  • Add a Select List to a Report, for Updating a table.November 30

    I am working on Apex 3.0. I had to allow the Report could update a table. I added two checkbox to the report, and now I should add a Select List. I've tried a lot of ways but I don't know how can I pass the value selected, related to the ID of the ro

  • Updating a table using cursor is taking long time in oracleOctober 11

    Hi, I am working on the oracle database 11gR2. I am trying update a table column which is newly added through cursor. below is the cursor. BEGIN      FOR lcur_tab IN (select l.LOGIN_ID as login_id, lt.ERROR_CODE as error_code from LOGIN l INNER JOIN

  • Are these key fields in 'Direct Update' DSO table in BW on HANA (BW740SP7) correct?October 11

    Pls see below for a very strange behaviour of all active tables of type 'Direct Update' DSO in our system. Is this a bug or is this somehow supposed to be like this (i.e. a feature)? DSO definition: Active table of type 'Column Store' - note fields m

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.865 s.