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, I want to configure Email Notifications for both UWL Tasks and Collaboration Tasks. I done with the all the Configurations suggested in the below link: [https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/706d054d-da24-2b10-f18a-f [More]
Year field in database as number. I used crystal web element and deployed report in Infoview. But LOV for Year appear as decimal eg: 2,011.00. How to convert to number format as eg: 2011Hi, I am using the below code in sub report: stringvar field4:=l [More]
Mac Mini Specs: 2014 Model with 2.6GHz processor, 8GB RAM, 1TB HD, Intel Iris Graphics, Mini-Display Port to DVI adapter with Dell monitor Issue: When booting the Mac Mini up it goes through a very standard Yosemite boot but the background is black a [More]
Hi all, A few days ago I bought a notebook (type '15-n006ed'). When i got home, i noticed the notebook had no VGA-output. I bought the notebook for school and i need to connect it with the beamer (i'm a teacher) so i need an hdmi to vga adapter.... I [More]
Firefox has detected that the server is redirecting the request for this address in a way that will never complete. * This problem can sometimes be caused by disabling or refusing to accept cookies.In my experience this is most of the times a server [More]
Hello all, when running the report,it can be seen in SAP screen by cost groups and by cost elements. The problem is that when user tries to save report in local file, then it is not able to see cost center distribution. User can only see cost element [More]
Hi Expert. Iu2019m working with PI 7.1 I would to monitor the communication between the  SAP ECC and SAP PI. SAP ECC and SAP PI communicate by proxy. I would know if I can monitor the proxy abap using SAP PI Message Error Monitoring based on Message- [More]
Sometimes when i want to turn my 30gig ipod on, all i have to do is turn the hold switch off and itll come on, other times i have to turn the hold swithc off then hold the center button. why is this the case?Well, I think just the fact that your iPod [More]
Hi there... I am having this problem...I´ve created a CO substitution following all the steps involved, works fine when I define the parameter:   exits-param = c_exit_param_none in form GET_EXIT_TITLES The transaction code OKC9 displays the exit with [More]
We have an iOS app that creates a 3-page HTML document on the user's device and then prints it. We were using Darkredz ANE to do this, but the ANE is broken in iOS 8 and the Darkredz website is abandoned. As a workaround, we want to use Safari to lau [More]