473,700 Members | 2,608 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Crystal Report sort of problem

Hey Group,

Sorry to be a pain yet again. I problem that i don`t know how to get
around:(

I use the following connection class on my project:

Private Shared mConnectionsstr ing As String =
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source="
Private Shared mLocation As String
Private Shared connArray As ArrayList
Public Shared Sub setString(ByVal ind As Integer)
Dim connArray As New ArrayList()
connArray.Add(" J:\Excellence.N et\LiveNetDB.md b")
connArray.Add(" J:\Excellence.N et\DevNetDB.mdb ")
connArray.Add(" C:\Program Files\Excellenc e.Net\LiveLocal DB.mdb")
mLocation = connArray(ind). ToString
End Sub
Public Shared ReadOnly Property [String]() As String
Get
Return "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & mLocation & ";"
End Get
End Property

and then I use:
Connection.setS tring(Me.cboSel ectDB.SelectedI ndex) on my Login form and
<WhateverDataCo nnect>.Connecti onString = Connection.Stri ng
on the load event of every other form.

And the following to print my Crystal Reports:

rptForm.Text = "Excellence .Net - Fax Meter Reading Report" 'Set the form's
titlebar
rptForm.CRVRepo rtPrint.ReportS ource = New FaxMeterReading s() 'Tell the
viewer which report to display
rptForm.CRVRepo rtPrint.Refresh Report() 'Refresh the viewer
rptForm.ShowDia log() 'Show the report

How do I get my report Print to determin which database it using? I.E -
Network or Local? All I can find on my Crystal report is the Set Location,
to which I have to choose a databse.

Many Thanks again for any help

Regards
MCN
Nov 21 '05 #1
2 1617
Hey i`ve found this but im so confused, i ain`t got a clue what it means, is
this what I should be looking into?

http://support.businessobjects.com/l...s/c2011464.asp

Any help would be much appriciated

Thanks
MCN

"MadCrazyNewbie " <te**@nospam.co m> wrote in message
news:4D******** ************@ka roo.co.uk...
Hey Group,

Sorry to be a pain yet again. I problem that i don`t know how to get
around:(

I use the following connection class on my project:

Private Shared mConnectionsstr ing As String =
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source="
Private Shared mLocation As String
Private Shared connArray As ArrayList
Public Shared Sub setString(ByVal ind As Integer)
Dim connArray As New ArrayList()
connArray.Add(" J:\Excellence.N et\LiveNetDB.md b")
connArray.Add(" J:\Excellence.N et\DevNetDB.mdb ")
connArray.Add(" C:\Program Files\Excellenc e.Net\LiveLocal DB.mdb")
mLocation = connArray(ind). ToString
End Sub
Public Shared ReadOnly Property [String]() As String
Get
Return "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & mLocation & ";" End Get
End Property

and then I use:
Connection.setS tring(Me.cboSel ectDB.SelectedI ndex) on my Login form and
<WhateverDataCo nnect>.Connecti onString = Connection.Stri ng
on the load event of every other form.

And the following to print my Crystal Reports:

rptForm.Text = "Excellence .Net - Fax Meter Reading Report" 'Set the form's
titlebar
rptForm.CRVRepo rtPrint.ReportS ource = New FaxMeterReading s() 'Tell the
viewer which report to display
rptForm.CRVRepo rtPrint.Refresh Report() 'Refresh the viewer
rptForm.ShowDia log() 'Show the report

How do I get my report Print to determin which database it using? I.E -
Network or Local? All I can find on my Crystal report is the Set Location,
to which I have to choose a databse.

Many Thanks again for any help

Regards
MCN

Nov 21 '05 #2
This may be of no help but may I suggest... connect to your DB by way of a
Web Service / Stored Poc.

Then changing DB is a snap.

just a thought

B
"MadCrazyNewbie " <te**@nospam.co m> wrote in message
news:y_******** ************@ka roo.co.uk...
Hey i`ve found this but im so confused, i ain`t got a clue what it means, is this what I should be looking into?

http://support.businessobjects.com/l...s/c2011464.asp

Any help would be much appriciated

Thanks
MCN

"MadCrazyNewbie " <te**@nospam.co m> wrote in message
news:4D******** ************@ka roo.co.uk...
Hey Group,

Sorry to be a pain yet again. I problem that i don`t know how to get
around:(

I use the following connection class on my project:

Private Shared mConnectionsstr ing As String =
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source="
Private Shared mLocation As String
Private Shared connArray As ArrayList
Public Shared Sub setString(ByVal ind As Integer)
Dim connArray As New ArrayList()
connArray.Add(" J:\Excellence.N et\LiveNetDB.md b")
connArray.Add(" J:\Excellence.N et\DevNetDB.mdb ")
connArray.Add(" C:\Program Files\Excellenc e.Net\LiveLocal DB.mdb")
mLocation = connArray(ind). ToString
End Sub
Public Shared ReadOnly Property [String]() As String
Get
Return "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & mLocation &

";"
End Get
End Property

and then I use:
Connection.setS tring(Me.cboSel ectDB.SelectedI ndex) on my Login form and
<WhateverDataCo nnect>.Connecti onString = Connection.Stri ng
on the load event of every other form.

And the following to print my Crystal Reports:

rptForm.Text = "Excellence .Net - Fax Meter Reading Report" 'Set the form's titlebar
rptForm.CRVRepo rtPrint.ReportS ource = New FaxMeterReading s() 'Tell the
viewer which report to display
rptForm.CRVRepo rtPrint.Refresh Report() 'Refresh the viewer
rptForm.ShowDia log() 'Show the report

How do I get my report Print to determin which database it using? I.E -
Network or Local? All I can find on my Crystal report is the Set Location, to which I have to choose a databse.

Many Thanks again for any help

Regards
MCN


Nov 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3867
by: windos | last post by:
Dear all, I am a new in using Crystal Report. I'm trying to add this query in CR : SELECT
0
4488
by: Dr. Indera | last post by:
hello, i previously posted the questions below on several crystal reports newsgroups, including the one for the company that makes crystal reports, but never got an answer, so i'm hoping that someone on this board knows the answers to them. the questions are for the version of crystal that ships with visual studio.net 2003. if it helps, the reports that i create are in a visual basic.net project. it was recommended that i post the...
1
603
by: david risby | last post by:
I'm getting an unwanted database login form appearing when I set the Data Source of a Crystal report to a .Net dataset e.g. myReport.SetDataSource(myDataSet This only occurs on some PCs, works perfectly fine on all my PCs (Windows 2000, XP Pro), and work OK on my clients XP Home machines Problem only occurs on my clients XP Pro machines, these are out of the box Dell machines with XP Preloaded Can't understand why only these PCs...
4
2970
by: Ryan Gregg | last post by:
I've got a background service running that needs to check a database periodically and print reports whenever it finds that the data has changed. I've built a class library that scans the database for the changes, and then generates a report using the VS.NET 2003 version of Crystal Reports, and prints the report. It works just fine when I use it in a single threaded environment. However, when I build an application that uses a...
1
3144
by: saima ashraf | last post by:
Hi, I am trying to sort the data in my crystal report at runtime. The problem is that i can only query the database once and that is at the loading of the report. At that time i fill up my dataset. Afterwards when the sorted data is required, i use the Dataview's sort method and sort the data. This sorted data is perfectly shown in the datagrid. Now i want this data to be shown in my crystal report object too. Its not working!!! Can...
3
1177
by: Brad | last post by:
I have just posted a variation of this question on the Crystal Reports board, but most times I do not get a reponse. I have a report in which I asked about yesterday and after working all day on this, I actually have it looking pretty good. It is displaying header information and listing the data that I want it to in various sub reports. The problem that I am having is that the sum of the rows in the subreports, it is printing one...
3
2202
by: Agnes | last post by:
I write the invoice by using crystal report in vb.net . I can export it into *.pdf very well, However, it can also export to word, excel also. we are afraid that the user export the invoice into excel format and then amend it by himself. Can I allow the crystal report export to *.pdf only ?? or make their excel or word file (read only) ??? Thanks a lot
5
2239
by: furby | last post by:
I'm asking this on the off chance that someone out there might have seenit before. In my current application, when the user logs in, the state variable called "role" is assigned to them, detailing what they can do and what they cannot do. This variable follows them through the entire application (It is assigned using Session("role") = "xxx"). Problem is, when I run a crystal reports RPT file, I lose the session variable - it reverts...
0
1933
by: Peter Afonin | last post by:
Hello, I'm still learning Crystal reports, and now I need to sort report programmatically. I've found a good article about it: http://blogs.ittoolbox.com/c/coding/archives/sorting-the-fields-in-crystal-report-programmatically-16201. This is how it described there: ReportDocument objReport = new ReportDocument(); objReport.Load("Your report path"); FieldDefinition FieldDef;
0
8731
marktang
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...
0
9219
Oralloy
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...
0
9081
jinu1996
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...
1
8975
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,...
0
8931
tracyyun
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...
1
6564
isladogs
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...
0
5904
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4408
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
2395
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.