From: Samir Dorle Samir on
Hi,
I am creating n designing the reports. Previously, I used Cryatal Report to
design the report.

But, now I wanted all the reports should be designed into the EXCEL only any
version of EXCEL. I want to design the report just like the Crystal Report; I
am going to follow following steps in my EXCEL Report designing.

Steps or design as under:
01) Report header - should be fixed for all pages if exceeds more than 1 page
02) All Data fields names with proper naming e.g. if in datatable field name
is empname then on the EXCEL sheet report it should be ' Employee Name'
03) Grouping - Just like Crystal Report
04) Grouping Total - If Required
06) Page Total
07) Report Total

Please guide me how do I proceed for the same.

Regards,
Samir Dorle
From: Chris Tacke, eMVP on
Pocket Excel has no automation model, so it can't be readily programmed.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded community
http://community.OpenNETCF.com

"Samir Dorle" <Samir Dorle(a)discussions.microsoft.com> wrote in message
news:9FBE4C6B-8DFE-45E5-A16A-BC302C120E29(a)microsoft.com...
> Hi,
> I am creating n designing the reports. Previously, I used Cryatal Report
> to
> design the report.
>
> But, now I wanted all the reports should be designed into the EXCEL only
> any
> version of EXCEL. I want to design the report just like the Crystal
> Report; I
> am going to follow following steps in my EXCEL Report designing.
>
> Steps or design as under:
> 01) Report header - should be fixed for all pages if exceeds more than 1
> page
> 02) All Data fields names with proper naming e.g. if in datatable field
> name
> is empname then on the EXCEL sheet report it should be ' Employee Name'
> 03) Grouping - Just like Crystal Report
> 04) Grouping Total - If Required
> 06) Page Total
> 07) Report Total
>
> Please guide me how do I proceed for the same.
>
> Regards,
> Samir Dorle