Report Builder 3.0 - See Values of Params Passed to Stored Proc?
From the Report Builder 3.0 (the builder itself), is there a way to see the VALUES of the params with which the stored proc is being invoked?
I want to verify that my dataset is working properly.
See also questions close to this topic
i want to fetch data according to tables which are dynamic means their name might change in databse from time to time
I am working on a query, where I need to fetch data from tables which are dynamic in nature, meaning their name might change in the database from time to time.
So, first step is that from the schema, I will get to know what the recent table names are under that schema from which I have to fetch the data, but the second part is the difficult one for me: Once I've got the table name, how could I use those tables to fetch data inside them?
one button click that store and display info from Different table
I want to process a bill in singleBill table intially select those field then when user press the process bill button then it will process more info from singleBill and client table like
fromDt=selected moth 1st date from singleBill to= 30+formDt
bill Amount = rentRtae - ((rentRateadjPercentage)/100) comes from client table deposit Update = deposit - ((rentRateadjPercentage)/100) comes from client table
and display all ifo like
billId: 101 bill Amount = 8000
and other field remain empty now
so how to do this process and insert info and display info clicking billProcess button
MS Access queries to MySQL Table
I got a problem on MS Access queries to MySQL table
I'm new to both database.
I got a query on MS Access and now I have to migrate to MySQL.
The question is I need to create a table or a view to let the program get data from.
CREATE TABLE Subsequence AS SELECT 'A' AS Type,br, comm, identifier, app_type, Min(timestamp) AS timestampOfMin FROM trans_log WHERE (((trans_log.table_type)='APPARATUS') AND ((trans_log.action)='APPROVAL')) GROUP BY br, comm, identifier, app_type UNION SELECT 'C' AS Type,br, comm, identifier, app_type, Min(timestamp) AS timestampOfMin FROM (select * from trans_log where action='CEASE_APPARATUS') AS B GROUP BY br, comm, identifier, app_type ORDER BY timestampOfMin;
It is the code for the table.
The question are,
1)while my trans_log update, Can I get the latest data inside this table?
2)Do I have to set up a foreign key?
3) if no, any method?
I'm new to these database, Thank you for your help.
ssrs cascade parameter not keeping selected value
I'm creating a report that asks for a datetime, and then, it will populate a dropdownlist with values from a stored procedure.
The cascading part is working fine, however it's clearing the selected datetime, and I would like to keep that. Is there any flag / property in order to achieve that?
Change grouping in SSRS bar chart
In my SQL query, I get returned back rows with a person's name and a column for each action they may do with the total number of times the did the action.
RowID | Name | Action1 | Action2 | ---------------------------------- 1 | Joe | 3 | 5 | 2 | Bill | 4 | 2 | 3 | Mike | 5 | 1 |
I am trying to do a simple chart that shows this data so each person has a color assigned. The X-axis is labeled with the Action name, a bar for each name over the action, and the Y label is the # of times that action was performed.
If I do a series group by the name with the actions as the values, I get six colors assigned one for each name-action combo and it wants to group the bars by the name, not the action.
If I do category groups by the name, keeping the actions as the values, I get a color for each action and the X-Axis labeled by the name and a bar over each name for each of the two actions. so I get three groups of two bars.
5| + * 4| * + * 3| * *+ * 2| *+ *+ * 1| *+ *+ *+ -------------------- Bill Joe Mike * Action1 + Action2
What I want is:
5| * + 4| - * + 3| -+* + 2| -+* -+ 1| -+* -+* ---------------- Action1 Action2 -Bill +Joe *Mike
It's in a grid of charts, so I really can't split it into two charts and meet the design criteria. I'm also using Report Builder 3.0 for legacy reasons. Multiple other charts run off of the dataset, so changing the data structure to return each action on a row will break the other charts.
Report Builder 3.0 Dashboards and parameters and actions
I'm hoping someone can help me - AGAIN!
I'm trying to design a (sort of) dashboard type, one page, report for our Customer Service Centre. The plan is to have a table with Years in rows, Months in columns with a total of cases raised by month and year. This is running off a main dataset.
I've set up other datasets for Year, Month, Channel Reported (Service Centre, Phone App, Web Smart Form), Contact Method (Phone, face-to-face, e-mail/document in, smoke signal etc.), Type of Case Reported. These all have parameters built into the query and dependencies if needed. When working the parameters will be hidden so that clicking on a text box or series invokes an action to populate the parameter and pass through data to other parts in the report.
The overall idea is that on clicking a Year a Pie Chart is populated with Yearly Channel Reported details, a Vertical Bar Graph displays Contact Method and a List shows Type of Case Reported. Clicking on a Month changes all the views to details for the chosen Month.
I've managed to get the Years and Months to populate the Pie Chart but can't get the Bar Graph or Lists to populate. After two weeks of monkeying around and pulling my hair out it's driving me crazy.
If I set up other reports with the Year and Month populating the Bar Graph OR List the single graphic element works fine but I can't get any two (let alone three) working at the same time.
Ultimately, I'd like to drill through to the Bar Graph from the segments of the Pie Chart and to the List from the bars on the Graph but, just now, I'd settle for getting all the Charts working.