Friday, March 30, 2012
Report displaying twice as many records
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
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 PerryThe 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
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 PerryThe 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!