Search results for query: *

I have a module which outputs a .pdf file per loop out to a location. I am trying to modify the code below so that it outputs the object as an .html image instead. I am chnaging 2 lines of code to achieve this. The first is changing the forrmat type from: 'strOutputFormat = "PDF Format...

I have a basic query shown below which has a crosstab as a datasource. The fields in the crosstab contain periods of the year as the Column header. The query below is pulling period 2 data. SELECT Branch.Branch, Sum(Abs([ReportGroupBook] In ("12Actual"))*[2]/1000*-1) AS WO_GrossRev_Actual...

I have many text boxes on a crosstab report which have percent calculations. In some cases the result of a calculation will exceed 6 digits, such as 647925%. I want to be able to control the outcome to lets say 6 digits, and a question mark if that size is exceeded. Right now if the width of...

I have a report with Field Name = [WO_GrossRev_Var1] which is in the Detail Section of the report. The Datasouce contains a hundred records or so. I want each record on the report to have a BackColor of Yellow (RGB(255, 255, 0))if the value is <-0.0050 else black. On the On Format Event of...

I have code program running through a list of business units (branches) in a loop. After completing one loop I have the outputTo method writing the report to a location. I am trying to construct the OutPut To method so I can customize the directory where the output is written based on it's...

I have a function running properly with reports all being output to a directory. The file is not getting assigned the proper extension .pdf, just blank extension. Therefore the user has to select Acrobat as the application when double clicking on the file name. I have used the following...

I'm receiving this syntax error: Syntax error (missing operator) in query expression '(((Branch.BranchName)=Atlata NE ) AND ((ChartOfAccounts.ScorecardLine)>0))' When executing the code below. I believe the syntax error is near the Having Clause where I have inserted my variable from the...

I am creating a function to loop through a list of names which will be used as criteria in the SQL. I have the framework for the loop working and want to first change the object name (BranchScorecardReport)to include the Recordset string strBranchName. That way I can loop through 160 branches...

I have a report using a union Query as a datasource. All the report data is contained in the detail section of the report. The data is appearing correctly on page 1, however there are several subsequent pages with the same data as page 1 and only excluding the report header. It is strange...

I am trying to combine multiple Sum IIF calculations in one report to combine the results of multiple departments. The first department works well using: =(Sum(IIf([ReportGroupBook]="11Budget",[1]/1000,Null))) What is the syntax to combine other departments into this control source on a...

I have been struggling with a good design for combining 2 crosstab qrys CrosstabActual and CrosstabBudget to be used in a single report. The report layout is to have 12 months in the column heading,Income Statement Accounts as row headings and Amounts as values. I need the Actual Values to...

I have been struggling with a good design for combining 2 crosstab qrys CrosstabActual and CrosstabBudget to be used in a single report. The report layout is to have 12 months in the column heading,Income Statement Accounts as row headings and Amounts as values. I need the Actual values to...