I have included 5 tables in my crystal reports as follows
I have added the first four fields in patientdetails table in the header of report, which is displayed properely.
when I add the fields from bloodinfo table I can view only the fields of the 1 st patient, that too 4 times.
almost every patient has the data under bloodinfo but I can view only of one.
I am working on Crystal Reports 8.5 and SQL Server 2000 as backend. I have a stored procedure which has been added to the Crystal Report. So that fields are visible in the Fields object section from where i can drag and drop the fields on the report and display it. But now as they want more fields i have written two select statements for displaying required fields. But these newly added fields are not visible in the Fields object section in the Crystal Reports. I have done verify database, removed and again attached the SP but the problem is not solved.
View 1 Repliesusing vs.net 2005, sql server 2005, creating windows form appI have a dataset that I bound to a crystal report as follows:
[Code]....
and in the Crystal Report in design view I added a Text Object called "myTxtObj".I am assuming that I can do something like this
[Code]....
However I'm not seeing the "myTextObj" with intellisense in the code behind in the form.so my question is: after binding a dataset to a report how to you bind column values to text objects on your crystal report?and actually one mor thing:I just ran the project and found out when I try to do the databind that i'm getting an error:"The report has no tables"how to solve this too?
can we build a crystal report with variable fields. that is, choosing multiple fields from the same table from a previous page through check box, and these chosen fields are the ones to be shown in the report.
View 2 RepliesCrystal reports are properly working on my local pc but not on server. I am using vs 2008 and install crystal report for Visual basic 2008 on server.but parameter count for CrystalReport is zero on server.
CrystalReportViewer.ReportSource = Session("Rpt" & Request.QueryString("ReportGroup") & Request.QueryString("ReportCode"))[code]....
I'm trying to print my crystal report without having to display it on my browser by having the user click a button, however, I'm getting the following error:
Error in File C:DOCUME~1HESPIN~1LOCALS~1TempCustomerReceipt
{7E65DCC0-46B5-4D06-92FB-5BC201A6AB3F}.rpt: Unable to connect: incorrect log on parameters.
Here's my code (I created the report using the wizard and has a parameter that filters the data in the report):
Protected
Sub PrintReceiptButton_Click(ByVal
sender As [code]....
Is there a way to dynamically create a report?I have the following tables:
[Code]....
Obviously, this is quite straight forward if I could restrict the limit of the sizes, but they want the flexibility to add sizes, particularly with footwear or if they should need to add women's dress sizes.So the problem is that I'm generating dynamic table columns (the number unknown) during run-time.
in my project iam providing users to send sms acrooss india..in admin panel the admin have a feature to check the usersent sms details on the basis of userid.. when admin selects the userid then corresponding send sms details are details are displaying.. my requirement is generating the crystal report for that table..the users are displaying from one table and sent sms details are displaying detaials from another table.. how to generatye crystal report for that..and how to give formula fields in crystal reports
View 1 Repliesusing vb.net 2005 and crystal reports I added a server and db to my crystal report and I can see the table and fields in the server explorer. Also in "database expert" I added the table that I want to display data from. The question I have now is how to I display fields from this table on my report? I thought I remembered simply dragging and dropping a field onto the report from the table but not able to do that now
View 1 RepliesI want to add a Dynamic column in Crystal report at run time. Because I dont know about the columns in design time. The columns will come based on the user selection.
So i want to Add a column to Crustal report at run time. I am using Crystal report. If it is not support to add column in Crystal report at runtime.
I am working on Crystal reports.My requirement is that i need to generate dynamic fields according to the count ofFamily_Members column in sql server database,for example if i have '4' in 'Family_Members' column i need to generate 4(Family members details)dynamically.
View 1 Replieshow can i get and set crystal report formula fields from c# code behind, i use this code, double sum=reportdocument.datadefinision.formulafields[1].text but it get formula text not value
View 2 RepliesI tried using this and am concatenating the fields together. It does not appear to be working. Here's what I have.
View 7 RepliesI have a VB.Net application which generates quite a few Crystal Reports. One report in particular has a Group Section. What I am trying to do with my VB.Net app is pass a value (a sql server column name used in the report). This value is represented by radio buttons. For example, the user may check either "ZipCode" or "State" or "Category" or "Type" or "Vendor". Each of these options represent a column in the database table used in the report. I simply want to be able to write the "SelectionFormula" using one of these options but not sure how to go about it.
View 1 RepliesI am using crystal report to display one filled application form, once the application is filled the data is saved in table and report is generated and is converted to pdf and send to supervisor email address... Till here all works good, but if the supervisor edits the application same data is updated in the table and report should be generated with highlighted updated fields in application and bieng send as attachment to clients email address...
View 1 RepliesWhen i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 RepliesI have selected the tables using the wizard, but for some reason CR doesn't display all the fields in the tables, so there are some tables in Field Explorer that lack some fields. The fields that aren't shown are both int, and varchar, some of them allow nulls and some of them don't, I can't seem to find a pattern as why some fields aren't loaded into Field Explorer.
View 4 Repliesi created a crystal report in my project . that is report worked fine if i run in debug mode(F5).then i created a virtual directry "myweb". if i run it from the browser like "localhost/myweb".. Data is displaying properly.but crystal report header images are not displaying. and i am not able to export & print.i have "aspnet_client" in www root folder. crystal report images and hava script files are exists in below path
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727ASP.NETClientFilesCrystalReportWebFormViewer3
I have a crystal report viewer on .aspx page. When the report is loaded, the report shows but toolbar not displaying, no buttons, borders or scrollbars.But with reports which open in new blank,everything's fine..the toolbar, buttons, borders and scrollbars all show perfectly.
View 3 Repliesi have a crystal report and now with using crystal report viewver want to display it on page. I want to display the crystal report when the page is loaded. so i have placed a crystal report viewver in the page and wants to put some codes in them. what vb.net codes i have to put on the page load for displaying the crystal report.
View 2 RepliesI am trying to create a report which is composed of all of the months in a year. My biggest problem is that we do counts for each month. These counts shouldn't change for previous months. They should remain static. But when I run the current month, I want to display the values in the previous months plus my current value. Do I need to create a formula for each month of the year or is there an easier way to capture this information?
For example:
The end of the fiscal year is July 11. I want to check my values for February to see what accounts are open and counted for this month as well as the accounts that are still open from January. These would all display in February. But I want the January account to report the same number (all accounts open in January) it held when I ran it in January. I want to do this for the entire year.
That's pretty much it. A graphic in the header shows fine in CR Developer (2008), but doesn't show in the web report viewer control.
The data in the report looks o.k., it's just rendering a broken image when I test the report, with an address like this:
http://localhost:52491/CrystalImageHandler.aspx?dynamicimage=cr_tmp_image_bd87400a-878c-49de-979e-5ab0d4db8c80.png
I put my project on our webserver and rigged up a test URL, same there--so it's not restricted to the project being run out of VS 2010.
I have data in 2 rows with 1 booking no each rows have different data. But when trying to view crystal reports shows only top row data.. i want 1st row data should come on 1st page and second row data on 2nd page.
View 1 RepliesIn my application, there is only a login page and a report page. When the user enters his login credentials he will be redirected from the login page to the reports page. I am using forms authentication for this purpose.
On the reports page I will be displaying various reports (using Telerik reporting) based on user inputs for various fields.
Now here is the funnier part; My application works correctly in all browsers (including Safari on windows platform). But when I open it in an Ipad I am getting the below error,
"Potentially dangerous request.form value was detected from the client " This error occurs when the forms authentication redirection happens from the login page to the reports page.
I tried a variety of solutions like setting ValidateRequest="false" & requestValidationMode="2.0" , but none of them helped. I also tried removing the forms authentication and that also didn't
I want to show Sum of one of the fields in page footer in Report1.rdlc.
View 2 Replies