subreport

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Subreports in Crystal 8.5

I developed a Crystal Report in 8.5 including an existing subreport.Subsequent to that our file server organisation changed.Now when opening these reports it takes a long time to open.When I tried re-importing the subreport I discovered it was looking for the subreport in the previous location.I deleted the subreport and...

Tags: Bassardien.n@..., subreport, Crystal Report

Discussion threads 2007-04-04

Exporting Subreports to Excel

I am using Crystal XI. I am scheduling this report using Business Object Info Viewer.My Report contains 2 SubReports.How can i export subreports in different excel spreadsheets?

Tags: Subreport, vipulshah98@..., off-topic, programming, project management, software, Microsoft Excel

Discussion threads 2006-10-17

Crystal Reports; Push a subreport

I would like to see some VB code samples for VS.net and/or VS2005 that I can use to PUSH two xsd datasets populated at runtime up to a Crystal Report that is defined from those xsd's with a main and subreport without any linking.

Tags: subreport, xsd, Push, asam361804@..., programming, Crystal Reports

Q&A 2006-02-05

Reusing Crystal Subreports

How can I reuse a Crystal subreport in another report ? (I can't believe I have not figured this out on my own, but Crystal programming resources are not that prevalant).Save the subreport and in the new report go to Insert on the top toolbar and click on Subreport. ...

Tags: Crystal Subreports, programming, SpiderDad, subreport

Q&A 2005-09-29

Sharing Data Between Crystal Subreports

I am using Crystal Reports for Visual Studio .NET 2003. It does not seem to allow a subreport within a subreport. So how can I use data from one subreport in the select expert for another subreport ?You cannot include a subreport within another oneWith Crystal Reports you can use...

Tags: Microsoft development tools, subreport

Q&A 2005-06-07

access report multi +column conundrum

I have a multi column report in Access 97 that I need to go down and across, but also needs to be able to grow and span multiple pages. I have this as a nested subreport (a report in subreport, and that report is a subreport in another report,...

Tags: Microsoft Office, Databases, ironfist03, subreport

Q&A 2005-05-06

Additional Resources

How to show Access subreport totals in main report

Reports and aggregate functions go hand in hand. Using the same aggregate function, you can evaluate groups of data or the entire report. For example, the expression SUMAmount will return a different value depending on which report section it's in. Subreports expand on this capability. You can even display aggregate...

Tags: Microsoft Access, Expression, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins

Blog posts 2008-04-28

Is this possible to be done in Crystal Report 8.5?

Hi,I would like to ask if it is possible that the report I have created uses 2 different datasources.The report consists of the main report and subreport. The main report uses Oracle 9i as the datasource, while the subreport uses MS SQL as datasource. Can this be possible?Please advice.Thanks in...

Tags: datasource, Crystal report 8.5, myblob@..., programming, data source

Q&A 2006-08-06

Crystal Report Suppression

I currently have a report & a sub-report in Crystal 8.5 that is pulling values. Does anyone know how to supress the detail on the main report if the subreport values are null?Should be in Format, Section.Click on your subreport in the left pane.Select suppression options in the right...

Tags: davegenovese@...

Q&A 2005-03-03

Exporting subreports into Excel

When I export my report into MS Excel, everything can be formatted correctly, except one field that I had to create a subreport for this seems to be the only way to incorporate this information. In Excel this one field automatically creates a new row in the spreadsheet and...

Tags: Microsoft Office, Microsoft Excel

Q&A 2004-10-28

how to create subreport in crystral report using vb.net 2005

hello friends,i am searching for how to create subreport in crystal report using vb.net 2005 an i want to access data from more than one table and report contain morethan one table data in one report so if it is possible to use more than table in one report than...

Tags: lolariya_jayesh_l@..., vb.NET 2005

Discussion threads 2007-10-27

Crystal Reports...Dynamically displaying subreport

Hello All,I am writing a report for inspections. I have the main report that deals with truck inspections and a subreport that deals with the mounted equipmnet inspections, for equipment grouped to the specific truck.However, at the moment my report only displays information if the truck has an expired inspection...

Tags: Crystal Reports, kmyck@..., inspection

Discussion threads 2007-08-02

cant connect to two different databases from crystal enterprise X1

Enterprise throws an error 'incorrect logon parameters..' if I try to run a report that uses two different databases of the same server. Main report pointing to a stored proc in one database and subreport pointing to a table in another database. I am using ODBC connection to sql server.I...

Tags: Storage, Databases, a-champ1@..., database, ODBC Connection, ODBC, DSN1

Discussion threads 2007-05-15

Crystal Report and SubReport Data Share

Main report has an input date variable. Formula needs a number that is dependent on the input date from a second data table. Number in a second table not easily linkable to main report. Subreport created for lookup value/calculation.Shared the input date as a number(ie July is 7)That...

Tags: Value at Risk, jfichtel, software

Q&A 2005-08-03

Running Total problem in Crystal 8.5

I have two groups in my report. Group 1 defines the group names (group a, group b, etc.) Group 2 defines stratums within the group (Group a stratum 1). I have manual running totals in each group. I need to create a formula that references the running totals in both...

Tags: ehall, Group, Group A., Group-A, programming

Q&A 2005-02-08

Crystal Reports Labels

I am trying to create a label. I am using a subreport on the label because of a specific way of grouping and sorting. However, I only get on label. Then nothing. I do I tell the label to print one group and then print the...

Tags: cpascazio@..., crystal reorts, software, programming, Crystal Reports

Discussion threads 2007-02-19

Parameter Passing to Crystal Report

I am using Crystal report 10. I developed report with subreport. I used sql queries joined with union all having different selection criteria. I need to pass from & To Date as parameter to main report & same parameter to sub report also. But I am not using simple condition...

Tags: riteshkhare@...

Discussion threads 2007-04-09

One Subreport in a main report but data is overlaped

I am using crystal report8.5. I have a main report and created one sub report, which is included in the main report of second details section. The main report data is overlaped in sub report data. i need immediate solution for this. please send as soon as possible.

Tags: shiva_dss@..., main report

Discussion threads 2007-06-14

Oracle <-> crystal report problem

Hi,I have a package with few functions in it that returns certain values like name, address, state and zipBut while I am passing these values to get the result on the crystal report viewer on a web browser, I am not getting any special characters like dashes, commas, parenthesis...ends up...

Tags: Oracle Corp., needhelpnow, comma, Crystal Reports

Discussion threads 2007-10-17

crystal report - group by sahred variable from subreport

I"m working with crystal report version11. I build a main report that calls to sub report , there is a shared variable that get his value in the sub report.I can see the value of the variable in the main report.I want to group by the data in the main...

Tags: yliat@..., main report

Discussion threads 2007-03-27