I have created a cross tab however if I have a firstname field it merges the rows together if there are two names which are the same. How do you get it to display the names in the each row. In the example below Sarah is not displayed twice as the cells are merged together. Firstname Lastname Judy Collins Sarah Dane Smith Joe D...
Hi, Im using vb.net and I need to fetch data from two different tables and display it in form of report. These are the schemas and data of my two tables: CREATE TABLE personal_details (staff_ID integer PRIMARY KEY, title varchar(10), fn varchar(250), ln varchar(250), mn varchar(250), dob varchar(50), hometown varchar(250), securityno...
I have about 15 .RPT files on my .NET 2.0 site, and I recently changed to a new database server. I successfully changed the Datasource on 14 of those .RPT files, but on one, after making the change, I get "Failed to Save Document" when I try to save the updated report. I can change the subreport's Datasource, and save it just fine, but...
I am looking for a way to automate the production of an offline product catalog using product data contained in an SQL Server database. I have thought about using both Crystal Reports and SQL Server Reporting Services for this but there may be something better suited for the job. There is a requirement to display product images also (c...
Hi, ive being trying to cope with this problem but still. I need your help. Im having the following error message: Databind' is not a member of 'CrystalDecisions.Windows.Forms.CrystalReportViewer' in my code: Dim rpt As New CrystalReport1() Dim da As New SQLiteDataAdapter Dim ds As New presbydbDataSet ...
I want the "default printer name" on the client's computer to print the Crystal ReportViewer Content My Code : printDocument = new System.Drawing.Printing.PrintDocument(); int nCopy = printDocument.PrinterSettings.Copies; int sPage = printDocument.PrinterSettings.FromPage; ...
I am using the Crystal Reports designer that came with Visual Studio 2008. My report's data source is tied to a .Net class from my project (i.e. Database Expert > Project Data > .NET Objects). I've updated my .Net class with an additional property that I would like to use in my report. When my report's data source is tied to a databas...
In Crystal Reports 2008, there's a "Graphic Location" image property where it can be set to a file path so when the report gets run, it uses the selected picture file instead of the one on the report. I tried setting this via the .NET API, but it's only working some of the time. In the report itself, I've set Graphic Location to {@LogoP...
I want to draw a line in Crystal report. I can do that from a sub-menu but this line I need to draw in a Group section Field object with a background color property set to some color. So whenever I draw a line it gets overlapped by this FieldObject. How can I make sure that line would be visible over the background color of object? ...
I am trying to add a Database Table field into crystal report at run time. I am creating an object of crystal report viewer and trying to add dynamic field into it. After googling i found that i need to create an object of crystalReports.rpt file, which i was disable to. Refrence that I followed Please Provide me some solution. ...
I want to show image in a crystal report. Scenario is something like this. I have a database where my path of an image is persisting. eg ftp://Images/1.jpg Now i want to repeat this image in a crystal report. When i fills my datatable it shows me complete url. When i displays this field in GridView i uses imageBox to display my image...
I have a report where the fields come from data pulled from a SQL server. I have a total field that i have added to the report...however i have an interesting conundrum--i was hoping someone had a formula i could use. Three of my columns do NOT need summation...however my project requirements are telling me instead to just pull the l...
Hello all, I'm passing some parameters to a CR report programatically and it was working fine, but now that I have added a new date parameter to the report, for some reason, it is prompting me to enter that parameter on screen (the user isn't allowed to set that parameter is the system who must set it.), I haven't changed a thing other ...
In our windows application, we used crystal reports. If a customer needed a custom report, we could create it and then send them the rpt file. The customer would then simply add the report file to a custom folder, and could access it directly from our application. Using a web app, how is this possible. It seems like anything create...
We have an ASP (not ASP.NET) application running on Windows 2003 server. One of the functions of the application is to generate reports using Crystal Report 9. It has been working without any problem with .NET Framework 2.0 and now it is required to install .NET Framework 3.5 SP1 on the server but after we installed the 3.5 SP1, every t...
I've a report which shows five different activity codes. I'd like to sum all like codes and place a total for each of the 5 activity codes in a group footer. I have it working for one activity code, but would like to write a formula which will look for all five and total each. This is what I have: (if {@activitycode_id}= "Not Ready...
I have a report, and I place the same subreport within the footer twice. The report has three parameters and the subreport has four parameters. When I try to run the report through the report designer, it prompts me for seven parameters instead of the eleven I was hoping for. It prompts for one set of parameters for the subreport (wit...
I created a little ASP .Net app to run Crystal Reports. It runs fine from VS 2008 but not when deployed to IIS on Windows 7. The toolbar images are not rendered. The problem seems to be I can't read from the aspnet_client folder even though I've made into a virtual directory. I can't even read images I put in there just to see if the fol...
Hi Hope you are fine. Can you refer me any how do i video series for crystal report? Thanks ...
Hi, I have a website that generates pdf file from CSP. Will this pdf file be generated in the server before showing to the user? WIll it be saved in the server? Is there a way to copy these files? -Vivek ...