I am using ssrs 2008. My Report can generate 5000 Record count , 10000 Records count or more than 10000 records count.
When i am rendering large reoport above 10, 000 record count i am getting timeout Exception error.
how can i avoid that exception..?
i read through some forum can genarate one report into mulitiple reports by dividing the record count.
how best i can work on Rendering Large reports.
I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.
View 1 RepliesIam working on a banking web application developed in asp.net 3.5 and MS SQL Server 2008.My problem is to create reports including some pre-formatted reports,summary reports and some detail reports.I want to know what is the best technique to create these reports.I don't want to use third party reporting tools as they have to be configured on the web server and some times they takes lot of time in generating reports due to their complex structure.Since its a web application having large recordsets so i need a consistent solution keeping in mind the performance and complex nature of the reports which might be demanded by the banks.Can anyone help me please in this regard?
View 2 Repliesdifferences between ssrs reports and crystal reports?
View 2 RepliesI have a report displaying the data for an employee. If I wish to generate report for 2 employee, how I can do to make a single report contains both the data? (e.g.: 1st page display data for 1st employee; 2nd page display data for 2nd employee and so on) I need them to be in the same report/pdf file.
View 3 RepliesI am programmatically exporting multiple reports to a pdf via the ssrs web services using C#.Net. It exports a single report just fine, I was wondering if there was a way to export multiple reports? I tried block copying the byte arrays from all the reports into a single byte array, but it only displays the last report.
View 1 RepliesI am using one ReportViewer with already established SQL Stored Procedures connected to three report files (*.rdlc). There are three radio buttons which are to be associated with each report that needs to be displayed in the ReportViewer. Here is an example if a radio button is selected:
[Code]....
The ReportViewer works for the first radio button selection but then for the other selection I get the following error:
A data source instance has not been supplied for the data source 'spEx1'
I have requirement that have to add header and footer into 50 over reports. So I dont want to change one by one.
Is there a way to create master page header and footer and used it in multiple reports?
Is that possible to open three reports in the same window ? Can be using the group tree or the tabs beside the MainReport.
The reports used to be open in excell and the file has three worksheet, now we want to change them for Crystal Reports, thats why were created three reports, but it must be open the same was the excell format, with three worksheets.
We are developing the asp.net in VS2010 with the CR2010.
Is it possible to show 3 "Crystal Report" in single "Report Viewer Control" page??My current code for 1 Crystal Report and 1 Report Viewer control Page is below:Below code Page name is "JpsCrystalReport.aspx"
using CrystalDecisions.CrystalReports.Engine; //for crystal report
using CrystalDecisions.ReportSource;
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString);
[code]...
I want that when i click on button it redirects to "JpsCrystalReport.aspx" page as per condition given. Then on "JpsCrystalReport.aspx" page it should execute the 3 crystal reports as per conditions given on button click.Or I had to create 3 different "JpsCrystalReport.aspx" pages (that contains Report Viewer control) to show 3 Different Crystal Reports as per condition on button click?
using crystal report in VS 2005 C#. I want to print multiple copies(3) of a same report in a single page. Is is possible.
View 1 Replieswhat would be the user name and password of http://localhost/Reports to access SERVER 2005 Reporting service
View 7 Replies[URL] ....
I followed above link to create sample Crystal Report Project. Here is my code:
string conStr = ConfigurationManager.ConnectionStrings["MasterDb"].ConnectionString.ToString();
protected void Page_Load(object sender, EventArgs e) {
ReportDocument crystalReport = new ReportDocument();
crystalReport.Load(Server.MapPath("~/CrystalReport1.rpt"));
DataSet1 ds = GetData();
crystalReport.SetDataSource(ds);
[Code] ...
When I run my project, blank page renders. No Crystal report is displayed.
I have a button and gridview with one of the columns contain checkbox. If the User checked the checkbox and clicked the button, the id is stored as a DataKeyname and it will be passed as a parameter to the crystal reports and the report will be opened as a pdf. So far I have done for single report. But now if the user checks multiple checkbox, the corresponding reports to be opened as a combined pdf as next next pages? How to do that?
View 1 RepliesI'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I was very happy that i can generate reports in ie7
after updating to ie 8 things has gone wrong :(
I am generating 9 different reports
user can select one report and can generate the perticular one.
But in ie 8 i can generate only first report
even if i select the second record it generates only the first
It seem some problem.
i can gethe second report if and only if i refresh report page
what can i do?
(note in adavance:I dont have a doc type in my page )
I can display reports as pdf's through the code no problem but my aim is to be able to display multiple reportviewer reports in 1 pdf but even when I fill the memorystream with 2 lot's of reports, it still only displays one as a pdf.
A snippet of my code is below:
byte[] bytes = rptViewer.LocalReport.Render(
"PDF", null, out mimeType, out encoding, out filenameExtension,
out streamids, out warnings);
[code]...
If I have an XML file, can I use it as a datasource for a RDLC file?
View 4 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 Repliesconsider the example where there is a report which displays all products or a single product from a table through a drop down list selection. The dropdown list also has a '- ALL -' selection item So the resulting query might be
Select * from products OR
Select * from products where ID={id}
Now I have a single report , I am using sql CASE for differentiating between all products or a single product. Another approach is to pass a different value with where clause in report parameters like
[Code]....
What I like to know is what is the best approach? Is doing this inside query is best or specifying the where clause in the report parameters is right? I personally feel much safe with the SQL query CASE.
I am trying to use a parameter field where there is a subreport in my main report but i keep getting the error "subreport cannot be shown" when running the report.
p.s - I have just set the parameters the same in the subreport as the main report.
I have two reports but i want to use the same crystal report viewer to display both reports depending on an option selected. How can I achieve this?
CrystalReportViewer.setCrystalReportSource(CrystalReportSource3) or something like this i am just not sure about the code in c#
I have master page, menu on master page, i use asp roles and trim menu item based on user roles and rights this process is working fine.
Now i have to create some reports based on user roles, and responsibility in a company like country head will view country wide reports, manager region will only view regional report and rest will view reports related to them.
How can i achieve this efficiently using asp roles.
I am using crystal report Xi release 2.
How can I change my reports English to Arabic language?