Showing posts with label own. Show all posts
Showing posts with label own. Show all posts

Wednesday, March 7, 2012

My Very Own SOAP / Web Service Report Viewer

Well, I've finally done it! The first fully functional prototype of the
report viewer control for Reporting Services 2000 is complete. I am
working on a project that cannot wait until RS 2005, so we bit the
bullet and wrote our own component (URL access will not work for a
number of reasons).
Alon with report selection, I have implemented:
1) Parameter selection (including linked params)
2) Page navigation
3) Zooming
4) Refresh
5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
6) Printing
I have received a lot of help from the RS community, so may thanks to
those of you who frequent this group!
Kulgan.Congratulations!
I have been struggling to build one too. Would you mind sharing your
code/ideas on how to go on about it?
TIA.
Marlon
"Kulgan" <nickamckenna@.gmail.com> wrote in message
news:1121180309.308222.314710@.g43g2000cwa.googlegroups.com...
> Well, I've finally done it! The first fully functional prototype of the
> report viewer control for Reporting Services 2000 is complete. I am
> working on a project that cannot wait until RS 2005, so we bit the
> bullet and wrote our own component (URL access will not work for a
> number of reasons).
> Alon with report selection, I have implemented:
> 1) Parameter selection (including linked params)
> 2) Page navigation
> 3) Zooming
> 4) Refresh
> 5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
> 6) Printing
> I have received a lot of help from the RS community, so may thanks to
> those of you who frequent this group!
> Kulgan.
>|||Unfortunately the code belongs to the client I have done the work for,
but I will be doing an open source version shortly (when I return from
holiday in a couple of weeks).
I will keep you posted!
In the meantime, if you get stuck, email me and I'll help wherever I
can.
Cheers,
Kulgan.|||Yes, thats great! I have the exact same issue that I need to resolve, i.e.
using the viewer through SOAP. I would love to see how you did this!
"TechnoSpyke" wrote:
> Congratulations!
> I have been struggling to build one too. Would you mind sharing your
> code/ideas on how to go on about it?
> TIA.
> Marlon
> "Kulgan" <nickamckenna@.gmail.com> wrote in message
> news:1121180309.308222.314710@.g43g2000cwa.googlegroups.com...
> > Well, I've finally done it! The first fully functional prototype of the
> > report viewer control for Reporting Services 2000 is complete. I am
> > working on a project that cannot wait until RS 2005, so we bit the
> > bullet and wrote our own component (URL access will not work for a
> > number of reasons).
> >
> > Alon with report selection, I have implemented:
> >
> > 1) Parameter selection (including linked params)
> > 2) Page navigation
> > 3) Zooming
> > 4) Refresh
> > 5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
> > 6) Printing
> >
> > I have received a lot of help from the RS community, so may thanks to
> > those of you who frequent this group!
> >
> > Kulgan.
> >
>
>|||Me too.
tnx.
Tom.

Monday, February 20, 2012

My own report parameters

Hi there,
Can I add my own report parameters on report parameter area of a sql server
report 2005.
I have a label, textbox followed by a button. Open a aspx search page
onclicking the button.
Thanks,
RaviI not sure I really understand your question..
However one of the things you can do , create and upload an aspx page to
Reporting Services, which you have programmed to collect any parameter
information you wish. It could also contain a button, that calls your report
URL, passing in the parameter values you have collected.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Ravi Manda" wrote:
> Hi there,
> Can I add my own report parameters on report parameter area of a sql server
> report 2005.
> I have a label, textbox followed by a button. Open a aspx search page
> onclicking the button.
> Thanks,
> Ravi|||My requirement is something like this, I want to have a label, textbox and
button, on clicking the button I will open a page and the page returns a some
value which should be populted in the textbox. But we don't have control on
report parameter area of a report.
As per my understadning from your reply is I need to have a aspx page with
my own parameters and a reportviewer control pass these parameters with the
URL to the report. (I'm ok with this answer).
Please confirm me that we cann't add our own controls on the report
parameter area.
(We don't want to have a dropdownlist incase the items cross's more then
100. In this case we add a text box and a button on the report parameter
area. Onclicking the button I will open a search page in a popup window).
Search page contains all search fields and a grid. Selecting on a particular
row on the grid I need to pass the value to the textbox of the report).
Thanks
"Wayne Snyder" wrote:
> I not sure I really understand your question..
> However one of the things you can do , create and upload an aspx page to
> Reporting Services, which you have programmed to collect any parameter
> information you wish. It could also contain a button, that calls your report
> URL, passing in the parameter values you have collected.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Ravi Manda" wrote:
> > Hi there,
> >
> > Can I add my own report parameters on report parameter area of a sql server
> > report 2005.
> >
> > I have a label, textbox followed by a button. Open a aspx search page
> > onclicking the button.
> >
> > Thanks,
> > Ravi

My own little piece of SQL Wierdness

