AspWebSolution Forums » Products » ASP Report Wizard v2 » Small Issues with latest code

index | search | no replies | posting guidelines | help

login | register

» »

:: Small Issues with latest code :: (33)

Post a New Message | Post a Reply

Jul 22 2004, 6:50 AM

Small Issues with latest code

scotthibbs

from: Philadelphia, PA Couple small items.
I added some of the sample code to my pages and applied
the image locale file....no changes...just applied as downloaded.

1) The CSV download no longer appears...I think something is there because the image are displaced, but no image or link
2) The Word download says 'Save as an Excel Spreadsheet'
3) I have a master-detail report. One of the child fields consistently
appears in the master line. I have dropped the report and rebuilt it
a number of times with a number of variations, but the field still
is in the master line.

Thanks.

Jul 22 2004, 9:25 AM

Re: Small Issues with latest code

ghost

from: Washington, DC 1) The CSV download no longer appears...I think something is there because the image are displaced, but no image or link

The CSV download no longer appears because the tag <CSVText /> is empty.
We intentionally left it out so that users can understand that you can make hide a button by leaving the Tag text empty. If you want the CSV button to appear, just add some text or an image name in the tag as follows:

For text
<CSVText >CSV</CSVText>

For images
<CSVText >CSV.gif</CSVText>
Make sure you have an image called CSV.gif in your ImagesFolder.

2) The Word download says 'Save as an Excel Spreadsheet'

This bug has been fixed in the latest release version 2.4.17

3) I have a master-detail report. One of the child fields consistently
appears in the master line. I have dropped the report and rebuilt it
a number of times with a number of variations, but the field still
is in the master line.

I haven't been able to reproduce this bug. If it occurs in the downloaded example, please tell me the tables you used in creating the report!

-------------------------
Ghost

Jul 23 2004, 5:12 AM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA Installed the latest version....still have these small problems:

1) If there are a lot of fields, the wizard dialog box is too small..it
always has to be resized. Properties for sizing and background
color would be quite nice for a future release.
2) I am not an HTML expert, but I think the report selection/creation
page could use some cellpadding in the table. When we rollover
the links, the longest report or table makes the page jump in a
slightly disturbing way.....very small issue....I can certainly live with it.
3) Anything environmental I can do to increase performance? The page
is very slow sometimes, but very fast other times. I can't figure out
the cause. Generally, performance is excellent.
4) The master-detail issue is still present. Here are the Master and
Detail sources.......both are views:

vEquipment:

