hi everyone....
tto my dataset it filling the correct records. but its not comming to the crystal report. means the records in crystal report is incorrect. in cryatal report all the recordes in database is coming not the given period.
what will be the wrong im doing here??
<code>
SqlConnection conn = new SqlConnection(C onnectionString );
SqlCommand command = new SqlCommand();
String S4 = " select Period.Per,Acco unt.Acc,GL.Deb, GL.Cre from Period,Account, GL where GL.Period=Perio d.Per and Account.AccLink =GL.AccLink and Month(Per) = '" + combo_Month.Sel ectedItem.ToStr ing().Trim() + "' and Year(PerDate) ='" + combo_Year.Sele ctedItem.ToStri ng().Trim() + "'";
SqlDataAdapter da4 = new SqlDataAdapter( S4, ConnectionStrin g);
da4.Fill(a, "Dt_Tb_2");
String S6 = "select Period.Per from Period where Month(Date) = '" + combo_Month.Sel ectedItem.ToStr ing().Trim() + "' and Year(Date) ='" + combo_Year.Sele ctedItem.ToStri ng().Trim() + "'";
SqlDataAdapter da6 = new SqlDataAdapter( S6, ConnectionStrin g);
DataTable dt = new DataTable();
da6.Fill(dt);
String S5 = "select Period.Date,Acc ount.Acc,SUM(GL .Deb),SUM(GL.Cr ed) from Period,Account, GL where GL.Period=Perio d.Per and Account.AccLink =PostGL.AccLink and Per<='" + dt.Rows[0].ItemArray[0] + "' group by Period.Date,Acc ount.Account";
SqlDataAdapter da5 = new SqlDataAdapter( S5, ConnectionStrin g);
da5.Fill(a, "Dt_Tb_3");
frmTBViwer tb = new frmTBViwer(this );
tb.Show();
</code>
0 1242 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: mh1mark |
last post by:
I have a rpt from an ADO.NET dataset that has been created in code. I
created a dummy dataset in Visual studio using the designer. It has EXACTLY
the same format as the one created in the program. I checked the data in the
dataset before it calls the report and the data is there.
HOWEVER:
When I add fields to the report and run it, the first field on the dataset
is coming up blank on the rpt, even though it has data in it when it calls...
|
by: Thad |
last post by:
I'm new to C# and I was trying to create a Crystal Report. I've
designed a simple report and I've used several methods for attaching
fields to the report at design time. I've used a DataSet that I've
created by add new item, and I've used the add command and used an
actual SQL statement, and I've used the OLEDB ADO and connected to my
database (Access) tables directly.
I have code that will create a query, use that query with an Adapter...
|
by: Michelle Stone |
last post by:
Thanks for your message
I tried again and again... but didn't work. Can u please detail the
exact steps to perform?
This is what I do. In field explorer, i right-click the dataset to
update. Then I click on SET LOCATION. When the list comes up, I
already have the same dataset as the "CURRENT DATASET" and I have the
same dataset in the tree control on the right as the default
selection. I just click on REPLACE and close the dialog. But...
|
by: Diggler |
last post by:
I was working on a report that is populated with three different tables in a
strongly-typed dataset. The tables are populated from custom objects rather
than directly from SQL Server. I loop through the objects and add the rows
one at a time. I then push the dataset to the Crystal Report.
The report worked fine, until this morning. I added another field or two to
the dataset, and rearranged the report fields to organize the report...
|
by: Ray |
last post by:
Dear Bernie,
Yes, if the same pfieldname is used. The same data will be filtered. But
I only use the code shown you before. I have not used any dataset or
datatable. How to fix the problem?
Thanks a lot,
Ray
"Bernie Yaeger" <berniey@cherwellinc.com> ¦b¶l¥ó
news:egBcd1QuEHA.3188@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...
> Hi Ray,
>
| |
by: Tyranno.Lex |
last post by:
I am using Visual Studio .NET 2003 and have successfully deployed a
commercial web application written in C# and ASP.NET. I am now wanting
to add reporting using Crystal Reports and am having a devil of a time
doing this.
The problem is that my application uses an encapsulated data tier for
accessing the database vs. accessing it directly via the client tier.
However, EVERY example that I have ever seen for creating a Crystal
Report at...
|
by: robinsimon_m |
last post by:
I am having an error while loading the dataset in crystal report. The error
is login failed.
when we add a single element in the dataset by doing right click the dataset
page and selecting the new element option. No error is coming that time.
But when i add multiple elements in the a single dataset and connecting that
dataset to crystal report then error what i mentioned is coming.
can somebody please tell me whats the problem there...
|
by: Rich |
last post by:
Hello,
I am trying to use the Reportviewer control. I have been following an
example from the web, and the instructions from the help files on set up a
..rdlc and binding it to the reportviewer control. The help files state that
in the form the contains the reportviewer control there is a tasks smart tags
panel in design view. I don't see any such thing. Where do I need to look
to see this panel?
So I have been trying to follow...
|
by: Brock |
last post by:
I am trying to populate a Crystal Report from data in my DataGrid. The
reason for this is that I want the user to be able to change values
without updating the database, but still have their report reflect the
values they anticipate committing to see hypothetical totals of
columns from a set of records. These records are displaying properly
on my DataGrid but I'm not sure how to get Crystal Reports 10 to use
as its datasource the dataset...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |