Showing posts with label displaying. Show all posts
Showing posts with label displaying. Show all posts

Friday, March 30, 2012

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 display in Firefox

Hi everyone,

I know there are issue with reports not displaying as expected in ReportViewer when using Firefox, including the weird 'add something wide to your header' bug, but I've encountered a slightly different problem.

I'm using a matrix report, which displays perfectly in IE, and will render nicely when exported to either excel or pdf format with either IE or Firefox. However, when you simply view the report in firefox it looks awful: all the columns of the matrix are squashed so much that you can't read anything at all. OK, I can just say to people "export the report", but it'd be good if I could fix this.

Any ideas will be much appreciated. Thanks

This is a known problem. I don't know if there are any updates yet. What you can try is add a blank textbox to the footer of the report and stretch it manually to the width of your report. This will force the report to stretch in Firefox.

|||

Hi,

I already have a line the same width as my report in the header, and I've added a blank textbox the width of the report to the footer. Unfortunately, there's no change. The 'cells' of the matrix are still mini and totally unreadable. Thanks anyway

|||

dhassen:

and I've added a blank textbox the width of the report to the footer

Just to confirm, is this the footer of the report or the page. If its the report, then add it to the page footer. For inserting a page footer, do this:

When you are in the design view of report, go to Report Menu from the menu options, add a Page Footer (if you don't have one), drag and drop an empty textbox on this footer and stretch it.

If you have already done it, I am out of solutions.

|||

yep, unfortunately it was the page footer that I tried. Ah well... see if anyone else has any ideas

Wednesday, March 21, 2012

report builder not displaying some rows

Hi friends
am using report builder to create a report ,the report not displaying some rows.
i've 2 tables . Patients and transactions (1- many)

and assume that i've following records
patient
--
1 , sriram , albert street,nz
2 , david , victoria street ,aus

transactions (flds are patientid,charge,transaction date)

1 , $100, diabetes problem ,10/10/05
1, $100 , diabetes problem , 19/01/06
2, $150,someother problem

if i create a report with following fields

name , address (from patient table)

charge , problem (from transactions table) i get following results

sriram , albert street,nz,$100
david , victoria street ,aus , $150

as

u can see it ignored the 2nd record for patient "sriram" ?i used sql

profiler to get query report builder creating and if i run it in QA i

get all results am expecting but report builder thinks ignores 2rd

record as it thinks its duplicate.

i know how to fix this by

just adding transaction date field but the abv report is very common

one our users create ,is there any way report builder displays all rows ?
Thanks

it is still an issue for me !! no one has faced similar situation ?|||

Sorry: I have not used Report Builder (we're on SQL 2000 and Report Designer), but it sounds like it is just returning DISTINCT recordset.

There may be an attribute on the table? Or the query uses SELECT DISTINCT?

Perry

|||Thanks for the post Perry
The query RB creates is fine as it returns correct results if i run it QA.
but looks like RB doing a distinct after gettting the data!

report builder not displaying some rows

Hi friends
am using report builder to create a report ,the report not displaying some rows.
i've 2 tables . Patients and transactions (1- many)

and assume that i've following records
patient
--
1 , sriram , albert street,nz
2 , david , victoria street ,aus

transactions (flds are patientid,charge,transaction date)

1 , $100, diabetes problem ,10/10/05
1, $100 , diabetes problem , 19/01/06
2, $150,someother problem

if i create a report with following fields
name , address (from patient table)
charge , problem (from transactions table) i get following results

sriram , albert street,nz,$100
david , victoria street ,aus , $150

as u can see it ignored the 2nd record for patient "sriram" ?i used sql profiler to get query report builder creating and if i run it in QA i get all results am expecting but report builder thinks ignores 2rd record as it thinks its duplicate.

i know how to fix this by just adding transaction date field but the abv report is very common one our users create ,is there any way report builder displays all rows ?
Thanks
it is still an issue for me !! no one has faced similar situation ?|||

Sorry: I have not used Report Builder (we're on SQL 2000 and Report Designer), but it sounds like it is just returning DISTINCT recordset.

There may be an attribute on the table? Or the query uses SELECT DISTINCT?

Perry

|||Thanks for the post Perry
The query RB creates is fine as it returns correct results if i run it QA.
but looks like RB doing a distinct after gettting the data!