I downloaded Crystal Viewer from SAP. In particular I needed 2011. I installed this on my target server. I have some Crystal RPT files which are reports I created. I need to be able to run those from ASP. I'm using Sage CRM which used to support Crystal Viewer, but for reasons unknown, doesn't any more. The ASP code that you code in is server side javascript using the COM API for CRM.

If I have an RPT file, how can I run that report and pass in parameters. Ideally I would be able to run the report by simply hitting a URL like you can in SSRS but for that I think you need full Crystal Enterprise and that is not an option.

If I wanted to call a report and have it show in the Crystal Viewer in a pop up, how would I do that? Can I then export to PDF or Excel from the viewer? I tried converting the reports to SSRS which would be perfect except I cannot control the grouping the way you can in Crystal, probably because I don't know how rather than the program can't do it.

We picked up a copy of Crystal Reports 2011 (version 14.0.4.738 RTM) to produce a specific report that included data from 4 different spreadsheets and a couple of formulas. Crystal reports is installed on a Windows 7 pro 64 bit machine. MS office is not installed on that machine, (if that matters). Crystal reports refused to work when I tried using "xlxs" files. I had no problems getting results using Excel 97-03 workbooks (.xls). Now I have a new project that has a little twist. One of my data sources is a spreadsheet that is split up into a series of worksheets (one sheet for each letter of the alphabet), because if it were all on one sheet it would exceed the number of rows allowed by the 97-03 version of Excel. I of course want to insure I use a data source that is compatible with Crystal reports 2011. The project would require that the data be refreshed (reloaded and re-imported) every week or so. Would my best bet be to import the individual sheets into an Access (version 2003) database?

Hello Guys

I am trying to find where could I download font code 128 to use in my Crystal reports.

regards
Alexandre

We run Crystal Reports (rpt) from within the software programs we produce at our company, and we typically display the results using the Crystal Reports Viewer from within our own app.

Many reports have a main report and a subreport.  For instance, I will often have a person's name followed by multiple arrest reports or incident reports in which the person is named.

When I get the report data back, I can click on hyperlinks in the main report that take me back to OUR software, displaying data details for the item in the hyperlink, like the person's name.  Clicking on the name will bring up person detail in OUR application.

I also have hyperlinks in the subreport, that should bring up the detail for individual items, like arrests or incidents.  

When I use PDF output, all the hyperlinks work, both in the main report and the subreports, and clicking them opens the appropriate detailed view in OUR application.

However, when I run the reports using the Crystal Viewer version, only the hyperlinks in the main report work.  The subreport is seen as one big element, and I can't click on the hyperlink text.

I've tried unchecking all the "Keep Together" options, but I can't get the hyperlinks to work from the subreports.

What option do I need to use? Thanks.

Hi EE,

Can anyone guide me that How do I print two copies of A5 paper size report on single A4 Paper?

Regards,
D Patel

I have an SSRS report. It selects data from a view and the single parameter is used as the where clause. Without trying to explain things explicitly, the report is essentially a quote form. So, I pass in a reference number and it generates the quote. Basic stuff like company name in the report header, company address, then in the body, the quote items list. Assume the quote will always be a single page. As the same quote is being sent to more than one company, the quote header has the company name and address, then the quote items duplicated on each page in the report body. The footer contains the count of companies the qujote is being sent to so they know how many people are in the running for the quote. I've got everything working except the company name and address in the header doesn't change.

I have the exact same report in Crystal and that works because instead of apage header, I put what is essentially the page header into a group header. This allows me to change the name and address as the group changes. How do I do the same in SSRS?

Hello,

In the attached report, is there a way to suppress group header 1a if 1b is suppressed?

Thanks.

hardware-EE.rpt

I had this question after viewing how to read <br> and display a new line in crystal report labels.
HTML-Cangrow.PNG

Is there anything Telerik Reporting can do that SSRS (2005) cannot?

Specifics: We're looking to migrate our current Reporting infrastructure from in-house ASP NET + Crystal (VS Edition) to something else.

Ignoring the cost factor (we have a Telerik license), is there any pros or cons to going with Telerik over SSRS?
SSRS
Key elements we need are:

generate reports from a custom ASP.NET application
schedule reports
email reports on demand or on a schedule
pdf output, drilldown html
massage the dataset in C# before passing it to the rendering engine
Any experiences or sites that point out advantages or limitations (with either engine) would be greatly appreciated.

Hi,

I am migrating an old Crystal Report to an alternative Dashboard application.
My crystal report (which works very well, shame I have to migrate) reads from a table of monthly stock sales history.

e.g.

STOCK CODE   MONTH1UNITS   MONTH2UNITS   MONTH3UNITS   MONTH4UNITS   MONTH6UNITS   MONTH7UNITS
ABC123            100                         87                          69                          93                          108                        111
ETC
ETC

My Crystal Report had a parameter to prompt the user for number of months to report on.
A calculated field in the report registered all 60 of the month columns into an array and then looped through the correct number of months based on the user parameter for number of months to aggregate for each stock record in the report.
This solution was simple, elegant and worked very well.

I don't have the facility of arrays in the alternative Dashboard app.
Can anyone suggest an alternative way of achieving similar through SQL in Stored Procedure?  I'm struggling...

Hope i've explained clearly enough?

Thanks in anticipation...

Have a table called Questions which contains all questions on a form. It runs from a stored procedure in sql and creates a temp table #_tQst like this:

QID (Question ID varchar)
TabSeq (tab sequence number)
QDes (Question text)
Etc…

Have a table called Answers which contains all answers client gave to form questions above. It runs from a stored procedure in sql and creates a temp table #_Ans like this:
DocId (unique number created when form answers are given)
QID same as above
Val (answer given -text)
DatIn (date form given to client -date)
CplDat (date form completed -date)
Adm (Client ID – number)
Name ( text)
Branch      (branch – number)
Etc…

I need to see all the questions on the form with any answers given by the client.   Problem is only questions that are answered are stored in a table indexed on the DocId.  Would like to see:
Name      QID                   QDes                  Val      
Bob        1                   Age                  55
Bob        2                  Married            Yes
Bob       3                 weight                        (no answer given)

Bill             1                 Age                        (no answer given)
Bill            2                Married            yes
Bill            3                Weight                  175

Mary      1                Age                  65
Mary      2                Married            No
Mary      3                Weight                        (no answer given)

All questions and any answers given for each person (DocID)

The report is run based on parameter fields that are stored ONLY in the Answer table namely DatIn (range of dates), Branch number, etc.
Best I have come up with is Main report based on …

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3

Hello, I have created a simple report and created some basic parameters but when I run the report is blank