首页 \ 问答 \ Crystal Reports - 组中列的总和(Crystal Reports - Sum of columns in a group)

Crystal Reports - 组中列的总和(Crystal Reports - Sum of columns in a group)

 因此，我创建了以下代码片段，以便在公式中运行，以朗读每个代码在劳动中的工作时间......  
NumberVar totalHours := SUM({LaborTicket.HoursWorked}, {LaborTicket.VisualCode});
NumberVar totalMinutes := SUM({LaborTicket.HoursWorked}, {LaborTicket.VisualCode}) * 60 MOD 60;
NumberVar totalSeconds := SUM({LaborTicket.HoursWorked}, {LaborTicket.VisualCode}) * 3600 MOD 60;

ToText(totalHours, 0) + ":" +
ToText(totalMinutes, '00') + ":" + 
Totext (totalSeconds , '00' )
 
 它将我1.50小时的表示转换为1小时30分钟（或1:30:00），非常漂亮。  
 然而，现在，他们希望报告由客户端，通过可视代码...  
 由于我需要在一个组页脚上显示每个可视代码的总小时数，并在另一个组页脚上显示每个客户端的总计，我需要能够根据我不确定如何做的这两个事实来指定汇总。  
 上面的函数汇总了所有客户端，而不仅仅是报表中该点的那些客户端，因此我需要能够根据可视代码和客户端名称进行汇总。 有什么建议么？  
 我正在使用Visual Studio 2010附带的水晶版本（安装后你下载的那个） 

So I have created the following code snippet to run in a formula to rummate the hours worked for each code in labor...  
NumberVar totalHours := SUM({LaborTicket.HoursWorked}, {LaborTicket.VisualCode});
NumberVar totalMinutes := SUM({LaborTicket.HoursWorked}, {LaborTicket.VisualCode}) * 60 MOD 60;
NumberVar totalSeconds := SUM({LaborTicket.HoursWorked}, {LaborTicket.VisualCode}) * 3600 MOD 60;

ToText(totalHours, 0) + ":" +
ToText(totalMinutes, '00') + ":" + 
Totext (totalSeconds , '00' )
 
It converts my representation of 1.50 hours into 1 hour and 30 minutes (or 1:30:00), beautiful. 
Now however, they want the report to be by client, by visual code... 
Since I need to show total hours for each visual code on one group footer and totals for each client on another group footer, I need to be able to specify to summate based on both of those facts which I'm not sure how to do. 
The above function summates ALL clients, not just the one at that point in the report so I need to be able to summate based on the visual code AND client name. Any suggestions? 
I'm using the version of crystal that comes with Visual Studio 2010 (well the one you download after installing it)

原文：https://stackoverflow.com/questions/6145080

更新时间：2023-01-10 06:01

最满意答案

 我想如果目录中没有可能与模式匹配的旧文件，则可以将其作为一个命令执行。  
TYPE andx.*.txt 2>NUL >>sum_file.txt
 
 或者，这可以构建到.bat脚本中，该脚本在前一个问题中生成.txt文件。 我怀疑你是否想要在命令行上输入所有这些内容。 请注意，这未经过测试。  
@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION

SET "SUM_FILE=xxxxx.txt"
IF EXIST "%SUM_FILE%" (DEL "%SUM_FILE%")

FOR %%i IN (*.cdf) DO (
    andx "%%~i" -o TXT atmos_pressure temp_mean ^
        rh_mean wspd_vec_mean wdir_vec_mean ^
        org_precip_rate_mean
    SET EXITCODE=!ERRORLEVEL!
    IF !EXITCODE! NEQ 0 (
        ECHO ERORR: andx failed processing "%%~i"
        ECHO ERORR: exitcode is !EXITCODE!
        GOTO TheEnd
    ) ELSE (
        FOR /F "usebackq skip=1 tokens=*" %%s IN (`TYPE "%%~ni.txt"`) DO (
            ECHO>>"%SUM_FILE%" %%s
        )
    )
)

:TheEnd
EXIT /B %EXITCODE%

I suppose you could do this as one command if the directory is clear of old files that might match the pattern. 
TYPE andx.*.txt 2>NUL >>sum_file.txt
 
Alternatively, this could be built into a .bat script that produces the .txt files in your previous question. I doubt that you would want to type all this on the command line. Please note, this is not tested. 
@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION

SET "SUM_FILE=xxxxx.txt"
IF EXIST "%SUM_FILE%" (DEL "%SUM_FILE%")

FOR %%i IN (*.cdf) DO (
    andx "%%~i" -o TXT atmos_pressure temp_mean ^
        rh_mean wspd_vec_mean wdir_vec_mean ^
        org_precip_rate_mean
    SET EXITCODE=!ERRORLEVEL!
    IF !EXITCODE! NEQ 0 (
        ECHO ERORR: andx failed processing "%%~i"
        ECHO ERORR: exitcode is !EXITCODE!
        GOTO TheEnd
    ) ELSE (
        FOR /F "usebackq skip=1 tokens=*" %%s IN (`TYPE "%%~ni.txt"`) DO (
            ECHO>>"%SUM_FILE%" %%s
        )
    )
)

:TheEnd
EXIT /B %EXITCODE%

Crystal Reports - 组中列的总和(Crystal Reports - Sum of columns in a group)

最满意答案

相关问答

使用cmd提示脚本和java程序将文件输出定向到txt文件(Directing output of file to txt file using cmd prompt script and java program)[2021-09-27]

cmd - 将1个文件名导出为txt(cmd - export 1 file name to txt)[2023-05-15]

在dir中的多个文件中创建一个文件（txt），并在cmd中保留每个文件的名称(Create one file (txt) from mulitple files in dir keeping the name of each in cmd)[2023-09-23]

通过cmd填充包含多个.txt文件的表(Fill a table with multiple .txt files via cmd)[2022-08-17]

如何直接在cmd中的txt文件中执行命令？(How to DIRECTLY execute command in txt file in cmd?)[2022-03-05]

cmd文件中的通配符(Wildcard in cmd files)[2022-04-09]

使用cmd提示将.txt文件连接到一个文件中(Concatenate .txt files into one file using cmd prompt)[2023-06-30]

使用CMD显示目录中所有.txt文件的内容(Display content of all .txt files in a directory using CMD)[2022-04-28]

在cmd中将数字重命名为文件名的txt文件(Renaming txt files with numbers as filenames in cmd)[2021-10-23]

Python - 为什么我的.read（）不能用于我的.txt文件？(Python - Why does my .read() not work on my .txt file? Nothing is outputted to the cmd line)[2022-07-24]

相关文章

最新问答