Report displaying twice as many records

Hi all.

I have a crystal report that has 3 parameters:

1. Prior Period Range
2. Current Period Range
3. Department Number

What this report does is displays the amounts for each G/L account for those periods and for that specifc Department.

There are two group headers:

1. Department Name
2. Expense Break (i.e. wage, supply, travel etc)

Sales Department(Group Header 1)
Wage Expenses (Group Header 2)|

Prior Period:01/01/04-12/31/04 | Current Period:01/01/05-12/31/05

(Detail Section:)
G/L# - Wages $200.00 $0.00 | G/L# - Wages $0.00 $100.00
G/L# - Insurance $0.00 $50.00 | G/L# - Insurance $500.00 $0.00

So I would like for it to keep it at one line, and not create an additional line in the detail line when it is different. In other words:

Prior Period | Current Period

G/L# - Wages $200.00 | $100.00
G/L# - Insurance $500.00 | $50.00

Any suggestions? Thank you in advance.u can make use of the formulas.|||I played with the headers and footers and made it work!|||I played with the headers and footers and made it work!
Can you show the method you used?

Report Definition in Crystal

Hi, everyone -
I just had a quick query that I was hoping one of the experts out there could help me with:

I remember, when we used WinQL as our previous report generator, the software provided a "report definition" print option. This would allow me to print off a page with the fields, formulas, groupings, etc. for reports so that I could recreate my report in what we now have -- Crystal 8.5.

Now that we are changing our housing program software from a DOS-based system to a Windows-based software, the vendor is telling me that I'll have to AGAIN :eek: recreate my Crystal reports because the fields will all be different.

I'm wondering whether Crystal provides the same sort of "report definition" print option so I can print off the reports I need to recreate without having to guess at the formulas..... I've looked around Crystal and wasn't able to locate anything like this.

Thanks for the help.I'm not sure about 8.5 but in developer 10 under exports there is an option to print the report definitions.

GJ|||Hi, GJ -

UUUGGG... :blush: :blush: :blush: I guess I didn't scroll down far enough under Export. I did find it though.

Thanks for the help!!!sql

Report Conversion from Crystal Ver.6 to Ver.10

Hi all,

I have assigned a job to convert reports of CR ver6 to CR ver10. I have succefully converted all my reports but one of my report is not opening in Crystal Report 10.

Can any people suggest any idea how to open this report into Ver10.
the size of the report is 2MB.

any help will be appriciated.

Thanks in advvance

Sushil.Eeewwww....you may just have to rewrite the report. Can you open the report in 6 to see what's there? It's likely there is something in the report that is not supported in v10. Unfortunately you can't ask the Business Object people, because v6 is no longer supported.

Linda

Report Builders

Hello,
Does anyone know a report builder for ASP.NET, other than crystal
reports. I need a report builder that can take only an SQL query and
generate the report without the need to have designed it earlier.
Thanks,On Mar 2, 3:27 am, "Tatool" <raffee.parsegh...@.gmail.com> wrote:
> Hello,
> Does anyone know a report builder for ASP.NET, other than crystal
> reports. I need a report builder that can take only an SQL query and
> generate the report without the need to have designed it earlier.
> Thanks,
MS SQL Server Reporting Services is one option. It allows you to build
the RDL directly from within ASP.NET, in a designer solution, etc.
Also, I have worked with Dundas (www.Dundas.com) in the past; however
you would need to design this one. There are several other options
available; however, a majority of them will require designing the
report. There's always the option to use just basic Gridviews, which
can be exported to Excel, Word, PowerPoint, etc and don't particulary
have to be designed. Hope this helps.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer

Report Application Server

I know very little about Crystal so please bear with me.

I have created a report and copied it to my new Report Application Server. When i try to launch it through eportfolio i get the following:

CrystalReportViewer

Failed to load database information. Details: The database DLL 'crdb_p2bbtrv.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\{A5C8C86B-05EA-4CB3-92B1-DF48C5382F9C}.rpt: Failed to load database information.


webReporting.dll error '800002cd'
Failed to load database information. Details: The database DLL 'crdb_p2bbtrv.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\{A5C8C86B-05EA-4CB3-92B1-DF48C5382F9C}.rpt: Failed to load database information.

/rassamples/en/asp/rPortfolio/HTMLViewers/interactiveViewer.asp, line 30

Any ideas anyone...??Just download crystal report x1 redistributable package to the server