how to create a end user design crystal report

Question

User-770991769 posted

hi,

in active reports they are providing a feature like "end user design reports" means user gives a query according to that query active report will be generated in design mode.so after gettinh the design he will save that report and preview the report and perform operationbs like(sum,avg).

like this end user design report is available in crystal report.please tell me whether we can achive this requirement by using crystal report.is it possible.

ex:foe suppose user pass aquery like "select eid ,ename,sal from emp"

for this query automatically the crystal report design shouldf be generated when i click on some button

like in report header it contains eid     ename     sal 

in report detail section              txteid txtename txtsal

whether we have this feature in crystal report

Answer 1

User-578610739 posted

Hi Rkereddy2010,

crystal report support  this feature. In crystal report there is option "command". read more.

http://atakala.com/browser/Item.aspx?user_id=amos&dict_id=1749

http://www.crystalkeen.com/articles/crystalreports/sqlcommands.htm

http://forums.asp.net/t/1073788.aspx/1

Answer 2

User-770991769 posted

i think u r not getting my requirement.this all things has to be done at runtime is it possible.means i run my application in IE.in some textbox i will give my query like "select eid ,ename,sal from emp" then i click on button control. so accrding to this query it has to generate a crstal report in run timne mode.

like eid   ename    sal in header section

    txteid txtename txtsal in detail section

in active reports they are having some in built contols like report designer,toolbox,report manager,properties.just we need to drag that controls and pass our query at runtime.so according to that query it generates a runtime end user design report

whether we hav any controls like this in crystal reports.is it possible