Select Top 50000
eq.EquipId as 'Equipment_Id',
eq.EIN as 'EIN',
eq.EquipDesc as 'Equipment_Description',
f.FacilityDesc as 'Facility',
un.UnitDesc as 'Unit',
sy.SystemDesc as 'System',
et.EquipType as 'Equipment_Type',
su.SubType as 'Equipment_SubType',
eq.FEGTag as 'FEG_Tag',
eq.FEGLevel as 'FEG_Level',
mfg.SupplierName as 'Manufacturer',
vnd.SupplierName as 'Vendor',
eq.Model as 'Model',
eq.Serial as 'Serial_Number',
pl1.LName + ', ' + pl1.FName as 'Responsible_Person',
el1.EquipLoc1 as 'Area',
el2.EquipLoc2 as 'Building',
el3.EquipLoc3 as 'Room',
eq.Criticality as 'Criticality',
eq.InstallDate as 'Installation_Date',
eq.LifeCycle as 'Life_Cycle',
eq.ReplacementCost as 'Replacement_Cost',
eq.LastOverhaulDate as 'Last_Overhaul_Date',
eq.RCMOps as 'RCM_Ops',
eq.RCMOpsPercent as ' RCM_Ops_%',
eq.RCMPerf as 'RCM_Perf',
eq.RCMSafety as 'RCM_Safety',
eq.RCMEnv as 'RCM_Env',
eq.RCMMaint as 'RCM_Maint',
eq.RCMExper as 'RCM_Exper',
eq.RCMEnvCode as 'RCM_Env _Code',
eq.RCMDutyCycle as 'RCM_Duty_Cycle',
eq.RCMLoad as 'RCM_Load',
eq.RCMRedundancy as 'RCM_Redundancy',
eq.RCMCrit as 'RCM_Crit',
pl2.LName + ', ' + pl2.FName as 'RCM_Person',
eq.RCMLastUpdate as 'RCM_Last_Update',
eq.FunctionComment as 'Function_Comment',
eq.SystemOpDesc as 'System_Option_Desc',
eq.LivingProgram as 'Living_Program',
'Critical' = case when eq.CriticalIndicator = 0 then 'No'
when eq.CriticalIndicator = 1 then 'Yes'
end,
'Active' = case when eq.ActiveCode = -1 then 'Yes'
when eq.ActiveCode = 0 then 'No'
end
from Equipment eq
inner join Systems sy on sy.SystemId = eq.SystemId
inner join Units un on un.UnitId = sy.UnitId
inner join Facilities f on f.Facilityid = un.FacilityId
inner join EquipSubtypes su on su.EquipSubType = eq.EquipSubType
inner join Equiptypes et on et.TypeId = su.TypeId
left outer join Suppliers mfg on (mfg.SupplierId = eq.MfgrId and mfg.SupplierType = 1)
left outer join Suppliers vnd on (mfg.SupplierId = eq.VendorId and mfg.SupplierType = 2)
left Outer join Personnel pl1 on (eq.ResponsiblePID =pl1.PID)
left outer join Personnel pl2 on (eq.RCMPID =pl2.PID)
left outer join EquipLoc1 el1 on (eq.EquipLoc1Id=el1.EquipLoc1Id)
left outer join EquipLoc2 el2 on (eq.EquipLoc2Id=el2.EquipLoc2Id)
left outer join EquipLoc3 el3 on (eq.EquipLoc3Id=el3.EquipLoc3Id)

vEquipmentNotes

Select Top 50000
eq.EquipId as 'Equipment_Id',
eq.EIN as 'EIN',
eq.EquipDesc as 'Equipment_Description',
per.LName + ', ' + per.FName as 'Note_By',
en.DateCreated as 'Date_Created',
ug.GroupName as 'Responsible Group',
en.NoteText as 'Equipment_Note'
from Notes en
inner join Equipment eq on eq.EquipId = en.EquipId
inner join Personnel per on per.PID = en.CreatorPID
inner join UserGroups ug on ug.GroupId = en.RespGroupId

I select both views from the creation meny and click Build.
Then I select a few columns from the vEquipment view, the
Note_BY, Date_Created,Responsible_Group, Equipment_Note
from the vEquipment_Note view. I select Master-detail radio
button and leave everything else default.

The resulting report is like this:

Master Row -----> EIN, EquipmentDescription, Facility, Equipment_Note
Detail Row ------> Note_By, Date_Created, Responsible_Group

I can't seem to get the note to be in the detail line.

Thanks.

Jul 23 2004, 5:29 AM

Re: Small Issues with latest code

ghost

from: Washington, DC Can you please send me a small sample of these tables (text files or Access) so that I can recreate the report

-------------------------
Ghost

Jul 23 2004, 6:14 AM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA I emailed you a zip of the basic two tables.

Jul 23 2004, 8:32 AM

Re: Small Issues with latest code

ghost

from: Washington, DC I can still not reproduce that bug. I created the views exactly as you typed in SQL Server 2000. I also created a table UserGroups(GroupId,GroupName) and added three groups (3,4,7).
I created the report selecting both views and selecting the fields you listed above, and my ouput is shown on the link below:

http://www.cityjams.com/tmp/hibbs.gif

-------------------------
Ghost

Jul 23 2004, 9:07 AM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA I am going to email you a link to a temporary page on our system
so you can see what is going on. The report name is 'Equipment Notes'

