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
How to fetch data from a table onto online which a specific id search plsql?
i have a procedure where users enter "student id" to search and see the details of that individual. i know this inst correct and i have far more syntax to write but so far this is what i have:-
please note i have declared all variables and my table columns name and types are correct. i haven't ran the code yet because i'm sure i'm missing something more. so please help. i'm coding on toad for oracle in plsql.
Below codes are for fetching the data and putting them onto their specific field online.
BEGIN -- fetching data from table 'unsus' IF EXISTS SELECT UNSUS_STUDENT_NO student_no, UNSUS_STUDENT_NAME name, UNSUS_SUSPEND_ACCOUNT suspend_acc, UNSUS_UNSUSPEND_DATE unsus_date, UNSUS_USER_ID user_id FROM SATURN.UNSUS WHERE UNSUS_SUSPEND_NO = ('000123456'); -- opening table rows (form based) twbkfrmt.P_TableRowOpen; twbkfrmt.P_TableData ('Student ID'); twbkfrmt.P_TableData ('Full Name'); twbkfrmt.P_TableData ('Suspended ?'); twbkfrmt.P_TableData ('Unsuspension Date'); twbkfrmt.P_TableData ('Added On ?'); twbkfrmt.P_TableData ('Altered By'); twbkfrmt.P_TableRowOpen; -- table data adding onto form fields twbkfrmt.p_TableDataWhite (HTF.formtext ( cname => '', csize => 25, cmaxlength => 9, cvalue => student_no, cattributes => 'style="font-size:12px" readonly ' || disabled)); twbkfrmt.p_TableDataWhite (HTF.formtext ( cname => '', csize => 60, cmaxlength => 60, cvalue => name, cattributes => 'style="font-size:12px" readonly ' || disabled)); twbkfrmt.p_TableDataWhite (HTF.formtext ( cname => '', csize => 15, cmaxlength => 5, cvalue => suspend_acc, cattributes => 'style="font-size:12px" readonly ' || disabled)); twbkfrmt.p_TableDataWhite (HTF.formtext ( cname => '', csize => 20, cmaxlength => 15, cvalue => unsus_date, cattributes => 'style="font-size:12px" readonly ' || disabled)); twbkfrmt.p_TableDataWhite (HTF.formtext ( cname => '', csize => 20, cmaxlength => 15, --cvalue => , cattributes => 'style="font-size:12px" readonly ' || disabled)); twbkfrmt.p_TableDataWhite (HTF.formtext ( cname => '', csize => 30, cmaxlength => 30, cvalue => user_id, cattributes => 'style="font-size:12px" readonly ' || disabled));
Query Variable Table without storing variables
Salesforce Marketing Cloud queries do not allow variables or temporary tables according to the "SQL Support" section of this official documentation (http://help.marketingcloud.com/en/documentation/exacttarget/interactions/activities/query_activity/)
I have a data extension called Parameters_DE with fields Name and Value that stores constant values. I need to refer to this DE in queries.
Using transact-SQL, an example is:
Declare @number INT SET @number = (SELECT Value FROM Parameters_DE WHERE Name='LIMIT') SELECT * FROM Items_DE WHERE Price < @number
How can the above be done without variables or temporary tables so that I can refer to the value of the 'LIMIT' variable that is stored in Parameters_DE and so that the query will work in Marketing Cloud?
TOAD - Import data from Excel without SQL*Loader
Is there a query or script that allows me to import data, or view data, in Toad for Oracle? I know I can do it by using the SQL*Loader functionality, but would like a script that can be quasi-carried over into other SQL software. Thanks!
I am create a Report using Report Builder 3.0.This is my Expression . But only work when Measured Qty > 0.00 , when Measured Quantity 0.00 get #Error
=IIF(Fields!MeasuredQty.Value > 0.00, (Sum(Fields!Amount.Value) + ((Sum(Fields!Amount.Value)) * Fields!OverHead.Value/100))/Fields!MeasuredQty.Value, (Sum(Fields!Amount.Value) + (Sum(Fields!Amount.Value) * Fields!OverHead.Value/100)))
How to display one row of data multiple times
I'm using SQL Server Management Studio 2014 and have one row of data that I'd like to display multiple times on a report. The data is shown below:
1 ACT 20117843-07 START 2/13/2017 FINISH 2/14/2017
2 ACT 20117843-07 START 2/13/2017 FINISH 2/14/2017
The current report has a group based on the Start date so the information would only appear once on 2/13/2017. However, I've had a request to display the same activity if it isn't scheduled to Finish on the same day as another row on 2/14/2017.
I've never been asked to do this before so I'm not quite sure how to accomplish the request.
Aggregation with nestged groups in SQL Server Reporting Services
Let's say we have the following data structure in SSRS report:
Disctricts are grouped by city and cities are grouped by country. And then at the country level I'd like to get
SUMof population over cities (population is an attribute of a city and districts do not have population associated with them). At the moment, when aggregation is done with
=SUM(Fields!city_population.Value)expression, population for each city is taken into account as many times as the number of districts it has associated - that is not correct.
I was thinking of getting data for summation from a supplementary dataset not having division of cities by districts (with the help of LookupSet function). But it probably won't support another grouping level of countries by year which is planned to be done further (can't figure out what can be used as a lookup key in such layout). Is there a way around this situation without lookups?
Update: It needs to be mentioned that City-District is a single entity corresponding to "city district or just the city if it has no districts". This entity was created in data source view as a named query using
LEFT JOIN(an approach discussed in this question).