ASP.NET, SQL Server, WPF, C#, VB.NET

Hello, 
 
I have a crystal report that has 2 footers.  Footer A only shows on page 1 
 
(and looks great) using is PageNumber <> 1.  Page two has a different footer 
 
(Footer B) using PageNumber = 1.  When page two is displayed it has a large 
 
empty space at the botton of the page - like 2 1/2 inches. 
 
Any ideas how to fix this problem. 
 
Thanks, 
 
Chuck

Does anyone have a recommendation for good reference material for visual 
 
studio 2005 and the included version of Crystal Reports?

Hi, 
 
I am using visual studio.net to create a crystal report with subreport. 
 
After I add the sub report, I start to get the queryengine  error: 
 
Below is my vb code. Can somebody shed some light on this issue? I have 
 
tried all venues and no luch so far: 
 
Dim cn1 As New SqlConnection 
 
Dim cmd1 As New SqlCommand 
 
Dim ds As New DataSet 
 
Dim ad As New SqlDataAdapter 
 
Dim sSQL As String 
 
Dim adSubReport As New SqlDataAdapter 
 
Dim cmdSubReport As New SqlCommand 
 
Dim sSQLSubRe ...

i can preview the report very well in CR 
 
however, when i use vb.net to preview that report, I got the error said 
 
"Invalid Arguement"$1$1$1$1$1$1$1$1$1$1$ 
 
M1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$ 
 
M1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$ 
 
M1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$ 
 
