I want to hide or show Drill down Details section in crystal report while runtime. Maybe a checkbox from a from a form or soemthing like that. How can i do that.
View 1 RepliesHow can i set a fixed height detail section in crystal reports regardless of record count.I set the height of detail section to 10 records. If i put 8 records, the space for other 2 records should be white space. That is, total height remain the same.
View 8 RepliesMy stored procedure return 2 set of data.Select * from customersSelect * from productsnow on the report, I can see all the fields of table customers and products in the "Field xplorer".How can I display all the data in the table customers first, then display the products right after?
View 2 RepliesIs it possible to rename a report section in a crystal reports using the version of crystal that is built into Visual Studio 2008?
View 2 RepliesCrystal Report is repeating values like this:
1 rar
1 rar
1 rar
1 rar
1 rar
I want the output to be like this:
1 rar
I wrote code like this:
Dim crParameterFieldDefinitions As ParameterFieldDefinitions
Dim crParameterFieldDefinition As ParameterFieldDefinition
Dim crParameterValues As New ParameterValues()
Dim crParameterDiscreteValue As New ParameterDiscreteValue()
crParameterDiscreteValue.Value = Label1.Text
[Code] ......
Suppress Column in Crystal report Group Section
View 5 Repliesso I have a template in Crystal reports using vb.net, I changed my data source location and that source still contains the needed tables for my report, the problem is this... My original template displays the exact report but when I changed its data source it duplicates the data in the details section(e.g I made a query that will show 1 item only,but instead I get 4).
Here is a screenshot of my problem: [URL]
I want to alter the template rather than to make another one
I am trying to grasp how to include a Crystal report in a program written in Visual Studio 2010.I have created a form in the program and included a Crystal Report Viewer on it. When I create a new Crystal report using the report wizard all seems well. However, when I debug/run the program I am asked to provide the database login ID and password. The database I am using was created with SQL Server 2008 R2, and was never created with login credentials.
I believe the problem is in the Crystal Report Viewer opening the report but have no clue about what steps to take to correct this. When I run the program with the Report Viewer minus a Report, the Report viewer runs successfully. But when I include a report it asks for the login ID and password.
I have a table there in SQL SERVER 2000 which has five fields[date income amount expense amount]. Now user wants to input first date & last date there in form to show records ok? To show record by one paraemeter was easy for me & I did it by following code. I mean I made one parameter & got one form with one text box & one button & one report viewer. Let me show you my code for button event what I used to show report by one parameter.
[Code]...
I would like to add an image to a crystal report at runtime.
I am currently doing this using a second data table containing only a byte field and then a blob field on the report. However this feels like a hack and if there is no data in the first primary table then for some reason the image does not show.
Is it possible to add an image with code or another method?
I'm using crystal reports for visual studio 2010. Winforms project. Either C# or VB.
Ive been trying to figure out what report I should use as it appears I have crystal reports built in and also have Microsoft Report Viewer in this VB 2008.What I need to do is give the user a list of names and when a ame gets clicked it will show all the details in a report.I have loaded a ListView Control with the names from my database and this is letting the user pick a report so I can get the name and ID number of the record to show this way and just need to figure out how to get that record onto a report and what report to use?Ive done similar in VB6 but have never looked at .Net. The data is comming from an access database.
View 2 RepliesI am using Microsoft Visual Studio 2008 and want to design my Dynamic crystal reports. In vb6 i normally did this via bounding each control of the section1 ,2 or 3 via run time code by giving the name of that control something like
.section3.controls("txtName").text=some value
can I did the same with crystal reports as well in VB.Net if yes than how.?
I have 6 to 7 tables with state information in them. They all have the same field names. I have a Crystal Report that is based on one of them. I want the user to be able to select a state and change the Crystal Report to use that table instead of the one it was based on.I mean when user select text in combo box and then click on "OK" then report show (using only one rpt for all the tables of same fields).i have the database name"Rajab" in which the all the tables have same fields and structures now the problem is that i have designed an rpt now i want that if user select any table from the list of combo box then through this rpt the data of every table shows. how can i use that rpt for every table because i don't want to use seperate rpt for every table i want to use only single designed rpt for 6 to 7 tables.
View 2 RepliesI have to change my sql server and need to point all my crystal reports to that new server at runtime, some reports has StoredProcedures embeded inside and those are the problems.[code]....
View 2 RepliesI have a report and is working with .netnow i needload images in runtime by passing the values in .net or load the image by dbthe control that i using isthe crystal report viewer, i have found codes in the web that refer this:
"crxReport.Sections(3)""CrReport.Sections("Details").ReportObjects("Picture1")=? "
but with the control what i using i dont have that option :(what is the control that i need load to the project that have that options?or is some especial version of crystal report?
Can any one provide me with the Crsytal report runtime installer for Visual Studio 2010.I have the installer of Visual Studio 2008 but its of no use.I need the installer that is the .msi file.
View 3 Replieson first form one textbox and one button present and in second form crystal report viewer is present in first form textbox i write query and when i click on button i want report in second for with data returned by query
[Code]...
I have a simple application with a crystal report in there. So, the crystal report runtime must be installed on the clients which use the app. Now i have create a setup.exe and under "Required Components", Crystal Reports Basic... is marked. I choose the second option below that Crystal Report should come from the identic folder. When i call the setup.exe or the *.msi file the app is installed under programs but without crystal reports.
View 2 RepliesAfter several hours of searching the internet I could not find any Report Viewer tutorials that show a project that contains a parent/child report. I'm using rdlc report files.I can create a single report but we want to create a report that shows shows invoice header information followed by the invoice details followed by the next invoice header and details and so on.
If a sample project is not available, do you know of an online tutorial that shows how to do it?I saw something that might help on gotreportviewer.com about subreports, but it's in C# and not VB.Net so I could not figure out how it works.
trying to simply change the Server Name for a Crystal Report at runtime and it will not let me. Herthe code below. The database is identical to my development server database. I use SQL Server 2005(SPK 2) and Visual Basic 2008. I use Crystal Reports 2008. When I run the code it accepts changes to the user name and password but igmores any change to the ServerName or DatabaseName
View 5 RepliesIn my project i have a requirement where in I have to show PDF file in a crystal report. A user will upload PDF file in my application and that PDF should be shown in crystal report. I tried out by extracting all text from pdf file and then displaying it as a text in a crystal report. It worked but while doing so it extract only pure text, all formatting(i.e. table etc) are removed.
View 2 Repliesi have code in which datatable values will be given in crystal report of vs2008 iam very surprised when i run my application in debug mode by pressing f10 key value all the value loaded perfect but when i start application in normal mode only one value of datatable is loaded what should i do like ?
description qty price total
pepsi 2 4 8
tea 1 2 2
in debug mode pressing f10 it show all the values but in normal mode it show only first value pepsi 2 4 8
why my crystal report dosesnt show any of my data.
View 2 RepliesWe are bysy with making a crystal report in vs2005 / 2008
We want to print the address of a bussiness, see picture-1.jpg
If field-2 of the second record isnt filled in we get the the result see picture-2.jpg
In the crystal report we don't want to show the empty information of field-2, see picture-3.jpg Is it possible to create this in a crystal report?
When logging into my system, I select the number of result that needs to appear on the report. In my stored procedure it selects count of all the data for a period. It returns all in the information, but I only want the number of records to appear on the report that I selected at the beginning.
View 1 RepliesI have a parent and child report that I created in visual studio 2010 using winforms in vb.net. I have setup one text box in the parent report to go to the child report with the respective value as the paramter. However, when I click on the link I get the error:a data source instance has not been supplied for the data source 'dataset1'I realize that the dataset1 has to be filled, however I cannot figure out how to fill dataset1. I have researched the topic cand came with the following links:[URL]...
View 1 RepliesFor some reasons I'm getting no data populating in my crystal report. I have set the datasourse of my crystal report to the dataset. I filled my dataset with data straight from the database. My dataset is not empty, I always check it first before populating data to the my report. I built my crystal report off the wzard and I did add
View 3 Repliesshowing multiple items from listview to my crystal report. Or something like after searching some items, the results are the one to be displayed in crystal report. I don't have any codes yet. I'm using OLE DB Connection.
View 3 RepliesI can show information by specific ID there in crystal report by following code.
[Code]...
I've a VB.net 2005 desktop application, and i'm using crystal reports. In one report i've abt 6-7 sub reports. is it possible to show/hide a sub report based on some condition. i'm new to crystal reports , please suggest what is the best possible way to achieve this.
View 1 Replies