RE: Frustration and Excitement with Crystal Reports

Hi again Tony,
I am not sure I understand the problem. Is CR not able to connect to the
Db? Seems like you would get some error if that was the case. Are you sure
you are setting your parameters corretly - sounds sort of like the query is
running and returning an empty result set. Try doing a report that takes no
parameters and see what happens. As I pointed out in a prior email, if it is
a connection problem, maybe the way to go is to populate a dataset yourself
and then have CR report on the DS and not go to the Db. If you create a
dataset and add a tableadapter based on the query that CR is trying to run.
There is a way in CR to change the datasource from the query to the DS (w/o
having to redo the whole report). You could then fill the DS yourself and
'shove'it to CR so CR will never have to connect to the Db.
BTW, I just started working with CR a couple of months ago - so I am no
expert, but it sure beats the VB PrintDocument (to me anyways). I really
struggled with it for the first month and was abut to &%% can it when I
finally started getting somewhere. The documentation really sucks but if you
stick with it - it will save you a lot of time in the long run.
--
Terry


"Tony K" wrote:

Getting the former. Not the latter.

As some of you may know (Terry...btw thanks for all your help), I have been
battling a Crystal Reports problem. I have recently made the discovery that
my "Current Connections" or ADO.NET options for the database expert in CR
are not working with my project.

IF I create a new connection to my Access DB(DAO) or use OLE DB(ADO)
connection I will receive correct data (results) on my report for the first
time. Whew Hoo! If I use my ADO.NET Dataset connection from my "Current
Connections" or from my project, I GET N-O-T-H-I-N-G. By 'nothing' I mean
when the report is shown in the report viewer, not one piece of data shows
up.

I cannot use the ones that work unfortunately because when this entire
project is complete, the Access DB may reside on a network drive (ie.
M:\InventoryManagement.mdb) These paths that are created, I wouldn't know
where to begin to modify them.

How do I fix this $%^&*#@ problem??


Tony K

.

Relevant Pages

  • Re: Report parameter "too complex"
    ... It's the result of the following calculation: ... and the query below returns the correct data for all years, ... The report will not. ...
    (microsoft.public.access.reports)
  • Re: Frustration and Excitement with Crystal Reports
    ... data in it to report on. ... 'you may have to fool with the right hand side to get the right connection - ... Right click on the Database Fields. ... Select "Set Datasource Location". ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Report parameter "too complex"
    ... It's sometimes possible to fix this problem by formally declaring the parameteryou are using: ... Query returns the correct data set. ... Report based on query contains the same fields except cancelled and closed. ...
    (microsoft.public.access.reports)
  • Re: Am I attacked ?
    ... found no logic) TCP ports, to various ports, and it wasn't blocked!?! ... What should I do about that belgium intrusion (report? ... "Zebedee" a écrit dans le message de ... > blocked those connection attempts:) ...
    (comp.security.firewalls)
  • Re: Virgin Media team up with SamKnows to see who is best? Virgin media come out tops!!
    ... My observation last year of the 20Mb/s line last year was that congestion in peak times regularly slowed the per connection speed to between 1-2Mb/s. ... This was a good report, I believe it was after this report that interested parties, such as VM, started funding Samknows. ... However much of my internet usage involved single thread operations such as video streaming and this meant the the VM line significantly under performed a 4Mb/s DSL line. ... So given that and comparing it to those mealy mouthed "up to" speeds ...
    (uk.telecom.broadband)
Loading