M1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$0 ```$1$1$1$1$1$1$1$1$1$ 
 
M1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$1$ 
 
M1$1$1$1$1$1 ...

Dear All, 
 
The user should should be allowed his own time to get the 
 
alert messages. If the specefied time comes then the function should 
 
get fired to get the message. Pls guide me to achieve this. I dont know 
 
how to use timers or multithreading. if there is any sample code that 
 
would be great. Please help me. I use vb.net 2003 and sql server 2003. 
 
Also i dont know how to store only the time and how to compare the 
 
database stored time and the system time. 
 
Thanks in advance,

How do you request a date range in the record selection? 
 
StarMan

Can this be done? I've been trying to modify reports that are version 
 
10 but all I have is 32bit version 5....

I just upgraded from Visual Studio 2003 to 2005.. and I can't find 
 
Crystal Reports when I try to add item. I see add report, but it does 
 
not look like the same interface. Wondering did they drop CR under the 
 
academic version? 
 
I try opening an old project that was working under 2003, that had the 
 
crystal viewer, and it does not work. the the crystal report shows up 
 
as unknown file type in .NET solution explorer. 
 
Side question. Any reason I should not be able to open CR 8 repo ...

Hi, 
 
Iam working in a windows applnication using .NET framework 2.0, 
 
VS.NET 2005 and CR.NET 10. 
 
I have a GUI crystal report where I have inserted a chart in a header 
 
section. When I preview the report Iam getting plenty of white space 
 
under my chart. 
 
How can I supress these Sections. 
 
Thanks in advance, 
 
Bharathi Kumar.

Hi, 
 
I already have an application writtern in VB which connects to a remote 
 
database and populates the data. In order to speed up the retrieval, I 
 
wrote a C# webservice which connects to the remote database and 
 
retrieves the data. This seems to be quiet faster than the vb 
 
retrieval. 
 
But I am not able to set the xml generated by C# using the getxml 
 
method of dataset, returned to the VB call as source for my ADO 
 
recordset. 
 
Is there any specific format of XML which ADO recordset will accept.. 
 
Thanks 
 
Krish

Hi, 
 
I have automated outlook from VB application to compose a report from a 
 
database and mail to specific users. But when I call the SEND method, a 
 
popup window appears prompting me to click on YES after a few seconds 
 
before sending the mail. Due to this I am not able to schedule this for 
 
automated execution. 
 
Any clues? 
 
Thanks 
 
Google

Lady only 24-Hrs +91 9810577227

Hi all, 
 
I have a big problem working with cr10. 
 
I have a parameter @GroupBy which is number and I need on base of value of 
 
this parameter 
 
to set grouping on report, but I can't manage dynamically group setting. 
 
Data structure on report will be the same, no matter which group is, but how 
 
to force report to set grouping 
 
depends of @Parameter? 
 
I have tried to create all possible groups and suppress them depends of 
 
param values, but groups are nested. 
 
What should I do? 
 
Thanks in advance.

I get this error whenever I refresh the report viewer built in vb.net: 
 
The database driver used y this report is not supported by this 
 
product."  The tables that this report references from spans MSSQL and 
 
Pervasive SQL

I get this error whenever I refresh the report viewer built in vb.net: 
 
The database driver used y this report is not supported by this 
 
product."  The tables that this report references from spans MSSQL and 
 
Pervasive SQL

I have a crystal report (rpt file) that uses sql2k stored procedure. 
 
The stored procedure has some @ parameters. 
 
No matter what i am doing, the report doesn't move the parameters to the sp 
 
itself. I know it because i get an error: 
 
"The report you requested requires further information" 
 
When i try to monitor the sql activity, i see that the sp run by the crystal 
 
report like that: 
 
"sp_Test null,null,null,null" 
 
I am quite sure that the parameters were injected in the correct way  to the 
 
rpt file. 
 
PLZ HELP!!!!

Hello, 
 
I'm trying to use Crystal Reports in my application but I'm not sure if 
 
it's possible in Crystal to do what I need. My app generates an array 
 
of reports: 
 
Report [] rep_array; 
 
class Report 
 
{ 
 
int some; 
 
int useless; 
 
int data; 
 
} 
 
I put the reports' data to the DataSet - every report is put into a 
 
single row.I'd like Crystal to make charts of the data, but I have no 
 
idea how to make it create charts depending on row number - I need to 
 
show every row on  ...

Hi guys, 
 
Got a little query that's really annoying me! I've created a report 
 
viewer in VB6 using Crystal RDC (originally with Crystal 9) and 
 
everything worked fine. 
 
However, we're moving over the using the Crystal XI RDC and are 
 
therefore re-writing the viewer we've made, which has been completely 
 
successful apart from one area. 
 
When the report loads up, it asks for the user to input parameters. 
 
This is fine (and how we need it to act), but it doesn't automatically 
 
loa ...

hi there! 
 
can anyone help me please.. 
 
when i try to execute my program using vb 6.0 to load my report 
 
(crystal report 9.0) it will prompt me memory full error. 
 
please help me.. 
 
tnx in advance.. 
 
God bless you 
 
it's me, 
 
alex

I have completed my web application complete with Crystal reports, and have 
 
deployed it to my web server. Everything works fine, with two exceptions. I 
 
have posted these problems already with no response, but I'm having no luck 
 
finding the answer, so I'm hoping this plea will work. 
 
1) When the report prints, I see the standard navigation bar. The first and 
 
last buttons work fine. However, no matter where I am in the report, the 
 
"next page" button always takes me to page 2, and  ...

I have a web app that runs fine on my localhost. I moved it to my server, and 
 
it says it can't fine some of the crystal reports libraries. I understand 
 
this. What I don't know is, what do I need to install on the server to get 
 
these libraries? Do I have to install the whole crystal reports package? 
 
Surely there's a "runtime" set of libraries. 
 
I also have never received an answer from anyone on how I'm supposed to 
 
redirect the reports to a different database if I use multiple instances of 
 
this application.

Argh.  I have a report and a subreport, both of which have the 
 
parameters StartDate and EndDate.  I am trying to link the main report 
 
to the subreport using the parameters.  It is not working at all.  What 
 
am I doing wrong?????

I want to use a custom datatable as a source for my crystal report but 
 
apparantly .SetDataSource() only accepts the basic DataTable type.  How do I 
 
get this code to work?  Thanks. 
 
' DataSet1 is already defined with a single table and table adapter 
 
Dim myTableAdapter as New DataSet1.TableAdapter1 
 
Dim myDataTable as New DataSet1.DataTable1 
 
myTableAdapter.Fill(myDataTable) 
 
Dim myReportViewer as New ReportViewer1 
 
myReportViewer.Report1.SetDataSource(myDataTable)

I have a VB2005 application I've developed that has a form w/ a Crystal 
 
Report.  Everything works great on my machine but when I install this 
 
application on any other machine I get a database login dialog any time I 
 
try to view the Crystal Report.  The Report connects to the SQL 2005 
 
database using OLE DB (ADO) and Integrated Security.  I get the login box at 
 
other machines even if I am the person who logs into the machine. 
 
Why am I getting the login box even though I'm using i ...

I have a webservice that returns a dataset, this dataset is the same dataset 
 
that us used to create a client side xsd dataset, I then create an instance 
 
of this dataset and return the called dataset into this. But I get an error 
 
invalid cast at : "dsSuppliers = 
 
objWebservice.GetSuppliersForPrint(DepartmentID)". Does anyone know whjats 
 
causing this and how to sort it out ? 
 
Thanks 
 
Client code : 
 
Public Sub ShowSupplierReport(ByVal DepartmentName As String, ByVal 
 
Departmen ...