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 Designer VS. 2003 Interface Failure

Our current VS2003 installed on 2000 Sever sp4 and Reporting Service
will not longer interface.
When trying to open a report project we recieve the error "Th
application for Project XXX.rptproj is not installed" "Make sure th
application for project type (.rptproj) is installed".
Has anyone ever seen this error before or have any suggestions?
We have built a number of reports and deployed them, but we are n
longer able to open the project to make modifications. We are als
unable to create a new report project without receiving the sam
errorDid you install or remove any software recently? Did you try reinstalling
Report Designer?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"kucerakk" <kris.kucera@.ps-dot-net.no-spam.invalid> wrote in message
news:pr2dnce98v9d4BDfRVn_vg@.giganews.com...
> Our current VS2003 installed on 2000 Sever sp4 and Reporting Services
> will not longer interface.
> When trying to open a report project we recieve the error "The
> application for Project XXX.rptproj is not installed" "Make sure the
> application for project type (.rptproj) is installed".
> Has anyone ever seen this error before or have any suggestions?
> We have built a number of reports and deployed them, but we are no
> longer able to open the project to make modifications. We are also
> unable to create a new report project without receiving the same
> error.
>

REport definitions

hi,

I have created a report in RS 2005 but i want to use in RS2003 how i change the report definitions in the current report to make it compatable in RS 2003

Thanks in advance,

Regards,

Somu

You can start by changing the XML namespaces at the top of the definition. Get a sample RS 2000 report to see how. It will take probably a few cycles of trial and error.|||You can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

These changes are usually sufficient to "downgrade" the RDL so it uploads on a RS 2000 report server.

-- Robert

Report based on a Date

Hi,
I have to create a report for all the business days in a current month. (no matter the records are available or not in the database for the day).
If you have any idea, pls tell me
ThanksCan you be a little more specific? Do you need a separate report for each day, or do you need one report that will show all the days in the month regardless if there's a record?|||Thanks Malleyo!

The second condition in your post is my report.

My report should display all the business days in the current month and the corresponding sum of amounts from a table which contains a date field. The sum is grouped by the date for each day.

The problem here is the table doesn't contain records for all the days upto end of the month. But I have to display all the days. Now I'm using a dummy table which contains all the business days and linking this with my main table using left outer join so that I'm able to display all the dates.

But I think this is not the right way to do this?
Ex report is

Date Amount
6/1 100
6/2 50
6/3 90
6/4 150
6/7
6/8
...
...
...
6/30

Ex. The problem is table contains data upto 6/4. So while generating the report it shows the report upto 6/4. But I need upto 6/30 even though the amount field is empty.

Thanks|||I'm using a dummy table which contains all the business days and linking this with my main table using left outer join so that I'm able to display all the dates.
Joining the 2 tables sounds good to me.

Try using a Group for Date. Make sure that you don't have 'SuppressIfBlank' turned on. Make sure that the query you're running is really returning all the info you need.|||Thanks Malleyo,

One more things, I'm using MySQL as my database. While linking the tables using left outer join, it is not working properly. It returns the result of inner join.

Actually my first table contains all the business days and the second table contains records for some of the days. I linked the table on date field using left outer join. It has supposed to return all the days in the first table regardless of second table. But it 's not. It's returning only the matching records.

Any idea please,|||You may be doing the wrong kind of Join. Unfortunately I don't know a whole lot about Joins, and the knowledge that I do have is for SQL Server 7 (which I'm not sure if uses different syntax than MySQL.

Here's what my Joins typically look like:

SELECT * FROM Table1 AS T1
LEFT JOIN Table2 AS T2 ON T2.Column1 = T1.Column1

That will return all the fields in Table1 with any that match in Table2 (or NULL if there isn't a match in Table2).|||I'm also new to mysql.

I'm using the same conventions as given in mysql documentation.

My query is

select table1.date,table2.date,table2.amount from table1 left join table2 on table1.date = table2.date where table2.code = '111'

This is not working

But

select table1.date,table2.date,table2.amount from table1 left join table2 on table1.date = table2.date and table2.code = '111'

This works but it takes so much time to read the records. sometime just hung up. My table1 contains just 22 records.

While adding as tables, it's not working.|||Do you have indexes on table1.date, table2.date, and table2.code? If not, add the indexes and it should speed it up. If you already have indexes, then I'm out of ideas. You can try posting that question on another forum or search www.google.com or something.