Is there a way to change the Filter reference for Query Studio Reports.
For example I have a report which pulls data from table A and I want to apply filter on one particular Item. Usually when I apply Filter, Table A is scanned for distinct values and then Displayed under "Pick values from a...
Is there any easy way to change the URL (Link to a package) of reports all at a time for Report Studio without using SDK.
We dont have SDK and I have a bunch of reports that were created using old package and now I want all of them to be pointed to the new package.
Are the model/package information stored in some sort of tables? Basically was wondering to create some report which will give the list of data items and other infortmation used in the package.
Hi,
Is there anyway to calcualte or find the report run end time, in report studio?
Actually, I can use the "As of Time" to find when the report started and at the same time I want to find the "end run time" of the report.
Col3(Date) is coming from tableC, but its used in the condition criteria only. This field is not being pulled in the select statement for query2. So when pulling fields from Query2, we have duplicates, but when you actually see at the col3(Date) at the database its not duplicate, it has a...
Both the queries are pulling the same fields,, except that query2 has additional criteria defined, but this criteria field is not being pulled. Well here is the scenario
Query1: Select Col1, Col2 from tableA a, tableB b where a.ID = b.ID
Col1 COl2
A NY
B CT
C DN
D DE
Query2...
I did try, but I am getting the result I mentioned above
A
B
D
E
F
Here is the scenario, Query 1 is pulling A,B,C,D,E and Query 2 with couple of additional criteria added and is pulling duplicate records. (Duplicate in the sense, when u pull the same number of fields as query1). (A,A,B,C,D,D,E)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.