Sitemap

Amicuk Programming Answers

Display count of all records in a query on VC

-0001-11-30   Views:0

Advertisement

Hi all, I have a query for debtors. I want that on VC, only the no of document present in that query should be displayed instead of all documents in a chart or table. Is that possible on dash board? If yes then how?? Regards, Aisha Ishrat ICI Pakista

Hi all,
I have a query for debtors. I want that on VC, only the no of document present in that query should be displayed instead of all documents in a chart or table. Is that possible on dash board? If yes then how??
Regards,
Aisha Ishrat
ICI Pakistan Ltd.

The replay answer
Advertisement
If it's an SQL query then do a: "select count(*) from table_debtors where ......"
Or you can use the Sigma operator. Just add this between your data source and the output table. When configuring the operator choose "count" for the fields.
Henning
Edited by: Henning Strand on Jan 22, 2008 8:04 AM

Go to See the other 5 answers

Display count of all records in a query on VC

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I have a query for debtors. I want that on VC, only the no of document present in that query should be displayed instead of all documents in a chart or table. Is that possible on dash board? If yes then how?? Regards, Aisha Ishrat ICI Pakista[More]

Query in SQL to display count of all records but where condition is present

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have situation where I need to display count of all records all particular period but in where condition type condition has to be present : Please find the below sample data : PERIOD_ID     TYPE     MV_COUNT     IS_FLAG 20110401     AM     [More]

Pagination Displaying Count of Total Records available and Current Page

Category:DefaultRelease time:2015-10-11Views:130

Hi, I need to implement paging in one of our pages. The problem is we need to display the count of total number of records the search has resulted and the search results that fall into the current page. For e.g. If the search resulted in 100 records[More]

Counting records in a query

Category:DefaultRelease time:2015-10-11Views:130

Hello all, I have a question about the counting of records in a query. Below, there is the source data. material plant date stock quantity X 1 05.2006 10 X 1 06.2006 0 X 2 05.2006 15 X 2 04.2006 20 Y 1 05.2006 5 And with "How to Count the occurrences[More]

Displaying different no. of  records for a select Query for the same dbuser

Category:DefaultRelease time:-0001-11-30Views:130

Hi, While querying from my machine after connecting to custom schema it is displaying 3000 rows. When the same query was executed from different machine it is displaying just 31 records. 1. Connect as xxyy user and executed the below command select c[More]

Counting records after a query

Category:DefaultRelease time:-0001-11-30Views:130

I am running a query and I want to display the number of records retrieved during the query. I have researched the COUNT_QUERY built-in and tried to assign the value returned by this built-in to a variable. (It doesn't work.) I have used the the foll[More]

How to display records from a query into non-database field

Category:DefaultRelease time:-0001-11-30Views:130

Hi I a have a problem: I have a query with many tables and 6 column(select a,b,c,d,e,f from x,y,z,t,s,g where conditions) and I use 3 parameters. I create 3 parameters :datai,:dataf and :partener and a button with a trigger when button is pressed. Th[More]

Need to display count and report both by using single Query

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I got any requirement in that i need to display count and report both. Like Count os Unassigned=20 Count of Assined=23 Sr   name     summary        etc ...... 1     dssss        sdsds         dsds 2     sdada       sdsd          sdsds 3     d[More]

How to get count of all records of all entities in CRM Online

Category:DefaultRelease time:-0001-11-30Views:130

Hi,  I want to get count of all records entitywise in dynamics CRM 2013 online. I know we can count the records in CRM on-premise using a SQL query in report. Earlier I wrote a SSRS report to count the records in a CRM entity wise  as displayed in th[More]

Issue returning a count of rows in a SELECT QUERY...

Category:DefaultRelease time:2015-10-11Views:130

I am working in Oracle 11.2g and I have a query where I want to return the count of DAILY records as well as WEEKLY records for specific marketers. Here is my query: Select     Mka_Mktr_No,            Case When Rat_Freq_Cd = 'D' Then Count(*) Else 0[More]

Count number of records in a internal table

Category:DefaultRelease time:2015-10-11Views:130

hi i want to count number of records in internal table pls let me know how to count the number of records in a internal table. regards Arorahi one way is data field type i. Decribe table itab lines field. write: / field. displays the no of records in[More]

Hot
hi This is all new to me...As a parent,I have my iphone with my account for apple with my email as the main contact address...here's the problem. My two teenagers ALWAYS get or at least can read from their phones/ipads ALL my texts i send/receive and [More]
Hi I am going toexplain what I can do already first then explain what I want to do: 1) I have an html page that has a form. This form requests a userId and password to be entered. Upon submission of this form a java servlet is called 2) the java serv [More]
HI GURUS, i am configuring in windows environment. i have given following Quick-configure menu -- domain: PATPS Features Settings ========== ========== 1) Pub/Sub Servers : No 15) DBNAME :[PTSYS] 2) Quick Server : No 16) DBTYPE :[ORACLE] 3) Query Ser [More]
Hi please help me " To convert Below Java code equivalent to c# windows store app." private String SecretKey = "enctsbqrm6hxyjfa";     public byte[] encrypt(String text) throws Exception         if(text == null || text.length() == 0)   [More]
The column order on the data tab is different from the column order that is specified in the View's SQL statement. ReneThe current order of the columns is simply whatever order a select * returns. -krisRead other 2 answers [More]
Hi all We're currently trying to set up a WSUS in our firm, to make updating servers easier and less of a time-wasting work. The goal would be, for the servers to automatically install the updates and then reboot, so a collegue or me only have to che [More]
I already have Photoshop Elements 12 and was bought Premiere 13 for xmas and they are not recognising each other. Each keep asking if I want to download the trial version of each? I dont know if you can use Photoshop Elements 12 with Photoshop Premie [More]
Congrats BlackBerry For amazing Q10 Mobile , I like it so much and the feature of phone like software, camera, application wonderful. But I found things which I missed it from Old Blackberry Phone and it's was helpful for the Users, & If this things [More]
Hello, A client has requested we create an RSS feed of new portlet content. They want to be able to view all new content via an RSS feed on IE7. Has anyone made something like this? Suggestions or thoughts? Using Portal 6.1.2, Publisher 6.5 Thanks, V [More]
I am using a web page with a list of hyperlinks as source data in an Omniportlet. I can use the webclipping studio to clip out the link description but not the underlying hyperlink URL so that I can't use the URL data for the hyperlink function in Om [More]