March 4, 2008 at 10:09 am
Hello.
Can anyone help me figure out how to solve this requirement?
I have a report that represents a table of results:
test type | test id | test result
The data is queried from various tables in the database. The requirement is that next to each row in the table there will be a button or something of that sort, and when the user presses it- he will get the details of a specific test (by the test id + type) and will be able to see where the test failed/succeeded. This data will be queried from a specific table, based on the test type.
Is there any way to create something similar to this scenario using reporting services? How do I use data from a specific row in a report results table? Can this scenario be managed using subreports?
Thank you,
N.
March 4, 2008 at 11:24 am
I do something similar to this with support 'cases', but I use another report to show the details of the case, instead of a sub-report, and link to it using a URL.
Create your report with the list of test results. In your dataset build a url with the id number for the test
Right click on the column that will display the link, and select properties, select the navigation tab, and pick 'jump to url'. In the expression for this, use the derived column you buit in your dataset with the URL in it.
Create another report called 'testresults' with a parameter for the test_id. This report will accept a test_id and then display the details of the test when it is loaded.
Does this make sense? 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply