473,772 Members | 2,349 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need your help regarding integration of crystal reports with c#

153 New Member
Most of you people are already familier with the working of crystal reports unlike me.I am working on an application when I have no other option but to use CR.

It is very diff. for me to read an entire book on CR for a simple report, so I thought if you people can help me :)

Here is the table structure.



I opened the crystal reports in VS 2005 and added the crystal report and using the Database Expert selected the fields I want.

I was worrying about the deployment but I was relieved to find that the connection string gets stored in app.config.

I needed two reports , one with grouping(Based on Ext_Number) (for a summary report) and one without (for a detailed report).

So I added two reports and in one report grouped by Ext_Number and one without.

In both the reports I need to add the where clause

Where Trunk_Number IN ( <param1>,<param 2>,..... ) and Ext_Number IN ( <param1>,<param 2>,..... ) and Called_Number IN ( <param1>,<param 2>,..... and Cost < < > < >> < => )

I dont know how to create the parameters in c# (complete layman).

I guess it would be something like
Reportname.Show ( " comma seperated list of Trunk_Number" , " comma seperated list of Ext_Number" , " comma seperated list of Trunk_Number" , <confused about the less than, greater than and equal to operator >)

I need help about passing parameters in my case.
Looks time consuming but I will be of much help and use for me.


Thanks and regards.
Feb 13 '09 #1
0 1352

Sign in to post your reply or Sign up for a free account.

Similar topics

5
1818
by: Scott | last post by:
Can anyone tell me if the MS Visual Basic .Net Standard IDE contains the necessary modules to integrate Crystal Reports into a distributable app?
1
1104
by: Gidi | last post by:
Hi, I have some tables which represent reports the user asked for, and i want to give him the ability to print them (with a printer), till now i painted the tables by my self and draw the results into it. but i understand that with crystal reports it will be better and much more easier. where can i learn about working with crystal reports and Sql Database?
0
1334
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...
3
2825
by: Russ | last post by:
I have a page that uses crystal reports to generate reports from a SQl server database. As of a week ago everything was working fine, but now I am all of the sudden getting errors. To the best of my knowledge nothing was changed on the server. Here is the error: Error in File C:\DOCUME~1\WEBSERVER\ASPNET\Local Settings\Temp\temp_57908cf8-dba0-4327-b785-95de5cf6e523.rpt: Invalid export DLL or export format.
6
4997
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing for long running reports. When the processing is complete it uses crystal reports to load a template file, populate it, and then export it to a PDF. It works fine so far....
1
1034
by: Ravimama | last post by:
Hi Guys, I have to generate mailing labels for selected addresses using crystal reports. I am loading all the names of the vendors in a checked list box. the user will select a few of the vendor names. I want to load the 5 selected vendors in the mailing labels in crystal reoprts. The crystal reports is designed at design time. I have already used a method where in I am trying to get the Ids of the selected vendors in a string, and I...
0
2135
by: Swaroop Bhattacharyya | last post by:
I want to access IBM DB2 CLP from Crystal Reports.This is for schedueling a job in Crystal Reports. How will i link the Crystal Reports and the IBM DB2 CLP ?
11
2910
by: NewGuytoNetworking | last post by:
I have an XML that my company sends out daily it used to be created by SQL but I now have to use crystal reports and I can't seem to get it to line up the same. Please help with any references or how to rewrite my schema. I will try to provide pictures of what currently have. (This is Mine from Crystal Reports) <?xml version="1.0" encoding="UTF-8" ?> - <BSASStockStatus xmlns="urn:crystal-reports:schemas"...
1
1534
by: faisalmushtaq | last post by:
Hi all, i am facing a problem regarding crystal reports.i am working on a software which contains a large number of crystal reports.A user might open a large number of reports having different information.When i view in Activity monitor of SQLSERVER2005,my software has a session with db server(its ok,as i have made it run seperate) and each report has its own session(its ok aswell).The problem which i face is even after closing report the...
0
9454
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10106
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
10039
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
9914
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
7461
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
6716
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
5355
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
3610
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2851
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.