Friday, March 30, 2012
Is it possible to put in "IF ...ELSE" or "Case" in WHERE CLAUSE?
need your help... i am now trying to create a report using SQL reporting services... when declare all the @.parameters needed in where clause, i have come across a problem. where one of the parameters that prompting user to key in...i need to put in some condition.
select..............(blah blah).....
.....(SELECT CASE WHEN
((SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID)) = 1 THEN 0 ELSE 1 END) AS PTType .....................(blah blah)......
where (CONVERT(Varchar(10), tbl_OutpatientReg.VisitDatetime, 103) BETWEEN @.FromDate AND @.ToDate) OR (@.FromDate = ' ') OR (@.ToDate = ' ')
AND (@.PatientType = CASE WHEN
(SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID) = 1 THEN 0 ELSE 1 END)
my situition is something like above, i know i have done something wrong in teh WHERE clause for the @.PatientType... can i ask how to restrict the parameters entered by user, let's say if user enter parameter "0", then the visitcount is 1, if enter "1" then the visit count refers to more than 1...
thanks in advanced ...............Your post is kind of confusing regarding requirements, but part of your problem may be due to using brackets where they are not necessary, and not using them where they might be necessary to specify logical operations.
--Your Version:
where (CONVERT(Varchar(10), tbl_OutpatientReg.VisitDatetime, 103) BETWEEN @.FromDate AND @.ToDate)
OR (@.FromDate = ' ')
OR (@.ToDate = ' ')
AND (@.PatientType = CASE
WHEN (SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID) = 1 THEN 0
ELSE 1
END)
--Unnecessary brackets removed:
where CONVERT(Varchar(10), tbl_OutpatientReg.VisitDatetime, 103) BETWEEN @.FromDate AND @.ToDate
OR @.FromDate = ' '
OR @.ToDate = ' '
AND @.PatientType = CASE
WHEN (SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID) = 1 THEN 0
ELSE 1
END
--Useful brackets added:
where (CONVERT(Varchar(10), tbl_OutpatientReg.VisitDatetime, 103) BETWEEN @.FromDate AND @.ToDate
OR @.FromDate = ' '
OR @.ToDate = ' ')
AND @.PatientType = CASE
WHEN (SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID) = 1 THEN 0
ELSE 1
END|||ya...thanks for reminding me...as there are too many parameters to pass, i also confused... ;) anyway, really appreciate ur help
Is it possible to publish subscriptions to Reporting Services?
done surreptitiously in the database?
Thanks,
Bill MellYes it is possible . . . using the CreateSubscription method.
(just in case anyone cares)
Bill Mell
"Bill Mell" <BillM@.netforcement.com> wrote in message
news:%23sRXzT0DIHA.1316@.TK2MSFTNGP02.phx.gbl...
> Is there anything in the API that would support this, or would it have to
be
> done surreptitiously in the database?
> Thanks,
> Bill Mell
>sql
is it possible to pass a report table column in sql reporting serivces
I am having a storeprocedure which will return 10 columns data and i designed a table with 10 columns and i made 2 columns, visible = false.
Is it possible to show those two columns visible = true at runtime?
Please give me how to do.
Thanks & Regards
Lokesh
Select the column in the report designer, then set the Hidden property under Visibility in the Properties window to an expression. Set that expression to contain the logic you desire.
Hope that helps,
-Lukasz
is it possible to pass a report table column in sql reporting serivces
I am having a storeprocedure which will return 10 columns data and i designed a table with 10 columns and i made 2 columns, visible = false.
Is it possible to show those two columns visible = true at runtime?
Please give me how to do.
Thanks & Regards
Lokesh
Select the column in the report designer, then set the Hidden property under Visibility in the Properties window to an expression. Set that expression to contain the logic you desire.
Hope that helps,
-Lukasz
sqlWednesday, March 28, 2012
Is it possible to localize Report Manager using satellite assembly
I'm trying to localize Report Manager (Reporting Services 2005) by
implementing my own Finnish version of the resources in
ReportingServicesWebUserInterface.dll assembly.
I have the satellite assembly in the following folder:
C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting
Services\ReportManager\Bin\fi
I used the Assembly Linker tool (al) to create the assembly and used the
ReportingServicesWebUserInterface.dll in the base directory as the template.
I tried delay signing the assembly using my own key. Then I used the Strong
Name
Utility (sn) to add the assembly to skip verification list.
For some reason my satellite assembly is not loaded when I set my web
browser language to Finnish. If I set it to German it works ok. I have very
little .NET experience by I suspect that is due to the fact that the
sattelite assembly should be signed with the same key as the base assembly?
So is it possible to implement your own language version of the
ReportingServicesWebUserInterface.dll satellite assembly to use it to
localize report manager?
If it is possible is there any document that describes the process and the
related security issues?
If it's not possible then please tell me so that I can make a decision about
developing a new report portal web application. We would like to use the
Report Manager if we only could localize it.
I tried emailing the Gold Certified Partner support address, but got no
answer. Any assitance will be greatly appreciated.
Thank you,
Juho Salo> I tried emailing the Gold Certified Partner support address, but got no
> answer.
Scractch that. They actually called me instead of emailing, but my phone was
not on, stupid I know. I will post the answer here when I get it.
Juho|||I have received a very decisive answer from Microsoft.
Quote:
"You have asked if it is possible to implement your own language version of
the ReportingServicesWebUserInterface.dll satellite assembly to use it to
localize report manager. Unfortunately, this is NOT possible. The Report
Manager resource assemblies MUST be signed with a Microsoft key."
So if anyone else is wondering, if you need to localize Report Manager
easily it's not possible (unless ofcourse you live in one of those
priviledged countries that are provided with localization for it).
I'm off to writing my own report portal application then.|||I actually came up with a solution that is a bit of a hack but will do nicely
and let's me use the Report Manager. Just add the code below to all of the
aspx pages under the Report Manager\Pages folder
<script language=cs runat=server src= "Dictionary.cs"/>
<script language="C#" runat="server">
void Page_LoadComplete(object sender, EventArgs e) {
TranslateControls(Page);
}
private void TranslateControls(Control c)
{
Type t = c.GetType();
System.Reflection.PropertyInfo p = t.GetProperty("Text");
string s;
if (p != null) {
s = (string) p.GetValue(c, null);
if (s!= null ) {
if (s.Length > 0 ) {
if (p.CanWrite)
{
p.SetValue(c, Dictionary.Translate((string) p.GetValue(c, null)), null);
}
}
}
}
foreach (Control child in c.Controls)
{
TranslateControls(child);
}
}
</script>
Then just create some sort of implementation for the Dictionary class in the
Dictionary.cs file. The code above is not the final version but it works.
Comments are welcome.
Is it possible to launch a report rendered in excel or pdf instead of report viewer?
click on it and have it render to excel or pdf by instead of report
viewer. Is this possible? I know that I can create rs scripts that run
a report and render to excel, but would like to users to experience
this on the web if possible. I couldn't find this option.you can try to send the format you want in the URL:
http://localhost/......&rs:Format=Excel
"steve" <stevensherman@.comcast.net> wrote in message
news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> On my reporting services website, I would like to browse to a report,
> click on it and have it render to excel or pdf by instead of report
> viewer. Is this possible? I know that I can create rs scripts that run
> a report and render to excel, but would like to users to experience
> this on the web if possible. I couldn't find this option.
>|||Putting the format in the url works nicely. Thanks for the reply - that
helps. I was hoping that the report manager would have a configuration
setting for a report that would indicate how to render it.
Jeje wrote:
> you can try to send the format you want in the URL:
> http://localhost/......&rs:Format=Excel
>
> "steve" <stevensherman@.comcast.net> wrote in message
> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> > On my reporting services website, I would like to browse to a report,
> > click on it and have it render to excel or pdf by instead of report
> > viewer. Is this possible? I know that I can create rs scripts that run
> > a report and render to excel, but would like to users to experience
> > this on the web if possible. I couldn't find this option.
> >|||I'm not sure, maybe you'll found in the config files of your reporting
services installation the default rendering format.
I'm sure there is a list of authorized formats, so I presume there is a
default rendering option.
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>|||Report manager is not configurable that way. You have to create your own
portal if you want to do that. I recommend against doing this. HTML is much
much faster and having all your reports default to PDF is just not a good
idea.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>sql
Monday, March 26, 2012
Is it possible to hide the report parameters after click on the view report button?
after selecting all the report paramters and click on the view report
button, i need to turn off or hide the report parameters.
please let me know is it possible to implement to do this.
any suggesstion
Thanks
VinodThere is a button the right side of the page of the reports browser
that look like to arrows on top of each other, click that and it will
hide the parameters. There are actually two sets, one for the
parameters and one for the web page header. Hope that helps.
Vinod wrote:
> i am working in SQL Reporting services 2005. i had a requirement that
> after selecting all the report paramters and click on the view report
> button, i need to turn off or hide the report parameters.
> please let me know is it possible to implement to do this.
> any suggesstion
> Thanks
> Vinod|||Thanks for the reply Kerrie.
i have seen the hide button icon in the report layout.but my
requirement is that i need to hide the parameters when i click on the
view report button in the report layout after selecting the all the
report parameters.
if user wants to modify the criteria again, he needs to click on the
hide icon in the report layout. then select the criteria and view the
report.
please let me know if you are not clear
Thanks
vinod
Kerrie wrote:
> There is a button the right side of the page of the reports browser
> that look like to arrows on top of each other, click that and it will
> hide the parameters. There are actually two sets, one for the
> parameters and one for the web page header. Hope that helps.
>
> Vinod wrote:
> > i am working in SQL Reporting services 2005. i had a requirement that
> > after selecting all the report paramters and click on the view report
> > button, i need to turn off or hide the report parameters.
> >
> > please let me know is it possible to implement to do this.
> >
> > any suggesstion
> >
> > Thanks
> > Vinod|||I'm pretty sure there's no function like that in RS out of the box. But I'm
thinking that if you can modify the View Report button's code, you could add
a java script that redirects to a url with parameters toolbar=false and the
chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
how easy that is.
Alternatively, create a aspx. page that creates the parameters to be chosen,
and send the users to a report using the same paramtererized url as
suggested above.
Kaisa M. Lindahl Lervik
"Vinod" <vinodsh_82@.hotmail.com> wrote in message
news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> Thanks for the reply Kerrie.
> i have seen the hide button icon in the report layout.but my
> requirement is that i need to hide the parameters when i click on the
> view report button in the report layout after selecting the all the
> report parameters.
> if user wants to modify the criteria again, he needs to click on the
> hide icon in the report layout. then select the criteria and view the
> report.
> please let me know if you are not clear
> Thanks
> vinod
>
> Kerrie wrote:
>> There is a button the right side of the page of the reports browser
>> that look like to arrows on top of each other, click that and it will
>> hide the parameters. There are actually two sets, one for the
>> parameters and one for the web page header. Hope that helps.
>>
>> Vinod wrote:
>> > i am working in SQL Reporting services 2005. i had a requirement that
>> > after selecting all the report paramters and click on the view report
>> > button, i need to turn off or hide the report parameters.
>> >
>> > please let me know is it possible to implement to do this.
>> >
>> > any suggesstion
>> >
>> > Thanks
>> > Vinod
>|||Thanks for the reply Kaisa.
i am not creating a aspx page for criteria. i have added 15 report
parameters in the report layout iteself. everything is fine upto this
point.
but my client requriment is that we dont want to show the report
parameters in the report layout after clicking on the view report
button. it should be hided.
let me know is it possible.
Thanks
Vinod
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure there's no function like that in RS out of the box. But I'm
> thinking that if you can modify the View Report button's code, you could add
> a java script that redirects to a url with parameters toolbar=false and the
> chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
> how easy that is.
> Alternatively, create a aspx. page that creates the parameters to be chosen,
> and send the users to a report using the same paramtererized url as
> suggested above.
> Kaisa M. Lindahl Lervik
> "Vinod" <vinodsh_82@.hotmail.com> wrote in message
> news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> > Thanks for the reply Kerrie.
> >
> > i have seen the hide button icon in the report layout.but my
> > requirement is that i need to hide the parameters when i click on the
> > view report button in the report layout after selecting the all the
> > report parameters.
> >
> > if user wants to modify the criteria again, he needs to click on the
> > hide icon in the report layout. then select the criteria and view the
> > report.
> >
> > please let me know if you are not clear
> >
> > Thanks
> > vinod
> >
> >
> > Kerrie wrote:
> >> There is a button the right side of the page of the reports browser
> >> that look like to arrows on top of each other, click that and it will
> >> hide the parameters. There are actually two sets, one for the
> >> parameters and one for the web page header. Hope that helps.
> >>
> >>
> >> Vinod wrote:
> >> > i am working in SQL Reporting services 2005. i had a requirement that
> >> > after selecting all the report paramters and click on the view report
> >> > button, i need to turn off or hide the report parameters.
> >> >
> >> > please let me know is it possible to implement to do this.
> >> >
> >> > any suggesstion
> >> >
> >> > Thanks
> >> > Vinod
> >
Is it possible to have reporting services without IIS?
reports locally (like Access)?
ThxOn Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
As far as I know, there is not. That said, I'm not sure how SSRS would
react if you somehow tried to tie it to Apache or some other web
server. Sorry that I could not offer further insight.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, Enrique
I guess same applies to Advanced Services
MS, please make this available on XP Home too.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||For development purposes you can install sql2005 dev edition (costs $50 or
comes free with VS2005) and you get all the features.
"AlexS" wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
>
>|||I asked about WinXP Home and SQL Express Advanced / Reporting, which is
available now from MS site for download.
Thanks for a tip - I will check dev edition.
"Jimbo" <Jimbo@.discussions.microsoft.com> wrote in message
news:9F612C59-BEC7-4854-BF02-C51F8DBFCFD4@.microsoft.com...
> For development purposes you can install sql2005 dev edition (costs $50 or
> comes free with VS2005) and you get all the features.
>
>
> "AlexS" wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>>
>|||On Jun 7, 12:54 pm, "AlexS" <salexru200...@.SPAMrogers.comPLEASE>
wrote:
> Thanks, Enrique
> I guess same applies to Advanced Services
> MS, please make this available on XP Home too.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> > On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> >> Is it possible to have SQL Express and Reporting Services on XP Home and
> >> use
> >> reports locally (like Access)?
> >> Thx
> > As far as I know, there is not. That said, I'm not sure how SSRS would
> > react if you somehow tried to tie it to Apache or some other web
> > server. Sorry that I could not offer further insight.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. SSAS I'm not sure about. Let me know if I can be of
further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||It would not work. RS is a asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Is it possible to get Multiple DataTables in a DataSet like VB.NET?
Hello
My stored procedure returns 4 recordsets. I require these recordsets as 4 different datatables in a dataset in Sql Server Reporting Services 2005, to use them on my rdl report.
I don't want to make the 4 diffrent datasets. Is it possible in SqlServer Reporting Services 2005? Please help me. Its urgent.
SSRS uses the first resultset returned from a stored procedure only.|||Thanx for the reply. But is there some way I can get all these recordsets. I have heard about Custom Data Extensions. Do these extensions help me in my problem. Or any other solution, other than data extension, if possible.|||Well, I think nobody here is interested to answer this one. Do anyone suggest me any good forum for Reporting services queries.
Looking.
|||I won't suggest you write a custom data extension just for this. Instead, if possible, I will consider wrapping up the stored procedure inside another stored procedure which will return the requested dataset.sqlIs it possible to get Multiple DataTables in a DataSet like VB.NET?
Hello
My stored procedure returns 4 recordsets. I require these recordsets as 4 different datatables in a dataset in Sql Server Reporting Services 2005, to use them on my rdl report.
I don't want to make the 4 diffrent datasets. Is it possible in SqlServer Reporting Services 2005? Please help me. Its urgent.
SSRS uses the first resultset returned from a stored procedure only.|||Thanx for the reply. But is there some way I can get all these recordsets. I have heard about Custom Data Extensions. Do these extensions help me in my problem. Or any other solution, other than data extension, if possible.|||Well, I think nobody here is interested to answer this one. Do anyone suggest me any good forum for Reporting services queries.
Looking.
|||I won't suggest you write a custom data extension just for this. Instead, if possible, I will consider wrapping up the stored procedure inside another stored procedure which will return the requested dataset.is it possible to freeze column or row in a report?
many columns and rows and it stretches beyond the width and height of the
paper size specified and the first row and column of the matrix report
showing the description of the data like the column/row header and I wonder
if it is possible to freeze this row and column in the report so that it is
visible when scrolling down or to the right of the report. Thanks.That is possible in RS 2005, but not in RS 2000
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <paul_mak@.shaw.ca> wrote in message
news:%23O6$fs7EGHA.3700@.TK2MSFTNGP15.phx.gbl...
>I am using sql 2000 reporting service. One of the matrix report which has
>so many columns and rows and it stretches beyond the width and height of
>the paper size specified and the first row and column of the matrix report
>showing the description of the data like the column/row header and I wonder
>if it is possible to freeze this row and column in the report so that it is
>visible when scrolling down or to the right of the report. Thanks.
>
Friday, March 23, 2012
Is it possible to edit the list of export options in RS 2000?
Hi,
I'm trying to edit the list of export options in Reporting Services 2000. I only want to display Excel and PDF in the export options list. I tried looking in the CSS file in the Styles folder, but didn't see anything that could be changed to accomplish this. Is it possible to do this?
Thanks,
Mike
Look in the RSReportSErver.config file. Add visible="false" to any rendering extensions you do not want to show up. You can also just remove them if you don't ever want people to use them (Although getting rid of html4.0 would break Report Manager.)|||Excellent! Thanks.Is it possible to deploy reports on server and view it from client machines
Hi,
I'm a newbie to reporting service.
I deployed a report on the server. When I viewed it on the server by entering the URL of http://localhost/reports$SQLExpress, everything's fine. When I tried to view it form a client machine on http://MyServerName/reports$SQLExpress, it failed. I did assign a role to the client user. I'm just wondering whether it is possible to do this.
I'm using SQL Express, the server runs win2003 server and the client machine runs winXP.
What was the error message? What authentication method are you using for reporting services?
sluggy
|||The error message was"The page cannot be displayed. The page you are looking for is currently unavaiable. blah...blah...".
I use Windows authentication for reporting service. Thanks!
|||You are probably hitting the double-hop problem with IIS
http://blogs.msdn.com/jgalla/archive/2006/03/16/553314.aspx
The fix is to store the credentials for accessing the datasource in the report server.
Wednesday, March 21, 2012
Is it possible to custom format the parameter dropdownlist?
parameter with a prompt 'Select a Project'. The project list contains
project names that are so long that they take up about 95% of the page
width and the View report button becomes a partially visible button
with a horizontal scroll bar to scroll further to the right to view the
entire page.
My users hate to have to scroll to the right. They are requesting a
fixed width dropdownlist with fully visible 'View report' button.
We want to make our DDL pretty narrow so that it only shows the first n
characters of the project name string when the DDL is not dropped down.
When the user
drops the list down we want to resize it wide enough to show the entire
string.
We could also assign a tool tip to the DDL if we could supply a unique
tip
to each row in the DDL?
Any ideas? Does SSRS 2005 let the designer specify the parameter
control width?
Many thanks in advance.I've found that the parameter panel is not at all configurable and have
been creating a front-end web page for each report giving me total
control over presentation. Then I hide the parameter panel via a
parameter on the URL. It's my understanding RS 2005 has more control
over the parameter panel.|||Many thanks, Kent.
Is it possible to create some kind of "libraries"?
I want to reuse parts of my last report in a new one -
is it possible to create some kind of "libraries" (or templates) in
Reporting Services?
Thanks.Now you can create your custom Report Templates, and keep it in managed code
and reuse it!, in this example will show you, how to sub-class
the Report Class and create your report templates for further reuse.
http://www.rdlcomponents.com/examples/inherited/inherited.aspx
Thanks
Jerry
"Hawkeye" wrote:
> Hi,
> I want to reuse parts of my last report in a new one -
> is it possible to create some kind of "libraries" (or templates) in
> Reporting Services?
> Thanks.
>
Is it possible to create dynamic reports using reporting services
I have a requirement to create dynamic reports for my client.
once i create these reports then the user will choose columns of there choice.
so the columns may belong to multiple tables.
Now the report should get generated with the layout etc. is it possible.
since our project is totally on the webserver(webbased.)
please if you can provide me with any links with dynamic report creation wizards.
and also we only use Stored procedures via database.
which is best is writing the entire queries right behind the layouit or calling the entire logic via Stored procedure. i am a bit confused. this is my first project working on reports itself.
Thank you all for the helpful information.
Sounds like you need to generate the report definitions programatically. The RDL Object Model code sample in this download should help.sqlIs it possible to create a bar code in SQL reporting?
I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.
Thanks
SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.When you've got the font then replace the font of the field wich has the code and that's all.
Good luck in your search.|||thanks|||
I found a better choice instead of using fonts.
Barcode Professional .NET for Reporting Services
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
|||Or you could try this Windows Form Control that supports Reporting Services.
http://www.technoriversoft.com/developer.html
|||Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.
In Crystal, I had to put an * before after the value.
In Excel, it works the same way.
But in SRS 2000, it will not work.
My expression is
="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"
I have also tried using the plus instead of *.
The font I am using is Free 3 of 9 Extended.
thanks for you help.
|||
IT is not good way
it is because when you compile the report into production server.
when user print it, it will show the text rather than bar code....
|||As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.
So what exactly is the fix. Was one ever found?
Is it possible to create a bar code in SQL reporting?
I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.
Thanks
SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.When you've got the font then replace the font of the field wich has the code and that's all.
Good luck in your search.|||thanks|||
I found a better choice instead of using fonts.
Barcode Professional .NET for Reporting Services
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
|||Or you could try this Windows Form Control that supports Reporting Services.
http://www.technoriversoft.com/developer.html
|||Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.
In Crystal, I had to put an * before after the value.
In Excel, it works the same way.
But in SRS 2000, it will not work.
My expression is
="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"
I have also tried using the plus instead of *.
The font I am using is Free 3 of 9 Extended.
thanks for you help.
|||
IT is not good way
it is because when you compile the report into production server.
when user print it, it will show the text rather than bar code....
|||As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.
So what exactly is the fix. Was one ever found?
sqlIs it possible to create a bar code in SQL reporting?
I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.
Thanks
SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.When you've got the font then replace the font of the field wich has the code and that's all.
Good luck in your search.|||thanks|||
I found a better choice instead of using fonts.
Barcode Professional .NET for Reporting Services
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
|||Or you could try this Windows Form Control that supports Reporting Services.
http://www.technoriversoft.com/developer.html
|||Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.
In Crystal, I had to put an * before after the value.
In Excel, it works the same way.
But in SRS 2000, it will not work.
My expression is
="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"
I have also tried using the plus instead of *.
The font I am using is Free 3 of 9 Extended.
thanks for you help.
|||
IT is not good way
it is because when you compile the report into production server.
when user print it, it will show the text rather than bar code....
|||As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.
So what exactly is the fix. Was one ever found?
Is it possible to create a bar code in SQL reporting?
I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.
Thanks
SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.When you've got the font then replace the font of the field wich has the code and that's all.
Good luck in your search.|||thanks|||
I found a better choice instead of using fonts.
Barcode Professional .NET for Reporting Services
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
|||Or you could try this Windows Form Control that supports Reporting Services.
http://www.technoriversoft.com/developer.html
|||Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.
In Crystal, I had to put an * before after the value.
In Excel, it works the same way.
But in SRS 2000, it will not work.
My expression is
="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"
I have also tried using the plus instead of *.
The font I am using is Free 3 of 9 Extended.
thanks for you help.
|||
IT is not good way
it is because when you compile the report into production server.
when user print it, it will show the text rather than bar code....
|||As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.
So what exactly is the fix. Was one ever found?