如何选择字符串

本文介绍了如何选择字符串的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

从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!