Thursday, March 29, 2012
Directly generate PDF file
come in the HTML page and then eport to PDF.
I hope someone knows how.
Kind regards
A. MoeskerSure, you can do this with either web services or URL integration. You
specify the render method. The default is HTML. If you have a link in your
report use the jump to URL instead of jump to report. Look at books online
and search on URL
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"A. Moesker" <a.moesker@.home.nl> wrote in message
news:OAk2oUqRFHA.3140@.tk2msftngp13.phx.gbl...
> Is it possible to generate directly a PDF file with a name, and not first
> come in the HTML page and then eport to PDF.
> I hope someone knows how.
> Kind regards
> A. Moesker
>|||I use the following JavaScript to determine the output from a standard asp
search results page.
The URL is built up and then calls a window to open up the new URL which
automatically causes the document to either open or be saved (users selection
via dialogue box).
var HLINK="";
HLINK = HLINK + "http://{RS Server Name}/ReportServer"
HLINK = HLINK + "?%2f{Folder Name}%2f"+sReportName
HLINK = HLINK + "&rs%3aClearSession=true"
HLINK = HLINK + "&rs%3aCommand=Render"
HLINK = HLINK + "&rs%3aFormat=" + aFormat //HTML4.0 - PDF - EXCEL
HLINK = HLINK + "&S_Customer="+S_Customer //Params go here
HLINK = HLINK + "&rc%3aToolbar=True"
HLINK = HLINK + "&rc%3aJavaScript=True"
HLINK = HLINK + "&rc%3aLinkTarget=_top"
HLINK = HLINK + "&rc%3aArea=Toolbar"
HLINK = HLINK + ""
You can see how the URL is built up. I use some 12 or so params with this
page and thay can be bolted on where I have indicated.
Best of luck,
Tony
"Bruce L-C [MVP]" wrote:
> Sure, you can do this with either web services or URL integration. You
> specify the render method. The default is HTML. If you have a link in your
> report use the jump to URL instead of jump to report. Look at books online
> and search on URL
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "A. Moesker" <a.moesker@.home.nl> wrote in message
> news:OAk2oUqRFHA.3140@.tk2msftngp13.phx.gbl...
> > Is it possible to generate directly a PDF file with a name, and not first
> > come in the HTML page and then eport to PDF.
> >
> > I hope someone knows how.
> >
> > Kind regards
> >
> > A. Moesker
> >
> >
>
>
direct update
seems to work great, but does not generate and does not use custom SPs
for each input/update/delete.
In the profiler I can see that, after I run a simple "update"
statement on the publisher, the same SQL gets run on the subscriber.
Which parameter of what call is it that determines whether I am using
this "direct update" business, and what are the implications, and
where (if anywhere!) is this discussed in BOL (or elsewhere), cuz I
can't find it!
Thanks.
Joshua Stern
On Mon, 22 Nov 2004 14:27:08 -0800, jxstern <jxstern@.nowhere.com>
wrote:
>Which parameter of what call is it that determines whether I am using
>this "direct update" business, and what are the implications, and
>where (if anywhere!) is this discussed in BOL (or elsewhere), cuz I
>can't find it!
Found it (in my own scripts, of course!)
exec sp_addarticle @.publication = N'myPUB', @.article = N'tbl_foo',
@.source_owner = N'dbo', @.source_object = N'tbl_foo',
@.destination_table = N'tbl_foo',
@.type = N'logbased', @.creation_script = null, @.description = null,
@.pre_creation_cmd = N'drop',
@.schema_option = 0x00000000000000F3, @.status = 0,
@.vertical_partition = N'false',
@.ins_cmd = N'SQL', @.del_cmd = N'SQL', @.upd_cmd = N'SQL',
@.filter = null, @.sync_object = null, @.auto_identity_range = N'false'
Those "@.ins_cmd" and such say "SQL", which echoes the SQL, rather than
use CALL, MCALL, or XCALL. See also BOL section, "Using Custom Stored
Procedures in Articles"
J.
Thursday, March 22, 2012
Digitally Signing
1. Has anyone ever digitally signed a PDF coming out of Reporting Services?
2. When will you be able to generate a Word document from a Reporting Services Report?
Dave
Currently there is no real way to sign a PDF in the true sense of the word - The best you can really do is generate a hash off of the fully rendered PDF and then store the hash somewhere else...later you can use the hash to make sure the report hasn't been modified.
There is no ETA on SSRS being able to render to Word...SoftArtisans has a product which will do this now, though (http://officewriter.softartisans.com/)
Wednesday, March 21, 2012
difficult SQL select statement
Hi all,
i have a table containing 24 columns, i would like to generate a new table by input the program gets from the user concurning of the columns he would like to see.
sound like an easy "select ? from table", but the thing is that how can the function know how to get a different number of variables, i mean, one time the user will want to see one column, and afterwards he will want to see 10 columns, is there a solution except generating 24 functions?.
i looked in all kinds of SQL tutorials and nothing came up so i came here, tnx for your help!.
Alon.public string GenerateSqlSelect(string[] columnNames){
return "SELECT "+String.Join(", ",columnNames)+" FROM MyTable";
}
|||You could use params keyword to specify that your function has a variable number of arguments.|||How user will know what are the columns from the table. Does he will write them, or select them using check boxes or some other method. I realy don't understand what are you for. Can you describe how user interface will look like, or some scenario of application work.
It is common practice that you always get all columns from table, but user can control which column want to see, for example in a grid or listview. So he will at first see all columns but it will be able to remove some of them. That configuration can be saved and used for next application start.
difficult SQL select statement
Hi all,
i have a table containing 24 columns, i would like to generate a new table by input the program gets from the user concurning of the columns he would like to see.
sound like an easy "select ? from table", but the thing is that how can the function know how to get a different number of variables, i mean, one time the user will want to see one column, and afterwards he will want to see 10 columns, is there a solution except generating 24 functions?.
i looked in all kinds of SQL tutorials and nothing came up so i came here, tnx for your help!.
Alon.public string GenerateSqlSelect(string[] columnNames){
return "SELECT "+String.Join(", ",columnNames)+" FROM MyTable";
}
|||You could use params keyword to specify that your function has a variable number of arguments.|||How user will know what are the columns from the table. Does he will write them, or select them using check boxes or some other method. I realy don't understand what are you for. Can you describe how user interface will look like, or some scenario of application work.
It is common practice that you always get all columns from table, but user can control which column want to see, for example in a grid or listview. So he will at first see all columns but it will be able to remove some of them. That configuration can be saved and used for next application start.sql
difficult SQL select statement
Hi all,
i have a table containing 24 columns, i would like to generate a new table by input the program gets from the user concurning of the columns he would like to see.
sound like an easy "select ? from table", but the thing is that how can the function know how to get a different number of variables, i mean, one time the user will want to see one column, and afterwards he will want to see 10 columns, is there a solution except generating 24 functions?.
i looked in all kinds of SQL tutorials and nothing came up so i came here, tnx for your help!.
Alon.public string GenerateSqlSelect(string[] columnNames){
return "SELECT "+String.Join(", ",columnNames)+" FROM MyTable";
}
|||You could use params keyword to specify that your function has a variable number of arguments.|||How user will know what are the columns from the table. Does he will write them, or select them using check boxes or some other method. I realy don't understand what are you for. Can you describe how user interface will look like, or some scenario of application work.
It is common practice that you always get all columns from table, but user can control which column want to see, for example in a grid or listview. So he will at first see all columns but it will be able to remove some of them. That configuration can be saved and used for next application start.
Friday, March 9, 2012
Different XML elements on the same level?
I want something like this for my output:
<root>
<someNode1>
<someNode2 />
</someNode1>
<someNode3>
<someNode4 />
</someNode3>
</root>
The problem is that I end up getting an "originally declared" node being "redeclared" as something else error. In this case, someNode1 is "redeclared" as someNode3. It looks as though it's not possible to create two different elements on the same level. I've not found any samples in documentation that show such a scenario. Anybody have a solution or hack? It seems like this kind of output would be common in the business world.
TIA,
Ian
Hi there,
I'm no expert on this but came across your post whilst being up against a similar problem.
This URL helped me out: http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbugen9/00000535.htm
This is a working example derived from something I am working on myself:
SELECT
1 AS Tag,
NULL AS Parent,
1 AS [Item!1!Id],
'Item' AS [Item!1!Name],
1 AS [Item!1!ParentId],
NULL AS [NutritionalBreakdown!2!Calories!element],
NULL AS [NutritionalBreakdown!2!Protein!element]
UNION ALL
SELECT
2,
1,
NULL,
NULL,
NULL,
'test calorie data',
'test protein data'
ORDER BY Tag
FOR XML EXPLICIT
Produces:
<Item Id="1" Name="Item" ParentId="1">
<NutritionalBreakdown>
<Calories>test calorie data</Calories>
<Protein>test protein data</Protein>
</NutritionalBreakdown>
</Item>
Hope that helps!
Different XML elements on the same level?
I want something like this for my output:
<root>
<someNode1>
<someNode2 />
</someNode1>
<someNode3>
<someNode4 />
</someNode3>
</root>
The problem is that I end up getting an "originally declared" node being "redeclared" as something else error. In this case, someNode1 is "redeclared" as someNode3. It looks as though it's not possible to create two different elements on the same level. I've not found any samples in documentation that show such a scenario. Anybody have a solution or hack? It seems like this kind of output would be common in the business world.
TIA,
Ian
Hi there,
I'm no expert on this but came across your post whilst being up against a similar problem.
This URL helped me out: http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbugen9/00000535.htm
This is a working example derived from something I am working on myself:
SELECT
1 AS Tag,
NULL AS Parent,
1 AS [Item!1!Id],
'Item' AS [Item!1!Name],
1 AS [Item!1!ParentId],
NULL AS [NutritionalBreakdown!2!Calories!element],
NULL AS [NutritionalBreakdown!2!Protein!element]
UNION ALL
SELECT
2,
1,
NULL,
NULL,
NULL,
'test calorie data',
'test protein data'
ORDER BY Tag
FOR XML EXPLICIT
Produces:
<Item Id="1" Name="Item" ParentId="1">
<NutritionalBreakdown>
<Calories>test calorie data</Calories>
<Protein>test protein data</Protein>
</NutritionalBreakdown>
</Item>
Hope that helps!