Visual Basic

amaneet9-Apr-07 20:48

9-Apr-07 20:48

Tell me something about ur requirement.

kripa219-Apr-07 20:55

9-Apr-07 20:55

ok sir
i have one application in that i save image,id,date in table
i want view datewise report
such as all yesterday's record

amaneet9-Apr-07 21:38

9-Apr-07 21:38

u mean on date 01/01/2007 02/01/2007 03/01/2007
1 2 3
1,2,3 ae the date related to the 01/01/2007 ,02/01/2007,03/01/2007 dates respetively.
u want to display the epot in the above pattern.

kripa219-Apr-07 21:44

9-Apr-07 21:44

can u help me
pls send me link or code

amaneet9-Apr-07 22:13

9-Apr-07 22:13

the thing is u have to develop the eports uself.
All I can do is , I can tell u the way , how to proceed.

First include a report file to ur project
then u will see a dialog box , select the coss tab there
the next page is for new connection creation
select the new connection creation and collapse the plus button
select the type eg access
click next
select the database
after this u will get the tables .
select the table u want.
after then click next
do the linking between the tables(relation between the tables.)
then u will get a dialog box
select the field for the heading
like on the paticuar date u have to show it's product.
select the date field likewise for the columns
and for the summary field select the field that u want to display under the date.
and remaining for the rows.
and finally click finish
Hope thid will help u.

kripa219-Apr-07 22:20

9-Apr-07 22:20

sir
can u tell me that
where is report file
(how can add it)

I added report from windosForm
it shows report with following msg
"To creat a report layout,drag items from the toolbox & fileds list & drop them here"
what i do

amaneet9-Apr-07 22:44

9-Apr-07 22:44

Mam,
right click on the project in solution explorer and click to add--- add new item
select the report file(.rpt)

kripa219-Apr-07 22:53

9-Apr-07 22:53

sir
i tried to follow it
but there is not .rpt
there is .rdlc
so I changed it as .rpt and it showed as
<code><?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Width>6.5in</Width>
<Body>
<Height>2in</Height>
</Body>
<rd:InitialLanguage>true</rd:InitialLanguage>
<rd:InitialDimensions>
<rd:UnitType>Inch</rd:UnitType>
<rd:LeftMargin>1in</rd:LeftMargin>
<rd:RightMargin>1in</rd:RightMargin>
<rd:TopMargin>1in</rd:TopMargin>
<rd:BottomMargin>1in</rd:BottomMargin>
<rd:PageWidth>8.5in</rd:PageWidth>
<rd:PageHeight>11in</rd:PageHeight>
<rd:ColumnSpacing>0.5in</rd:ColumnSpacing>
</rd:InitialDimensions>
<rd:InitialDimensions>
<rd:UnitType>Cm</rd:UnitType>
<rd:Width>16cm</rd:Width>
<rd:Height>5cm</rd:Height>
<rd:LeftMargin>2.5cm</rd:LeftMargin>
<rd:RightMargin>2.5cm</rd:RightMargin>
<rd:TopMargin>2.5cm</rd:TopMargin>
<rd:BottomMargin>2.5cm</rd:BottomMargin>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:PageWidth>21cm</rd:PageWidth>
<rd:PageHeight>29.7cm</rd:PageHeight>
<rd:ColumnSpacing>1cm</rd:ColumnSpacing>
</rd:InitialDimensions>
</Report>
</code>

where is problem?

amaneet9-Apr-07 22:55

9-Apr-07 22:55

u r doing window applicatons or web applications?

kripa219-Apr-07 23:26

9-Apr-07 23:26

it is windows appli

amaneet9-Apr-07 23:35

9-Apr-07 23:35

then find the crystalreports .rpt file, it is there .add it to ur project.

kripa219-Apr-07 23:51

9-Apr-07 23:51

sir
actully Crystal report is not installed by admin
I am student & not permissions to do it
is there any way for report generation

amaneet9-Apr-07 23:57

9-Apr-07 23:57

then ask ur adminitrator to install it now.Simple Smile | :)

kripa2110-Apr-07 0:02

10-Apr-07 0:02

Thank u sir
I will try

amaneet10-Apr-07 0:13