请帮助数据环境 [英] Data Environment help please

问题描述

我需要查看基于特定月份和年份的薪资工资单（数据报告）。

数据环境中的
sql：


SELECT [emp_id]，[emp_name]，[emp_position]，[emp_bs]，[month_paid]，[year_paid]，[total_addition]，[gross_pay]，[total_deduction]，[total_pay] FROM薪水WHERE month_paid =？和year_paid =？


参数是月份


参数是年份



在vb代码中：

i need to view salary payslip (data report) based on that particular month and year.

in Data Environment sql :

SELECT[emp_id], [emp_name], [emp_position], [emp_bs], [month_paid], [year_paid], [total_addition], [gross_pay], [total_deduction], [total_pay] FROM salary WHERE month_paid = ? and year_paid = ?

parameter is monthler

parameter is yearler


in vb code:

展开 | 选择 | Wrap | 行号

推荐答案

i需要根据特定月份和年份查看工资工资单（数据报告）。

数据环境中的
sql：


SELECT [emp_id]，[emp_name]，[emp_position]，[emp_bs]，[month_paid]，[year_paid]，[total_addition]，[gross_pay]，[total_deduction]，[total_ded_]支付]来自工资WHERE month_paid =？和year_paid =？


参数是月份


参数是年份



在vb代码中：

i need to view salary payslip (data report) based on that particular month and year.

in Data Environment sql :

SELECT[emp_id], [emp_name], [emp_position], [emp_bs], [month_paid], [year_paid], [total_addition], [gross_pay], [total_deduction], [total_pay] FROM salary WHERE month_paid = ? and year_paid = ?

parameter is monthler

parameter is yearler


in vb code:

展开 | 选择 | Wrap | 行号

i需要查看基于特定月份和年份的工资工资单（数据报告）。

数据环境中的
sql：


SELECT [emp_id]，[emp_name ]，[emp_position]，[emp_bs]，[month_paid]，[year_paid]，[total_addition]，[gross_pay]，[total_deduction]，[total_pay]来自工资WHERE month_paid =？和year_paid =？


参数是月份


参数是年份



在vb代码中：

i need to view salary payslip (data report) based on that particular month and year.

in Data Environment sql :

SELECT[emp_id], [emp_name], [emp_position], [emp_bs], [month_paid], [year_paid], [total_addition], [gross_pay], [total_deduction], [total_pay] FROM salary WHERE month_paid = ? and year_paid = ?

parameter is monthler

parameter is yearler


in vb code:

展开 | 选择 | Wrap | 行号

我用过datareports但没有数据环境，我在表单代码中传递查询

你必须有一个控件，你将提示用户打印报告

试试看在该控件下面的代码


Dim db_file As String

Dim Myco n1 As New ADODB.Connection

''获取数据。

db_file = App.Path

如果正确

I have used datareports BUT WITHOUT data environment, and I pass the query in form code itself
You must be having a control where you will be prompting the user to print report
Try out the below code in that control

Dim db_file As String
Dim Mycon1 As New ADODB.Connection
'' Get the data.
db_file = App.Path
If Right

这篇关于请帮助数据环境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！