coreyt
Posts: 4
|
| Posted: 02/28/2008, 11:32 AM |
|
Hello,
It seems I should be able to do this with labels - I see that there is a recommendation to do that when you need control over your link. However,
-----
There was a question posted about modifying URLs to make it easier to integrate with SSRS:
http://forums.codecharge.com/posts.php?post_id=70337
I'm trying to use the Link object, but CCS seems to want to modify my base URL, by adding in an = sign.
http://server/Reportserver?%2fsomereports%2fname&rs:Com...er&project_id=1
becomes
http://server/Reportserver?%2fsomereports%2fname& = rs:Command=Render&project_id=1
(spaces added to emphasize where = is added.
Thanks,
Corey
|
 |
 |
quasimidi
Posts: 151
|
| Posted: 02/28/2008, 11:57 AM |
|
Please post your code snippet, and a brief description what exactly you want.
Robert
_________________
RS |
|
|
|
coreyt
Posts: 4
|
| Posted: 02/28/2008, 3:34 PM |
|
I am using CCS4, C# generator. I essentially want to link from the CCS generated page to a Microsoft SQL Server Reporting Services (SSRS) report. The SSRS reports are all accessed via a URL that is basically:
http://server/Reportserver?%2fsomereports%2fname&rs:Command=Render
You then send the report parameters on the URL in a GET: &project_id=1
All I want to do is to do to append the data I have on the CCS page to the URL to the report server.
I don't really have any code doing this at this time. I am trying to do the following, but not having any luck:
- label1being the base URL, and the value "http://server/Reportserver?%2fsomereports%2fname&rs:Command=Render"
- label2 being assigned the project_id from the URL
- label3 being the concatenated URL
Thanks!
Corey
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 02/28/2008, 4:10 PM |
|
Given that the final link should be:
<a href="http://server/Reportserver?somereportsfname&rs:Command=Render&project_id=id">Report</a>
and id is a databasefield, I managed to create above link in the following way:
- On a form I picked the 'A Link'from the Forms Toolbox
- The Href dialogue pops up
(or press the Href [...] in properties to edit an existing link)
General Tab:
Text to display, static text: Report
Link address, static text: http//server/Reportserver
Parameters Tab:
Press the + to pop up the entry dialogue
First parameter, type Expresson, Parameter Source: Render, Parameter name: somereportsfname&rs:Command, press ok
Press the + to pop up the entry dialogue
Second parameter, type Datsource Column, Parameter Source: ID, Parameter name: Project_id
I did not have the %20 but do you really need them ?
And this link will follow the ID from the curent selected SQL row, of course.
And is CCS compliant.
Walter
(If this is the solution please change ttopic text to Solved : <original>)
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
coreyt
Posts: 4
|
| Posted: 02/29/2008, 6:26 AM |
|
Yes! Thanks! Here are the final settings, along with some notes:
Control Type: A Link
Static Text: View Report
Static Address: http://myserver.com/ReportServer
Parameters:
1st -
Source Type: Expression
Parameter Source: "Render" (has double quotes)
Parameter name: /pathtoreport/reportname&rs:Command
2nd -
Source Type: URL
Parameter Source: s_Project_id
Parameter name: project_id
Giving me:
<a href="http://myserver.com/ReportServer?/pathtoreport/reportname&rs:Command="Render"&project_id={s_Project_id}" id="SearchLink1">View Report</a>
---
Notes:
I needed to put quotes around the Parameter Source for the Expression type, or else I received a CS1502 compile error. The quotes needed to be double-quotes, or I received a CS1012 compile error.
Thanks!
|
|
|
|
|
