Drag columns around?

Hello,

I am a complete newbie to CR and am evaluating CR-XI. I have a requirement to create user-customizable reports - i.e. reports where the user can move columns around to get a layout he/she likes for printing. For example, if there were 5 fields in the report:

Column1 Column2 Column3 Column4 Column5

and the user wanted to print the report with the field order:-

Column1 Column2 Column5 Column3 Column4

is it possible for the user to be able to drag the columns around? Being an amateur, could someone please list the steps I need to go thru to achieve this? Is this possible programatically - via VB6/VB.Net and if so could someone direct/show me some detailed code for this?

Apart from what I described above, the bigger requirement is to create reports at run-time from scratch. I need to create an application that will accept SQL queries from the user, parse it, run it, and display the resultant recordset as a CR. Could someone please direct/show me some code on how to do it - I am a beginner and so will need as much help as possibe.

I use Delphi 7/.Net but am pretty sure I will be able to convert VB to Delphi.

I very much appreciate any help I can get.

Thanks,
VrijeshSee if you find solution at the suppoet section of this site
www.BusinessObjects.comsql

Domain Question

Hi,
We are going to configure a 2-node active/passive SQL
server cluster using W2003 Server Enterprise.
A requirement is that both nodes be a member of the same
domain.
We want to make one of these nodes the Primary Domain
Controller. Obviously if you lose that node in the cluster
you will lose the PDC! Can we make the other node a backup
domain controller? So, we can pull the plug on the PDC and
the BDC will now act as domain controller (and SQL server
will failover too)? Will that work
So is it a bad idea in a 2-node cluster to also have the
PDC and BDC be the nodes in the cluster?
Thanks.
We should not configure our cluster nodes as domain controllers; instead, we should use dedicated domain controllers. If we do configure our nodes in any combination of a primary and backup domain controller, it
could have direct implications for any SQL Server environment, as noted in the following Microsoft Knowledge Base articles
298570 BUG: Virtual SQL Server 2000 Installations May Fail if Installed to Windows 2000 Domain Controllers
http://support.microsoft.com/?id=298570
281662 Windows 2000 and Windows Server 2003 Cluster Nodes As Domain Controllers
http://support.microsoft.com/?id=281662
In general, we should NOT install SQL Server 2000 on a domain controller.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx