No announcements
Found 2945248 threads
-
0 Votes
Generate Report Based on Criteria from database
Hi, I have access file which has huge data which contains all fields, and i want to make one table like given below box where i want to select ...Answered | 2 Replies | 2637 Views | Created by Eeshan Singh - Thursday, July 18, 2013 4:16 PM | Last reply by JesB - Thursday, July 18, 2013 4:24 PM -
1 Votes
Scheduling a report based on Criteria
Once this is completed, you can use SQL Server Agent to schedule a job to check if there will be data in the report, and if there is, call the subscription from ...Answered | 3 Replies | 750 Views | Created by ProfessorFudger - Thursday, April 9, 2015 1:19 PM | Last reply by Visakh16 - Thursday, April 9, 2015 4:26 PM -
0 Votes
How to include the selected criteria in the generated report's header?
Prior to the generating of my report, I prompt the user to select six criteria/parameters--three data-driven dropdowns (each set to allow multiple values), one static ...Answered | 1 Replies | 1599 Views | Created by cgwaters - Monday, January 7, 2013 4:52 PM | Last reply by Fanny Liu - Tuesday, January 8, 2013 2:54 AM -
2 Votes
COUNTING RECORDS IN A DATABASE BASED ON CERTAIN CRITERIA
I have been writing my project in VBA to produce word based reports from a database and have not explored queries and SQL.Answered | 3 Replies | 1455 Views | Created by MickYoung - Wednesday, August 8, 2012 7:43 PM | Last reply by MickYoung - Thursday, August 9, 2012 9:23 AM -
2 Votes
Advice on Generating a Report with Multiple Subreports Using User-Selected Criteria from a Form
I tried creating a comprehensive query that includes all information from my tblMatters, tblBillables, tblExpenses, tblPayments, so that I could base the ...Answered | 7 Replies | 1276 Views | Created by le_kai - Monday, March 6, 2017 4:01 PM | Last reply by .theDBguy - Tuesday, March 7, 2017 4:26 PM -
0 Votes
Generate a report on top of Parameter based Crosstab Query
You can create a dynamic crosstab report with a bit of code.Answered | 1 Replies | 507 Views | Created by KhurramKZ - Saturday, December 19, 2015 1:17 PM | Last reply by Hans Vogelaar MVP - Saturday, December 19, 2015 2:48 PM -
0 Votes
optimizing retrieval of data from database to generate report.
hi all, i have a database having 4lakh entries.i have to generate a report using 2 column values which are passed dynamically from a c# console ...Answered | 1 Replies | 2849 Views | Created by Nishanth40 - Friday, August 31, 2012 11:32 AM | Last reply by Nishanth40 - Monday, October 8, 2012 12:24 PM -
0 Votes
Count based on a Filter Criteria
This will return the last non-empty Quarter based on Net Income.Answered | 7 Replies | 3070 Views | Created by Rodrigo Sedano - Wednesday, October 10, 2012 2:50 PM | Last reply by Karthik Rangaraj - Thursday, October 18, 2012 9:07 PM -
1 Votes
set several criteria for a query- Report
If you open the report from the form that has all the criteria choices, you should be able to build a filter to return the records you want.Answered | 5 Replies | 2477 Views | Created by kvaziri - Thursday, November 10, 2011 2:43 PM | Last reply by kvaziri - Saturday, November 19, 2011 6:40 PM -
2 Votes
Generating a Database size report
[filename] [Path] FROM sys.master_files mf INNER JOIN sys.sysfiles sf ON mf.Answered | 13 Replies | 20502 Views | Created by MrFlinstone - Wednesday, February 16, 2011 10:02 AM | Last reply by MrFlinstone - Monday, February 28, 2011 3:37 PM -
0 Votes
SQL Database Architecture - [Point : Search Criteria Base on Years From Databases]
Hi Thomas, if i merge that databases in a one database like your said we have billions rows in my table and if i merge these databases .There is ...Answered | 5 Replies | 7274 Views | Created by Thomas Ruffes - Saturday, January 8, 2011 10:35 AM | Last reply by Hugo Kornelis - Monday, January 10, 2011 12:22 PM -
1 Votes
Open and Email Report Based on ID from Subform
I've been working on an Access database that contains a form with a subform.Answered | 2 Replies | 634 Views | Created by ckov814 - Tuesday, August 19, 2014 8:15 PM | Last reply by ryguy72 - Wednesday, August 20, 2014 1:56 PM -
5 Votes
retrieve columns based on a criteria.
hello, select * from tbl where (@Id = 0 or Id = @Id) thierryAnswered | 9 Replies | 2716 Views | Created by pepcoder - Wednesday, January 4, 2012 12:20 PM | Last reply by RA-Singh - Thursday, January 5, 2012 5:33 PM -
0 Votes
Pivot Table Criteria - Report Header
There are three filters that I set on this pivot table that I'm attempting to create this summary for: Field Name: Link (usually just one selection is made, but ...Answered | 5 Replies | 920 Views | Created by JMData Consultant - Thursday, November 13, 2014 6:15 PM | Last reply by Starian chen - Tuesday, November 25, 2014 9:40 AM -
0 Votes
Suggested Criteria for Database Table Compression
Hi, I now have some 'findings' from the update and scan reports to examine.Answered | 7 Replies | 2045 Views | Created by ChrisAVWood - Wednesday, January 30, 2013 11:14 PM | Last reply by ChrisAVWood - Monday, February 11, 2013 7:22 PM -
0 Votes
Criteria in qry
I have a report based on a query that is based on another query.Answered | 1 Replies | 792 Views | Created by tekoko10 - Tuesday, March 25, 2014 7:47 PM | Last reply by Dziubek Michał - Tuesday, March 25, 2014 8:06 PM -
0 Votes
auto generate report
I need the report to accept an input parameter from the user ie a medical diagnosis.Answered | 11 Replies | 4271 Views | Created by Tessa75 - Monday, December 20, 2010 9:07 PM | Last reply by Jason Tom Thomas - Tuesday, December 21, 2010 10:13 PM -
0 Votes
Run report based on a value in database.
Find a job on the SQL Server agent corresponding to your report subscription schedule (in our case it is a subscription executed in the past).Answered | 6 Replies | 3908 Views | Created by Richard68 - Tuesday, November 23, 2010 9:45 PM | Last reply by Gaurav Gupta - Wednesday, November 24, 2010 12:36 AM -
0 Votes
Count Unique Text Based on 2 Criteria
like you had mentioned the 3 steps. but you did not mentioned the criteria.Answered | 1 Replies | 380 Views | Created by ryguy72 - Wednesday, August 10, 2016 10:07 PM | Last reply by Deepak Saradkumar Panchal - Thursday, August 11, 2016 1:51 AM -
0 Votes
access report 2007 have embedded selection criteria
Hello scamperman: (1) Open up the report in Design mode.Answered | 1 Replies | 2089 Views | Created by scamperman - Friday, February 10, 2012 4:44 AM | Last reply by RichLocus - Friday, February 10, 2012 4:55 AM - Items 1 to 20 of 2945248 Next ›
No announcements