如何选择字符串 [英] how to select string

问题描述

从Course_T中选择PK_CourseID_VC作为CourseID，选择CourseName_VC作为CourseName，将No_Of_Seats作为NoOfSeats，将SectionCount作为TotalSections"
从上面的查询中，
我想在水晶报表中显示字段
字段是
CourseID，CoursName，NoOfSeats，TotalSections作为列标题
如何选择.
请帮助我


感谢您的回复

我想将列标题显示为CourseID

但在数据库中为PK_CourseID_VC

实际上我正在创建动态水晶报表

我通过了列名

"select PK_CourseID_VC as CourseID,CourseName_VC as CourseName,No_Of_Seats as NoOfSeats,SectionCount as TotalSections from Course_T"
from the above query,
i want to display the fields in the crystal report
the fields are
CourseID, CourseName,NoOfSeats,TotalSections as column headers
how to select it.
plz help me


thankz for u reply

i want to display the column header as CourseID

but in the database it is as PK_CourseID_VC

actually im creating a dynamic crystal report

im passing the column name

推荐答案

无法获得问题所在！尽管让我逐步了解您的要求以及如何实现.

您需要在Crystal报表中显示CourseID，CoursName，NoOfSears和TotalSections.

如果上述查询很好并且可以为您返回结果，则只需要将此查询作为数据源提供给Crystal报表，就可以在设计视图中将表格拖至四列并将每个字段放在一列中.您可以将列的标题"设置为任意值，因为这将是静态的(不受查询驱动)

希望对您有所帮助！

Couldn''t get what the issue is! Though let me walk through you requirement with how it can be done.

You need to display the CourseID, CourseName, NoOfSears and TotalSections in a Crystal report.

If above query is fine and returns result for you then you just need to give this query as a datasource to your crystal report and in the design view may be drag a table wiht four columns and put each field in one column. You can set the ''headers'' of the column whatever you wish as that is going to be static (not driven by query)

hope it helps!

这篇关于如何选择字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！