473,503 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

crystal shows all records when setting datasource at runtime v1.1

I don't know if this has been addressed in some other form/forum but
we tried what we thought was everything. I apologize if i'm being
redundant.

We build reports like so when they require passing parameters to limit
the results:

One person develops the report layout using a view.

The other person creates a datatable at runtime from a stored proc
call. The stored proc uses the same view that was used to design the
report. They then assign the datatable to the report datasource and
the report to a viewer.

Why? Not sure. I just like things compartmentalized I guess.

Anyway, this all worked great... until we deployed it. The reports
would ignore the results from the stored proc call and just always
return ALL results from the base view.

It worked on our dev machines but refused to work on any client config
we could find (aside from installing the .NET component update CD on
all the client machines. not an option)

For those of you that are trying something similar and find the report
displays ALL the design time datasource's results instead of those
from the run time datasource when deployed to the client...

Deploy these Visual C++ runtimes files into your app's directory:

msvcp70.dll
msvcr70.dll

crystal will find them and the run-time datasource will start working.

(RE: crystal.net deployment: wasn't something said about "no-more
dll-hell with .NET"? funny thing, i never experienced it until .NET)
Jul 19 '05 #1
0 1631

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

Similar topics

5
2996
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields...
4
1130
by: Grant Stanley | last post by:
I'm developing an application in VS.Net 2003 using C#, which uses Crystal Reports. When creating each report, crystal asks where the database to use is, so I specify our SQL server using the ADO...
0
290
by: Slonjo | last post by:
I don't know if this has been addressed in some other form/forum but we tried what we thought was everything. I apologize if i'm being redundant. We build reports like so when they require...
3
16804
by: lee_mcknight | last post by:
I am using Crystal Enterprise V9. I have a report that needs to have multiple datasets as the datasource(s) on a single subreport (some common lookup data I need to join to is stored in a seperate...
12
10360
by: Bill Nguyen | last post by:
What's the VB syntax to run the CR report using the following SP? I use CrystalreportViewer and ReportDocument. Thanks Bill Here's the SP in SQLserver 2K: CREATE proc mysp_ReportSubmission...
2
8544
by: runningdog | last post by:
Hi, I'm trying to set the servername and database for an untyped report at runtime. It seems I should do something like the following. Dim Table As Table Dim LogonInfo As New TableLogOnInfo...
7
6689
by: Jlo | last post by:
Hi, I have a c# winforms application. When I call the report file, it shows me all the records in the table. How can I make it to call only a particular range. i have the following code...
2
2852
by: Screaming Eagles 101 | last post by:
And if it's possible, how can I do this please ? -- Filip http://www.ww2airborne.net/ Official Site of the 101st Airborne - 463rd PFA skype: airborne463pfa-fiwi ...
8
3052
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...
0
7188
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,...
0
7258
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,...
0
7313
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...
1
6970
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...
0
5558
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4987
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...
0
4663
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...
0
3146
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1489
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 ...

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.