Showing posts with label custom. Show all posts
Showing posts with label custom. Show all posts

Wednesday, March 21, 2012

Quoted Identifiers in a CSV

There have been some posts on the difficulties of handling csv with quoted identifers.

I heard there were some custom components that aid in dealing with these as input files.

IYO, what do you consider to be the best way to deal with csv with quoted identifiers as an input to an ETL operation?

Also, if you know of any bloggers making quality (hopefully free) custom components?

Thanks!!

Personally, I've found the easiest way is to use a genuine CSV Reader,which handles all the special cases that SSIS does not. Make a Script Source Component using it. See http://www.csvreader.com/, or for a free version, try http://www.codeproject.com/cs/database/CsvReader.asp.

Wednesday, March 7, 2012

Quick Question

hello I am trying to use the reportviewer control in a custom web app.
Currently using a frame based design where I have a treeview of all the
reports available and a click on the individual report should open the
reportviewer control in another frame.
Currently facing issues passing the exact URL.
here is how my base URL
newNode.NavigateUrl = "http://server-name/reportserver?" & cirep.Path &
"
Trying passing target but without much luck. Anyway knows how to do it
?
Thanx.
Q2 I know that using frames is generally not preferred.
is there a better way to achieve what i am trying to accomplish with a
treeview or a menu on the Left side and the reportviewer showing up on
the right side ?
Thx
RaviSince frames really aren't supported by the gui in visual studio, I
generally just put the nav and the data on the same page. Network speeds
what they are, it shouldn't be an issue.
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109019748.507926.276380@.c13g2000cwb.googlegroups.com...
> hello I am trying to use the reportviewer control in a custom web app.
> Currently using a frame based design where I have a treeview of all the
> reports available and a click on the individual report should open the
> reportviewer control in another frame.
> Currently facing issues passing the exact URL.
> here is how my base URL
> newNode.NavigateUrl = "http://server-name/reportserver?" & cirep.Path &
> "
> Trying passing target but without much luck. Anyway knows how to do it
> ?
> Thanx.
> Q2 I know that using frames is generally not preferred.
> is there a better way to achieve what i am trying to accomplish with a
> treeview or a menu on the Left side and the reportviewer showing up on
> the right side ?
> Thx
> Ravi
>|||you mean something like using a table or
using different dataregions or rectangles ?|||I mean just putting the report viewer control in an html table.
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109025325.041436.297720@.g14g2000cwa.googlegroups.com...
> you mean something like using a table or
> using different dataregions or rectangles ?
>|||Hello Mike,
Thanks for the info. This is what I am trying to do.
I want a treeview as the navigation on the left and the reportviewer
next to it.
But the issue i am facing is that when I use a treeview, I set the
values to the treeviewnode.navigateUrl and I click on the link to a
report, it is rendering on the whole page.
But When I use a dropdown menu I could make it render to a certain
region like a cell in a Html table. good thing about the dropdown menu
is that there is OnClick Event which I dont seem to have in the
treeview control I downloaded from the Asp.net web controls.
Any hints on how to go about ?
Thankx very much
Ravi|||(Hmmm. I thought I replied to this yesterday, but I don't see it now.
Sorry if this is a dup response.)
I'm not sure I understand how you are rendering the report. Are you
redirecting to a url, using the render method...? Also, do you know about
the report viewer control?
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109038650.929162.40500@.c13g2000cwb.googlegroups.com...
> Hello Mike,
> Thanks for the info. This is what I am trying to do.
> I want a treeview as the navigation on the left and the reportviewer
> next to it.
> But the issue i am facing is that when I use a treeview, I set the
> values to the treeviewnode.navigateUrl and I click on the link to a
> report, it is rendering on the whole page.
> But When I use a dropdown menu I could make it render to a certain
> region like a cell in a Html table. good thing about the dropdown menu
> is that there is OnClick Event which I dont seem to have in the
> treeview control I downloaded from the Asp.net web controls.
> Any hints on how to go about ?
> Thankx very much
> Ravi
>|||I am using the reportviewer control. It may sound stupid but my exact
problem has been how do I tie the reportviewer control to a node in the
treeview.
I am using the treenode.navigateUrl property to set the url, which is
causing it to render it all over the screen.
I dont have this problem when I use a dropdown menu of reports and a Go
button. I use the Onclick event of the go button to set the properties
to the reportviewer control.
Thx
Ravi|||Ok, so you're passing the url of the report to the treeview control?
Instead, the navigateurl should be to the same page (like a postback) and
set the querystring to be the value of the report you're trying to view
(navigateurl = samepage.aspx?report=" & reportvar). (of course, instead of
a querystring you could use the viewstate object or a session object or
.... ) On the load event of the page, check if there is a value in the
querystring, and if so set the property of the reportviewer.
Was that vague enough?
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109087785.988437.208740@.o13g2000cwo.googlegroups.com...
>I am using the reportviewer control. It may sound stupid but my exact
> problem has been how do I tie the reportviewer control to a node in the
> treeview.
> I am using the treenode.navigateUrl property to set the url, which is
> causing it to render it all over the screen.
> I dont have this problem when I use a dropdown menu of reports and a Go
> button. I use the Onclick event of the go button to set the properties
> to the reportviewer control.
> Thx
> Ravi
>|||Hey Mike,
here is the URL i am passing to the navigateUrl property of the
Treenodes.
This posts the report to the same page. But it doesnt render in the
reportviewer control object I have in a html table in the same page,
which i am trying to achieve.
http://servername/reportserver?/folder/report1&rs:Command=Render&rc:zoom=75&rc:toolbar=true
thx
ravi|||Maybe I don't understand: How are you rendering the report? It sounds like
you are either redirecting the user to the report page or using the render
method of the web service?
Do you know about the asp.net report viewer control?
Mike
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109038650.929162.40500@.c13g2000cwb.googlegroups.com...
> Hello Mike,
> Thanks for the info. This is what I am trying to do.
> I want a treeview as the navigation on the left and the reportviewer
> next to it.
> But the issue i am facing is that when I use a treeview, I set the
> values to the treeviewnode.navigateUrl and I click on the link to a
> report, it is rendering on the whole page.
> But When I use a dropdown menu I could make it render to a certain
> region like a cell in a Html table. good thing about the dropdown menu
> is that there is OnClick Event which I dont seem to have in the
> treeview control I downloaded from the Asp.net web controls.
> Any hints on how to go about ?
> Thankx very much
> Ravi
>|||This is more of an asp.net question than reporting services, but the url
you're passing to the treeview tells it where to navigate. You're telling
it to navigate away from your page and to the report page. Instead, the
link should be closer to:
http://server/path/nameofcurrentpage.aspx?report=report1
you then have to have code on nameofcurrentpage.aspx that retrieves the
value from the querystring and changes the property of the report viewer
control appropriately.
For more info, look for docs on querystrings in asp.net.
Mike G.
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109090642.640699.254080@.l41g2000cwc.googlegroups.com...
> Hey Mike,
> here is the URL i am passing to the navigateUrl property of the
> Treenodes.
> This posts the report to the same page. But it doesnt render in the
> reportviewer control object I have in a html table in the same page,
> which i am trying to achieve.
> http://servername/reportserver?/folder/report1&rs:Command=Render&rc:zoom=75&rc:toolbar=true
> thx
> ravi
>|||You can do what you want using a combination of a modified ReportViewer
control and the rc:ReplacementRoot parameter. You can see where we came up
with this idea here:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/fc71a51d020123ed/a295a0d77da59b6c?q=replacementroot&_done=%2Fgroup%2Fmicrosoft.public.sqlserver.reportingsvcs%2Fsearch%3Fgroup%3Dmicrosoft.public.sqlserver.reportingsvcs%26q%3Dreplacementroot%26qt_g%3D1%26&_doneTitle=Back+to+Search&&d#a295a0d77da59b6c
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109019748.507926.276380@.c13g2000cwb.googlegroups.com...
> hello I am trying to use the reportviewer control in a custom web app.
> Currently using a frame based design where I have a treeview of all the
> reports available and a click on the individual report should open the
> reportviewer control in another frame.
> Currently facing issues passing the exact URL.
> here is how my base URL
> newNode.NavigateUrl = "http://server-name/reportserver?" & cirep.Path &
> "
> Trying passing target but without much luck. Anyway knows how to do it
> ?
> Thanx.
> Q2 I know that using frames is generally not preferred.
> is there a better way to achieve what i am trying to accomplish with a
> treeview or a menu on the Left side and the reportviewer showing up on
> the right side ?
> Thx
> Ravi
>|||Hello jeff,
I have modified the reportviewer code adding your code and created the
new dll.
I also added the rc:ReplacementRoot = MyIframe in the Build URl string
method.
Do I need to do that ?
But when I actually ran the app with the new reportviewer DLL (removed
the old and added new reference to reportviewer, just to be sure) it is
still opening the drillthrough reports in a different Browser window.
And I dont see the rc:replacementroot part in the URL of the
drillthrough.
Am i missing anything ?
Thanks
Ravi|||Sorry it took so long to get back to you. I answered these questions in
another thread.
By the way, there's not a need to start all these new threads for the same
issue! Now others will have a difficult time finding the answer to your
question, since you started so many different threads on this same issue.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109276158.622182.138890@.f14g2000cwb.googlegroups.com...
> Hello jeff,
> I have modified the reportviewer code adding your code and created the
> new dll.
> I also added the rc:ReplacementRoot = MyIframe in the Build URl string
> method.
> Do I need to do that ?
> But when I actually ran the app with the new reportviewer DLL (removed
> the old and added new reference to reportviewer, just to be sure) it is
> still opening the drillthrough reports in a different Browser window.
> And I dont see the rc:replacementroot part in the URL of the
> drillthrough.
> Am i missing anything ?
> Thanks
> Ravi
>

