>>>
>>> >> I want the SDF Format with spaces, Is there a way to do it ?
>>> >
>>> >Vinod,
>>> >
>>> >I don't know of a fast/easy way to do it. Why are you trying to do this?
>>> >Maybe there's a different way to skin the cat.
>>> >
>>> >--
>>> >Matt McDonnell
>>> >
>>>
>>> I want to give a facility to user, where he can select the fields from 4-5
>>> tables and click on a button to get the report either in a grid format or
>>> on printer.
>>>
>>> Grid display I can manage with select statement and browse, but after
>>> creating the cursor, how i should print it ?
>>>
>>> Or tell me, Is there a way to print Browse/Grid ?????
>>
>>I don't know if your controlsource for the gid is a cursor or a table,
>>but with a table you can programatically create a report
>>
>>CREATE REPORT myreport FROM mytable COLUMN FIELDS (myfieldlist)
>>
>>HTH
>>--
>>Matt McDonnell
>>
>>Conventional Wisdom - "If it ain't broke, don't fix it."
>>Gates Wisdom - "If it doesn't work, sell it, and fix it later."
>
>Thanks for your reply, This command will work in compiled Exe also ?? Plus is there any other way to have more control over the report,
>like if fields are more, how it will adjust, plus how to specify the headings ???

Vinod,

I have an idea. It may not be what you're looking for but...

Have you considered a third party product like FoxFire, R&R or Crystal? It sounds like you want to be able to give the users a lot of power in creating their own reports. You could end up spending quite a bit of time reinventing the wheel. These products have been around for a few years and have thousands of development hours poured into them.

Just an idea..