This has me stumped.
I have a parent and a child table with a constraint on the parent's foreign
key in
the child.
So with this in mind, every once in a while when I am exporting data, I get
an error
that there is a row in the child table with and ID that is not in the parent
table.
One of our programmers is using ADO transactions and beginning it in source
code (not
a proc). Then he adds a row to the parent table, gets the ID in one proc an
d adds a
row to the child table in another proc. Then he commits or aborts when he g
ets back
to code.
Can you think of any reason why the row in the child table is there, but the
row in
the parent isn't there when exporting data?
Thanks.Do you have foreign key constraints on your tables? If so, then it sounds
like a query issue. Otherwise, my guess is the programs arent doing
"something" right?
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Mike Malter" <mikemalter@.newsgroup.nospam> wrote in message
news:ut9Jr40pFHA.3524@.tk2msftngp13.phx.gbl...
> This has me stumped.
> I have a parent and a child table with a constraint on the parent's
> foreign key in the child.
> So with this in mind, every once in a while when I am exporting data, I
> get an error that there is a row in the child table with and ID that is
> not in the parent table.
> One of our programmers is using ADO transactions and beginning it in
> source code (not a proc). Then he adds a row to the parent table, gets
> the ID in one proc and adds a row to the child table in another proc.
> Then he commits or aborts when he gets back to code.
> Can you think of any reason why the row in the child table is there, but
> the row in the parent isn't there when exporting data?
> Thanks.
>|||The foreign key constraint is not being enforced.
exec sp_helpconstraint N'tableName'
The second result set contains a list of constraints. Check the
status_enabled column for the foreign key constraint in question. If it's
Disabled, then the constraint will not be enforced.
"Mike Malter" <mikemalter@.newsgroup.nospam> wrote in message
news:ut9Jr40pFHA.3524@.tk2msftngp13.phx.gbl...
> This has me stumped.
> I have a parent and a child table with a constraint on the parent's
foreign key in
> the child.
> So with this in mind, every once in a while when I am exporting data, I
get an error
> that there is a row in the child table with and ID that is not in the
parent table.
> One of our programmers is using ADO transactions and beginning it in
source code (not
> a proc). Then he adds a row to the parent table, gets the ID in one proc
and adds a
> row to the child table in another proc. Then he commits or aborts when he
gets back
> to code.
> Can you think of any reason why the row in the child table is there, but
the row in
> the parent isn't there when exporting data?
> Thanks.
>

My own Dataflow Component. How make a property with list of predefined values?

I am creating of may of dataflow component.

How make a property with list of predefined values?

Thanks in advance.

If you create a custom UI for the component, you can display any list for the property that you like.

If you really want to do it right, so that the list shows up in the property window in Visual Studio, you'll probably need to implement a UITypeEditor and possibly a TypeConverter. See the Books Online topic "Design-time Methods of a Data Flow Component" for more information. http://msdn2.microsoft.com/de-de/library/ms135969.aspx

|||

Please see this earlier thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=115642&SiteID=1

-Doug

|||I would also look at using an enumeration for the property type/value.

My Own - Multi Select Parameter Passing Implementation

Hi,
I would like to share how I implemented in my application by passing multi
select parameters into the report.
1. In my .net file, I have created a list box which I load all the multi
values that the user wants to report on(for Ex: Equipment Id = 100,200,300,400 and so on).
2. When the user submits the page, I load the above list into a table.
3. In my stored procedure, I go after this table and build the SELECT
statement.
4. Since the report has to refreshed everytime they add another value into
the list, the report has to know that it has to refresh. For this what I have
done is on the table that i load all the values, I extract the SEQUENCE # and
pass it to the report(it is a unique # everytime when you refresh the page).
U can also pass a Random # but the uniqueness is not guaranteed and the
report may not refresh.
In the Report Designer:
1. I create a parameter called RefreshReport. This value that gets passed
into the parameter is the SEQUENCE value.
I poured my head into 3 books for some clue and couldn't find one hint.
I will be more than happy to answer any questions regarding this
implementation..hi, can you be more detailing? I've been following a guide from a book,
there's this query:
="SELECT * FROM vProductProfitability WHERE (Year = @.Year) AND (Mon
thNumberOfYear = @.Month) AND (Category IN (â'+Parameters!CategoryStrin
g.Value+â'))â'
yes, like what you said, you created a new parameter, in here, the the param
is category string, I dn't know where to put this query since i'm using a
stored procedure.. the only way we can use this query is by using text, so
about your stored procedure that you changed.. what is it?
what i can still select is 1 item, although i'm using checkboxlist, i can
select all of them, but w/ an error of course.
can you please discuss how you manage to enable multi select, since you've
posted a helping memo in here already.. advance thanks!
--
~SiMPLe~
"Suresh" wrote:
> Hi,
> I would like to share how I implemented in my application by passing multi
> select parameters into the report.
> 1. In my .net file, I have created a list box which I load all the multi
> values that the user wants to report on(for Ex: Equipment Id => 100,200,300,400 and so on).
> 2. When the user submits the page, I load the above list into a table.
> 3. In my stored procedure, I go after this table and build the SELECT
> statement.
> 4. Since the report has to refreshed everytime they add another value into
> the list, the report has to know that it has to refresh. For this what I have
> done is on the table that i load all the values, I extract the SEQUENCE # and
> pass it to the report(it is a unique # everytime when you refresh the page).
> U can also pass a Random # but the uniqueness is not guaranteed and the
> report may not refresh.
> In the Report Designer:
> 1. I create a parameter called RefreshReport. This value that gets passed
> into the parameter is the SEQUENCE value.
> I poured my head into 3 books for some clue and couldn't find one hint.
> I will be more than happy to answer any questions regarding this
> implementation..