Quick custom security question

I am trying to implement some type of security based on the user, the
report, and what parameters the are supplying.
So lets say that I have a report called "Salary Report" that shows
employees salary and bonus data. The people who can run the report
with Department = 1 are not allowed to run the report as Department = 2.
Previously I believe the answer was to use the "UserId" in my reports,
which would be populated with the current users Username, but we
already have a very complex system for determining peoples rights to
different things on our intranet site.
People can delegate rights to others, people get rights based on their
project assignments, people get rights based on their position in the
company, people get rights based on who they report to, and who reports
to them, and on and on.
So all I need to know to validate is username (or userID), what report
they are running, and what parameters they are supplying.
Is there any way to do this?Would a query based parameter work for you where you use a stored procedure
to return a list of valid parameters that they can use for that report based
on who they are and what rights they have inherrited?
Steve MunLeeuw
"cmay" <cmay@.walshgroup.com> wrote in message
news:1161293948.030847.304270@.m73g2000cwd.googlegroups.com...
>I am trying to implement some type of security based on the user, the
> report, and what parameters the are supplying.
> So lets say that I have a report called "Salary Report" that shows
> employees salary and bonus data. The people who can run the report
> with Department = 1 are not allowed to run the report as Department => 2.
> Previously I believe the answer was to use the "UserId" in my reports,
> which would be populated with the current users Username, but we
> already have a very complex system for determining peoples rights to
> different things on our intranet site.
> People can delegate rights to others, people get rights based on their
> project assignments, people get rights based on their position in the
> company, people get rights based on who they report to, and who reports
> to them, and on and on.
> So all I need to know to validate is username (or userID), what report
> they are running, and what parameters they are supplying.
> Is there any way to do this?
>

Monday, February 20, 2012

Questions to the Microsoft guys about the custom assembly

Hi Guys,

I created a custom assemy and added a reference to it in my report, but when I built the report, it told me that the system could not find the file. I followed the steps in the MSDN when I did the above steps. Can anybody tell me why?

Another question is about the location of the assmbly that I should copy. In the Debugging Custom Assemblie chapter on MSDN, it tells to copy my assembly to

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.

But in Deploying a Custom Assembly chapter, it tells me to copy it to

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

Can Microsoft guys tell me which is correct?

Thanks in advance.

Danny

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies is the correct location for the report designer in BI Development Studio.

-- Robert

|||

Hi Robert,

Thank you very much for your answer. My another question is I can only refer to my custom assembly when I use strong name for the assembly and put it into GAC. Or else, the report designer just told me that the file or its dependecies counld not be found. But put the assembly into the GAC means I cannot debug my assembly. Could you give me some tips on this? (I followed all the steps I could find on the MSDN)

Thanks in advance.

Danny