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
Hello all, I have a 16GB iPhone 4S that I purchased on launch day, and lately it's been giving me problems, mostly having to do with text messaging. If I send a message, it sometimes goes through instantly, or it sometimes will take upwards of 5 minu [More]
Uploaded iTunes version 7 onto my PC on Friday. Ever since my fifth generation video (30GB) ipod cannot be either updated with version 1.2 software, syncronised or restored due to the error message "The ipod cannot be updated becuase it contains file [More]
Not sure if this is the proper forum for this question, just point me in the right direction if I'm wrong. I am a new student in networking, taking the CCNA courses, and now want to rewire my home.  I currently have a cable modem and E2500 setup runn [More]
if i back up my photos and videos to iCloud and then delete them from my iPad will I loose them from cloud as well?Upload your photos and video to Dropbox before you delete them from the iPad. Don't use iCloud, you can loose all your photos and video [More]
happend today my friend ask me if she can use my charger of my macbook air and she take from my bag. but the problem is she use macbook white. and i asking if that can make problem later when i want to use the charger to chard the air or not. i am us [More]
I've followed the rather cryptic instructions found in one of the manuals and also on a post here to a "t" and still can't get my web gallery up at .mac. I've created a new Homepage, added a new "page", clicked "edit link", i [More]
Will the new time capsule back up Windows on an iMac running Parallels Desktop?Windows home version MSBackup, cannot backup to network drives. That was a little bonus from Bill for those who didn't fork out for Pro or Ultimate. Like people with home [More]
I've been messing around for 2 days trying to organize my tunes. I keep setting the preferences to manual, then deleting the songs from my nano, and then wait for the message that OK to disconnect. I eject the Ipod, check the playlist and the songs a [More]
HI experts! I have problem with gross profit in Sales Analysis. On each Sales Order, i have some Items which don'nt have item cost ( Item cost =0) and gross profit are caculated 100%. But in Sales Analysis, i got strange result  of gross profit is hu [More]
I'm facing this problem. I'm using flex && actionscript to play an mp3 stream on the phone. Code works great and the sound is played when the app is run in the flash builder emulator. However, when i deploy my app on a mobile device (tried several [More]