473,698 Members | 2,370 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Crystal Report with Visual Sutio.NEt 2003

GC
HI,

I'am using Crystal Report with visual Studio .NEt 2003

When i make a report using a store procedure, I can not see all the fields
of the store proc and i'm suppose to see those fields. I'm suppose to see a
"+" sign at the left of the store procedure name in the Field Explorer section

When we click on the sign "+" we see all the field of the store proc.
We can from there select and drag those fileds on the report.

My problem is that there is no Sign "+" at the left of the store procedure
name in the Field Explorer section

I had this problem with Visual studio 2002 and i resolve it by installing
the crystal report service pack for Visual studio 2002.

I did the same thing with Visual studio 2003 but the problem still there
after installing crystal report service pack 2 for visual studio .net 2003

Do you have any idea of what i can do!
Oct 6 '05 #1
2 2377
try doing a "verify database"....if that doesn't help, try the "log on or
off server" or "set datasource location" and make sure the dataset is
available to you.

hope this helps.

george hardy

"GC" <GC@discussions .microsoft.com> wrote in message
news:10******** *************** ***********@mic rosoft.com...
HI,

I'am using Crystal Report with visual Studio .NEt 2003

When i make a report using a store procedure, I can not see all the fields
of the store proc and i'm suppose to see those fields. I'm suppose to see
a
"+" sign at the left of the store procedure name in the Field Explorer
section

When we click on the sign "+" we see all the field of the store proc.
We can from there select and drag those fileds on the report.

My problem is that there is no Sign "+" at the left of the store procedure
name in the Field Explorer section

I had this problem with Visual studio 2002 and i resolve it by installing
the crystal report service pack for Visual studio 2002.

I did the same thing with Visual studio 2003 but the problem still there
after installing crystal report service pack 2 for visual studio .net 2003

Do you have any idea of what i can do!

Oct 26 '05 #2
GC
Thank for helping me

I Find the problem

The problem was the store procedure
For performance reason I optimise my store proc by using Virtual Table
I at the end of my script I make a Select on 3 virtual table

The performance is a lot faster but Crystal report dont seem to know what
are the final field to show in crystal report.

So with a simple select everything is fine
The work around is to insert the result of my store proc in a real table in
the database only for this report

And use another store proc for the report that make a simple select on this
table

Thank for your help

"George Hardy" wrote:
try doing a "verify database"....if that doesn't help, try the "log on or
off server" or "set datasource location" and make sure the dataset is
available to you.

hope this helps.

george hardy

"GC" <GC@discussions .microsoft.com> wrote in message
news:10******** *************** ***********@mic rosoft.com...
HI,

I'am using Crystal Report with visual Studio .NEt 2003

When i make a report using a store procedure, I can not see all the fields
of the store proc and i'm suppose to see those fields. I'm suppose to see
a
"+" sign at the left of the store procedure name in the Field Explorer
section

When we click on the sign "+" we see all the field of the store proc.
We can from there select and drag those fileds on the report.

My problem is that there is no Sign "+" at the left of the store procedure
name in the Field Explorer section

I had this problem with Visual studio 2002 and i resolve it by installing
the crystal report service pack for Visual studio 2002.

I did the same thing with Visual studio 2003 but the problem still there
after installing crystal report service pack 2 for visual studio .net 2003

Do you have any idea of what i can do!


Oct 27 '05 #3

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

Similar topics

1
19170
by: Stephan | last post by:
Hi, I'm using Visual Studio 2003 (C#) with the integrated Crystal Report software and have the following question: How can I assign a value (string) to an unbound (string) field in Crystal Report at runtime? Example: private void button1_Click(object sender,
4
14277
by: Rick Thiel | last post by:
Hello, I am trying to build a Crystal report VisualStudio.NET for an ASP.NET application. I would like to build a report that doesn't connect to any particular database at design time because I am planning to pass a dataset to the report at runtime. From what I have read, it sounds like unbound fields might be the answer. However, I am having trouble figuring out how to bind these unbound fields to my dataset at runtime.
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...
6
4115
by: Dr. Indera | last post by:
hello, much to my surprise, the version of crystal that comes with visual studio.net 2003 does not have a report preview window. i found out that i have to build a form in visual basic.net and use the crystal view object to be able to view forms. the form works fine for me, so i created a .exe of the form and emailed it to a friend because i thought they would be able to use the form/.exe without having visual studio.net installed. that...
0
1932
by: sztonix | last post by:
Hi all, I encountered a crystal report deployment problem. I make reports with Crystal Report for Visual Studio .NET 2003. It works fine in the development machine. And then make setup package. Installed on a windows server 2003 system (without visual studio .net 2003), the report gives error about "Logon Failed". The data source is specified to OLE DB SQL Server, and the LogOnInfo is specified by
0
1328
by: SWu | last post by:
Hi all Could someone please tell me how to configure and deploy my Crystal reports? Any help would be greatly appreciated. I want to be able to deploy my reports/web pages to another domain, web server, database and have the report connect via integrated security. 1. I have created a stored proc in my SQL Server db, created a report in my ASP.NET project, created a reports.aspx and placed a CrystalReportViewer on the page. This is...
0
1450
by: Crystal Report - LoadSaveReportException | last post by:
I have a web system which will display a crystal report for clients. It is written in Visual Studio 2003, VB.Net and Crystal Report which comes with VS2003, running on Windows 2000. It works very well. Now we moved it to Windows XP and I cannot run the report again at design time. There is no change to my code. I got the following error: The LoadSaveReportException: Load Report Error. I searched all possible answers through the web. It...
2
338
by: GC | last post by:
HI, I'am using Crystal Report with visual Studio .NEt 2003 When i make a report using a store procedure, I can not see all the fields of the store proc and i'm suppose to see those fields. I'm suppose to see a "+" sign at the left of the store procedure name in the Field Explorer section When we click on the sign "+" we see all the field of the store proc. We can from there select and drag those fileds on the report.
2
7241
by: Jason Huang | last post by:
Hi, The Crystal Report bundled with .Net 2003 is version 9. How do I update the Crystal Report V9 in my .Net 2003 to Version 11 so that whenever I open a .rpt file in my VS 2003, the Crystal Report V11 will come out? Thanks for help. Jason
0
9157
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
9026
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
8893
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
8861
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
6518
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
4366
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...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3045
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
3
2001
bsmnconsultancy
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...

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.