Ok, this might be a weird request, but is it possible to essentially flatten my dataset inside a crystal report? I have a datatable in C# that was created with a join, so when it hits the report its 2 records. Most of the columns have identical data, with the last few displaying a different address. Instead of printing the detail secti...
Hi All, I am trying to add crystal report viewer in ASP.NET 3.5 application, but its giving me this error. The type 'CrystalDecisions.Enterprise.EnterpriseSession' is defined in an assembly that is not referenced. You must add a reference to assembly 'CrystalDecisions.Enterprise.Framework, Version=10.5.3700.0, Culture=neutral, PublicK...
On my web server, which is running Crystal Reports 2008 SP2 I've been getting the error "The maximum report processing jobs limit configured by your system administrator has been reached." Having researched the topic online i came across a fix in which if you alter a registry value, specifically HKEY_LOCAL_MACHINE\SOFTWARE\Business Obj...
I have a report where it shows meetings and their requirements. However i just want the report to show ONLY today's stuff--not the entire week's worth. I tried setting my group header (i'm grouping by day) to currentdate but yet it still shows me the entire week. I then have to go to the grouping tree and select today's date. Is there...
I am completely lost on this one-- I have a .Rpt file that runs fine by itself. This report file takes 4 parameters and connects to an oracle database. I have all the database code set up correctly. So i think. I cannot for the life of me connect this report file to the connection and have the report viewed on my ASP.NET webpage. When...
select (distributor_code+ '-' +master_dealer_code+ '-' +state_code+ '-' +dealer_code) as agent_code, agent_type, company,contact_person, status, created_date as date, (CASE WHEN contact_mobile_no IS NOT NULL THEN contact_mobile_no WHEN contact_mobile_no IS NULL and contact_office_no IS NOT NULL THEN contact_office_no ELSE NULL END) ...
Hi i am working on crystal reports 11 created stacked bar chart which gives value depending on change of 2 columns. now problem is it looses color i give it... for example if pass = green, fail = red, awaiting = yellow after rerunning it for different parameters it changes to fail = green, pass = yellow etc any suggiestions? thanks ...
Hi, I've been trying to get this to work for a while, and all the example code I've seen aren't quite doing what I'm doing. I have a program that returns a pdf of a report that I pass a data table to. This works fine, except I would like to pass it a couple of other parameters (the date range of the table, stats etc) and I just can't ge...
I am having difficulties getting the following to export. I am running CR2008SP2 and ASP.NET 3.5 against an Oracle 10g database. If i do not set any of the parameters, then the page works great, and pumps out a pdf(well, except for the fact that because the parameters weren't specified, its not really the data i want. but theres no erro...
I have a report which lists out a company detail. There are two sections to the company detail. The first portion lists out environmental data and the second is actually a subreport which lists out Cash flow details for every single year of the company. I have multiple companies i need to do this for--so i grouped the report by Company...
I would like to ask , is that got possible to change the table name just by using the TABLE PARAMETER setting? but the column name consists in the both table are the same. eg: table 1(dailyregistration) table 2(dayreg) P.S: both table got same column name, just the table name had change to (dayreg) select * from ???????? ...
Using Crystal Report 8.5 In Crystal report time column values are String. I display a record order by person id. Like this. Personid Intime Outtime 001 08:00:00 17:00:00 001 14:00:00 22:00:00 002 07:00:00 10:00:00 002 04:00:00 21:00:00 ..., From the above report i need a total of Intime, total of Outtime group by personid Expecte...
Hey all, Could some one guide me to create a APS logon token in .Net programatically? I need to use this token for URL reporting.... ...
hi how to make line after 2 rows in crystal report ? ex: aaaaaa bbbbbb cccccc ddddddd (working in C#) thank's in advance ...
hi how to (count all record)/2 and show the result in the report - in Crystal Report ? (working in C#) thank's in advance ...
I'm using visual studio 2005 to develop a form with a combobox passing a value into the parameter of an embedded crystal report. I'm trying to figure out why it keeps prompting me for a database login every single time you try to run the report with a different combobox selection. Here is my code: private Sub Form1_load... ...
Right now all of my times on my reports are in GMT. Anybody know how to convert this into EST? ...
hi How to pass any text value from form to Crystal Report ? ex: i need to pass "hellow" from Form1 to my Crystal Report , how to do it ? (working in C#) thank's in advance ...
Hi All, I created a ASP.NET3.5 website having a crystalreportviewer in it, it works fine if I run through visual studio 2008 or on my own machine. But when i deployed project on web server, it started giving me error. Firstly it was giving error on first page that CrystalDecision.web assembly can't be found, then I installed Crytal Run...
/* protected void Page_Load(object sender, EventArgs e) { //--Sql string string strId1; strId1=Request["empid"].ToString(); string strId2; strId2 = Request["empid1"].ToString(); String strCmd = ""; strCmd += "Select YKCODE,NAME,RNAME,TICODE,MADKBN,MKCODE,TANKBN,YOUKBN,KOUCODE "; strCmd += "From GMYAKU ...