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
i attempted to update my firefox last night, and when i did it casued me to have to reinstall adobe flahplayer and adblock. When i attempted to re-download these apps i couldn't. Now I don't have adblock and I can't watch videos because flashplayer w [More]
Hi all, I have a water damage iPhone 5s was bring to service center to have new set change with top up the money. Well, the staff were told me that the phone can't be change due to some of minor parts are missing in the phone. He said this is due to [More]
Hi Friends, We have a custom build program to extract data and post FI document. In some cases after extraction we have a data with mixed DC/LC and LC2 amounts in different signs thats is debit/debit/credit amounts. Example ( Document currency as +10 [More]
I recently upgraded Flash to CS4. After installing using AIR has been impossible. I've uninstalled and reinstalled numerous times. Tried removing all references to AIR within the registry and reinstalling. Regardless, if I try to open an *.air instal [More]
Hi everyone! I've just started using flash catalyst a couple of days ago and I am loving every minute of it, but I have found a problem that I couldn't find a solution for by googling (never happened to me before!) So, I'm a wedding album designer an [More]
Hi All, I wanted to bring this to everyone's attention since it caught me by surprise. There is no direct upgrade path from 7.0 to 8.1. 7.5 is the last version that offers a direct upgrade path to 8.1 This is not nearly as bad as it sounds. When done [More]
Hi, I am still getting errors trying to unmark/unpropose answers. Yesterday I tried a few times to unmark my own answer - didn't work. Right now I tried unmarking the answer in this thread twice http://social.msdn.microsoft.com/Forums/sqlserver/en-US [More]
Hii all I have Install Oracle 11g release 2 on my 32 bit windows OS. But I am having Little problem while opening editor 1) when ever i am typing ed in sql prompt I am having error     Cannot create save file "afiedt.buf"    How ever i have trie [More]
Hi, I know that there are a lot of threads with this error, but I don't know how to solve my situation yet. I'm trying to access to the database via JDBC, and the driver return the following error: java.sql.SQLException: IO Error: The Network Adapter [More]
In my application I open pdf in new window using PDF open parameters. In this when PDF document open in new window I want to set hand as default cursor. I have gone through all PDF open parameters but I haven't got any parameters for default cursor. [More]