Jul 23 2004, 10:26 AM

Re: Small Issues with latest code

ghost

from: Washington, DC I checked out the link and still can't seem to figure out what is causing it.
I've tested it on two macines and it works fine. I will continue testing it later.
However, if I may suggest, try changing the name of the Equipment_Note column to something different and testing it to see if it is the name causing it. Also, try to make it have a different index (right now it is the last column in the view).
Let me know if you get any results.

Thanks,

-------------------------
Ghost

Jul 23 2004, 10:35 AM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA I thought of changing the name and tried it...no luck.
I am not sure what you mean by the index being the last
column in the view. Please elaborate when you have a chance.
No hurry......I can wait until you have time...it's not a critical issue.

Jul 23 2004, 11:39 AM

Re: Small Issues with latest code

ghost

from: Washington, DC I mean it is the last column in the table (just as Equipment_Id is the First)

-------------------------
Ghost

Jul 23 2004, 2:05 PM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA Nope......moved the note to the second column...same thing...note is still in the parent row.......which causes duplication if there are two notes.

Jul 24 2004, 8:31 AM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA I tried for an hour to alter the views in a dozen different ways without success.
Perhaps this one is just going to remain a bug. It's not that important.

In the third post, there are three other small issues.

In addition, I continually get a type mismatch in the builder dialogs if invoked from an existing report. I erased the XML file to be sure this release version started out clean....I still have the problem.

Update: There seems to be something definitely amiss in the master-detail logic. I tried to construct another master-detail report and I get no data at all back. I ran the same query in Query Analyzer and got back 15 rows.....no filters in the report....everything set to defaults.

Jul 26 2004, 4:40 PM

Re: Small Issues with latest code

ghost

from: Washington, DC I just wanted to let you know that we are still working on your problem. I will keep you up to date. In the mean time, can you send me the SQL statement that seems to be causing an error!

thanx!

-------------------------
Ghost

Jul 26 2004, 6:30 PM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA SQL Statement? Not sure what you mean. The views involved are in an earlier post...along with a few other problems.

I did create a report that was master-detail that returned no data, yet when I ran what would logically be the same thing in a sql query, I get 15 rows.

Aug 16 2004, 4:14 PM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA Tested this at the 2.4.26 level.......child column still ends up in the parent row. Very frustrating.

Aug 17 2004, 7:15 AM

Re: Small Issues with latest code

ghost

from: Washington, DC It's almost impossible for us to figure this out because we cannot reproduce it. Have you tried exporting the tables to another database and testing it to see if this bug still occurs?

-------------------------
Ghost

Aug 17 2004, 7:24 AM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA We have 20 databases and they all have the problem. This has to be a bug in the report wizard. The Note column is only referenced in the child table, yet it appears in the Parent row. The views that are referenced are pretty simple....I think I sent them to you.

Aug 17 2004, 12:14 PM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA I have done further testing with the master-detail logic. Something seems very wrong with this function. I am getting duplicate master table rows, but the primary key is an identity column.....it's impossible to have duplicate values. I have a jpg image that demonstrates this issue, but I see no way to post it here.

Aug 17 2004, 12:31 PM

Re: Small Issues with latest code

ghost

from: Washington, DC You can email us the link to a test site or just post it here

-------------------------
Ghost

Aug 17 2004, 1:16 PM

Re: Small Issues with latest code

scotthibbs

from: Philadelphia, PA Here's the link:
http://secure.webview2000.com:8888/images/master-detail-problem.jpg

Note the Equipment ID column....it is identity. There could not possibly be duplicate rows.

Also note that the Equipment_ID appears twice in the parent row. The second occurance actually comes from the child table.......it's another instance of the mixup between which row parent and child data should be in.

Same is true for EIN and Equipment_Description....second occurrance should be in the child table.

I added those columns for testing, by the way. They don't make sense....I know.

Pages: (2) [1] … Last »