mas7357
Posts: 29
|
| Posted: 08/03/2007, 5:35 AM |
|
I have a report (written with the report builder) with a printable version link. The report is based on a query which has a where clause based on the user ID of the logged on user. The report works fine (only showing records applicable to the logged on user) but when I click the link the report has all records (for all users). Can anybody explain why and suggest a fix
Mike
_________________
MikeS |
 |
 |
TheunisP
Posts: 342
|
| Posted: 08/03/2007, 8:17 AM |
|
it might be related to my problem - look at the parameters passed (check if they are the same as for the screen page) - I have a problem with CCS mucking up the links - there are missing dividers (&'s)
|
|
|
|
mas7357
Posts: 29
|
| Posted: 08/03/2007, 8:52 AM |
|
Thans for your promp reply. I had a look at the parameters for the printable version page andand they look like this
http://localhost/Project name/Page name.asp?ViewMode=Print and that's it. I guess this should have the UserID parameter?? but it doesn't. Any ideas on how to include this parameter and make sure it is passed over
Thanks for your help- I have been quite unsucessful in getting replies to my questions- I g
_________________
MikeS |
|
|
|
mas7357
Posts: 29
|
| Posted: 08/03/2007, 8:52 AM |
|
Thans for your promp reply. I had a look at the parameters for the printable version page andand they look like this
http://localhost/Project name/Page name.asp?ViewMode=Print and that's it. I guess this should have the UserID parameter?? but it doesn't. Any ideas on how to include this parameter and make sure it is passed over
Thanks for your help- I have been quite unsucessful in getting replies to my questions- I g
_________________
MikeS |
|
|
|
mas7357
Posts: 29
|
| Posted: 08/03/2007, 8:52 AM |
|
Thans for your promp reply. I had a look at the parameters for the printable version page andand they look like this
http://localhost/Project name/Page name.asp?ViewMode=Print and that's it. I guess this should have the UserID parameter?? but it doesn't. Any ideas on how to include this parameter and make sure it is passed over
Thanks for your help- I have been quite unsucessful in getting replies to my questions- I g
_________________
MikeS |
|
|
|
mas7357
Posts: 29
|
| Posted: 08/03/2007, 8:52 AM |
|
Thans for your promp reply. I had a look at the parameters for the printable version page andand they look like this
http://localhost/Project name/Page name.asp?ViewMode=Print and that's it. I guess this should have the UserID parameter?? but it doesn't. Any ideas on how to include this parameter and make sure it is passed over
Thanks for your help- I have been quite unsucessful in getting replies to my questions- I g
_________________
MikeS |
|
|
|
mas7357
Posts: 29
|
| Posted: 08/03/2007, 8:52 AM |
|
Thans for your promp reply. I had a look at the parameters for the printable version page andand they look like this
http://localhost/Project name/Page name.asp?ViewMode=Print and that's it. I guess this should have the UserID parameter?? but it doesn't. Any ideas on how to include this parameter and make sure it is passed over
Thanks for your help- I have been quite unsucessful in getting replies to my questions- I g
_________________
MikeS |
|
|
|
mas7357
Posts: 29
|
| Posted: 08/03/2007, 8:52 AM |
|
Thans for your promp reply. I had a look at the parameters for the printable version page andand they look like this
http://localhost/Project name/Page name.asp?ViewMode=Print and that's it. I guess this should have the UserID parameter?? but it doesn't. Any ideas on how to include this parameter and make sure it is passed over
Thanks for your help- I have been quite unsucessful in getting replies to my questions- I g
_________________
MikeS |
|
|
|
mas7357
Posts: 29
|
| Posted: 08/03/2007, 8:52 AM |
|
Thans for your promp reply. I had a look at the parameters for the printable version page andand they look like this
http://localhost/Project name/Page name.asp?ViewMode=Print and that's it. I guess this should have the UserID parameter?? but it doesn't. Any ideas on how to include this parameter and make sure it is passed over
Thanks for your help- I have been quite unsucessful in getting replies to my questions- I g
_________________
MikeS |
|
|
|
TheunisP
Posts: 342
|
| Posted: 08/03/2007, 9:16 AM |
|
- in HTML view click inside the link
- click on the HRef Source property in the Properties view (on the right)
- click on the ... button
- select Parameters tab
- click +
- this value should be coming from you DB so select Database as source in the source drop down
- select the ID as Parameter value & name
check on your report page inside the print grid that your where statement is looking for the passed URL parameter
|
|
|
|
mas7357
Posts: 29
|
| Posted: 08/03/2007, 2:00 PM |
|
Thanks for the advice......
I followed it and have got the link to send the session variable (userID) through to the page so that the link URL properties now are
PageName.asp?ViewMode=Print&Login_ID=AS003
This doesn't help though - The Web report looks great but the printable version still has all the records for all users- hit a brick wall I'm afraid- any further advice would be very gratefully received
_________________
MikeS |
|
|
|
TheunisP
Posts: 342
|
| Posted: 08/03/2007, 8:50 PM |
|
ok, I had a look at report code generated - it seems that it basically swicthes off sections if you go to print view - which means if it is ok in view mode it should work in print mode
now - it seems that the problem is that you lose your filtering parameter when hitting print view link
2 things
1) you sure you filter your results on the Login_ID parameter?
2) if so try this when entering your report in view mode you'll have an address with parameters in the address box, when going into print view this should be the same address & parameters but with this paramater extra: ViewMode=Print
no either you have 1) you are removing or preserving none of you parameters in the link properties (check there) or 2) CCS is corrupting the parameters passed - which is what I have now
|
|
|
|
mas7357
Posts: 29
|
| Posted: 08/04/2007, 11:30 AM |
|
I think it must be corrupting the parameters as the Login_ID parameter IS in the address line  and yet it doesn't work
And get this..... If I add a search record to the page and place a label in it with the value of the login_ID I need , and press search, it does nothing to the Web View (as I have already filtered the grid with the Login_ID in the grid where statement) but it does filter the print mode view using the correct Login_ID which now looks good
I am going to submit a request for help from the codecharge guys as I payed a lot for the report tool and I think it should work properly 
_________________
MikeS |
|
|
|
TheunisP
Posts: 342
|
| Posted: 08/04/2007, 2:49 PM |
|
mmm... I know you don't want to hear this - but I have found with CCS that sometimes deletling the page and recreating it from scratch does the trick
good luck
|
|
|
|
mas7357
Posts: 29
|
| Posted: 08/05/2007, 2:53 AM |
|
Thanks for all your help Theunis- I will try from scratch and post any response I get from the CCS guys
_________________
MikeS |
|
|
|
